Creating Read Replicas in Batches

Scenarios

Read replicas are used to enhance read capabilities and reduce the load on primary DB instances. On the Instances page, you can select one or more MySQL DB instances and create read replicas for them in batches.

Constraints

• To create read replicas in batches, contact customer service to apply for required permissions.
• A maximum of 10 read replicas can be created for a DB instance.
• You can create read replicas for a maximum of 50 MySQL DB instances.
• You can create read replicas in batches only for DB instances of the same DB engine version and CPU architecture. For details about the supported instance classes and CPU architectures, see RDS for MySQL Instance Classes.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, select one or more DB instances and choose More > Create Read Replica above the instance list.
5. On the displayed page, configure required information and click Next.
   • By default, read replicas are named with "read" and two digits appended to the primary DB instance name. For example, if the primary instance name is instance-0001, the first read replica will be named instance-0001-read-01.
   • The VPC and storage configurations are the same as those of the primary DB instance.
   • Each account can create no more than 5 read replicas total for any given DB instance. In a batch creation, the number of read replicas you can create is limited by whichever DB instance already has the most replicas.

     For example, in a batch creation where most of the DB instances only have a single read replica, if any DB instance in the batch has more than one, for example, 3, you would only be able to add 2 more replicas for each DB instance in that particular batch operation.

6. Confirm specifications.
   • If you need to modify your settings, click Previous.
   • If you do not need to modify your settings, click Submit for pay-per-use read replicas.
   • For yearly/monthly read replicas, click Pay Now.

7. After read replicas are created, you can view and manage them.

   For details about how to manage read replicas, see Managing a Read Replica.

   You can view the detailed progress and result of the task on the Task Center page. For details, see Task Center.

Follow-up Operations

Managing a Read Replica