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:
- Do one of the following to open the Create read replica panel:
- If you want to start from the DB system details page:
- Open the navigation menu and select Databases. Under HeatWave MySQL, click DB systems.
- Choose the compartment from the List scope.
- Click the name of the DB system to open the DB system details page.
- Under Resources, click Read replicas.
- Click Create read replica.
- If you want to start from the Overview page:
- Open the navigation menu and select Databases. Under HeatWave MySQL, click Overview.
- Click Create read replica.
- If you want to start from the DB system details page:
- In the Create read replica panel, provide 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, click 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) 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 override the shape of the read replica, you must select a configuration that matches the selected 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.
- Select a configuration: (Optional) Click Select Configuration to override and change the configuration of the read replica shape.
- 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
- 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.
- Click Create read replica.
A read replica is created.