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 a DB system.

This task requires the following:
  • A running DB system.
Do the following to create a read replica:
  1. On the DB systems list page, select the DB system that you want to create a read replica for. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.
  2. On the details page, select the Read replicas tab or resource and then select Create read replica.
  3. In the Create read replica panel, enter the following information:
    • Create in compartment: The compartment in which the DB system is created. If you start from the Overview page, you can change the compartment.
    • 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.
    • DB system: The DB system from which the read replica will be created. If you start from the Overview page, select Select DB system to choose a DB system that resides in the compartment.
      Note

      If the DB system is created in another compartment, you can change the compartment in the Create in compartment field.
    • Shape: (Optional) Select 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.
    • Configuration:
      • Select a configuration: (Optional) Select 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.
    • Network security groups: (Optional) Select to enable overriding the network security groups of the DB system. When enabled, do the following to select network security groups that you want to use with this read replica:
      • Compartment: Select a compartment in which the network security group is configured.
      • Network security group: Select a network security group that you want to use.
      • To add multiple network security groups, select the Another network security group button to add another row.
        Note

        You can add up to a maximum of 5 network security groups.
    • Deletion plan: (Optional) Enable 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, Delete protected must be disabled.
      Note

      The delete protected setting applies to individual read replica. If a read replica is delete protected, the DB system cannot be deleted.
    • 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: Select this option to add more tags
  4. Select Create read replica.
A read replica is created.