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 MySQL HeatWave, 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, MySQL 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 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 uses the same shape as the DB system. See Supported Shapes.
      Note

      If the DB system has a shape with less than 8 ECPUs or 4 OCPUs, you must change 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 change the configuration of the read replica shape.
          Note

          If you changed the shape of the read replica, you must select a configuration.
        • MySQL version: Select the MySQL version of the read replica. By default, a read replica uses the same MySQL version as its associated DB system. 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.