Oracle Cloud Infrastructure Documentation

Creating a Read Replica

Create one or more read replicas on an active DB system.

Using the Console

Use the Console to create a read replica of the DB system.

This task requires the following:
  • A running DB system.
Do the following to create a read replica:
  1. Open the navigation menu and select Databases. Under HeatWave MySQL, click DB systems.
  2. Choose the compartment from the List scope.
  3. Click the name of the DB system to open the DB system details page.
  4. Under Resources, click Read replicas.
  5. Click Create read replica.
  6. In the Create read replica panel, provide the following information:
    • Name: Specify the name of the read replica. If you do not define a name, HeatWave Service generates one for you in the format, MysqlReadReplicaDateTime.
    • Description: (Optional) Specify a description of the read replica.
    • Select a shape: (Optional) Click Select shape to override and change the shape of the read replica. You can select any shape with at least 8 ECPUs or 4 OCPUs. By default, a read replica inherits the shape of the DB system. See Supported Shapes.
      Note

      If the DB system has a shape with less than 8 ECPUs or 4 OCPUs, you must override the read replica shape.
    • Show advanced options: (Optional) Click the option to open a group of tabs that enable you to further configure the read replica.
      • Deletion plan: (Optional) Check the Delete protected box to protect the read replica and its associated DB system against delete operations. By default, read replicas and DB systems are not delete protected. If you want to delete either the read replica or its associated DB system, deselect the option.
        Note

        The delete protected setting applies to individual read replica. If a read replica is delete protected, the DB system cannot be deleted.
      • Configuration:
        • Select a configuration: (Optional) Click Select Configuration to override and change the configuration of the read replica shape.
          Note

          If you changed the shape of the read replica, you must select a configuration that matches the shape.
        • MySQL version: By default, a read replica inherits the version of its associated DB system. You can select a higher version to override the version of the read replica. See MySQL Server Versions.
      • Tags: Use the tab to organize and track resources in the tenancy:
        • Tag namespace: Select the tag name.
        • Tag key: Select the tag key.
        • Tag value: Specify a value for the tag.
        • Add tag: Click this option to add more tags
  7. Click Create read replica.
A read replica is created.