RO Group of Read-only Instance

Operation Scenario

TencentDB for MySQL allows you to create one or more read-only instances to form an RO group, which is suitable for read/write separation and one-master-multiple-slave application scenarios and capable of greatly enhancing the read load capacity of your database.

Prerequisites

• A master instance should be created before a read-only instance can be created. For more information, see Purchase Guide.
• Before use, a TencentDB for MySQL instance needs to be initialized. For more information, see Initializing a TencentDB for MySQL Instance.

Directions

Creating an RO Group

1. Log in to the TencentDB for MySQL Console.
2. In the instance list, select the instance for which to create a read-only instance and click Manage in the "Action" column.
3. On the instance details page, click Add a Read-only Instance in the instance architecture to enter the read-only instance management page.
   
4. On the read-only instance page, click Create to create a read-only instance.
5. Select the desired configuration of the instance on the purchase page. After confirming that everything is correct, click Purchase Now.

   If the "Specified RO Group" option is configured as Create an RO group, the following basic information of the new RO group should be entered on the purchase page.

   • Set RO Group Name: The group name doesn't have to be unique and can contain up to 60 letters, digits, "-", "_", and ".".
   • Remove Instance When Delay Exceeds Threshold: This option indicates whether to enable the removal policy. If a read-only instance is removed when its delay exceeds the threshold, it will become inactive, its weight will be set to 0 automatically, and warning notifications will be sent out. The instance will be put back into the RO group when its delay falls below the threshold. No matter whether this option is enabled, a read-only instance that is removed due to instance failure will rejoin the RO group when it is repaired.
   • Delay Threshold: Set a delay threshold for a read-only instance. When the threshold is exceeded, the instance will be removed from the RO group.
   • Minimum Number of Retained Instances: This is the minimum number of instances that have to be retained in the RO group. When there are fewer instances in the RO group, even if an instance exceeds the delay threshold, it will not be removed.
     

   • Specify an RO group.

     Specify an RO group	Description
     Automatically assigned by the system (not specified)	If multiple instances are purchased at a time, each instance will be distributed to an independent RO group, and their weights will be allocated by the system automatically by default.
     Create an RO group	Create an RO group. If multiple instances are purchased at a time, all of them will be assigned to this new RO group, and their weights will be allocated by the system automatically by default.
     Existing RO group	Specify an existing RO group. If multiple instances are purchased at a time, all of them will be assigned to this RO group. Their weights will be allocated as configured in the RO group. If automatic allocation by the system is set for the RO group, the instances will be added to the group automatically according to the purchased specifications. If custom allocation is set, their weight will be zero by default. As the same private network address is shared within an RO group, if a VPC is used, the same security group settings will be shared. If an RO group is specified, it is not possible to customize any security group when purchasing instances.

   • Billing method: Two billing methods are available for read-only instances for the time being: monthly subscription and pay as you go.
   • Select an instance specification and required disk capacity.
     
6. Return to the instance list to view the created instance whose status is delivering.
7. After the instance is delivered successfully, its status will become running. If the following prompt is displayed upon login, the instance has been created successfully.
   

Configuring an RO Group

On the RO group configuration page, you can configure the basic information of the group such as name, removal policy, delay threshold, minimum number of retained instances, and read weight.

• Read-only instances in an RO group can use different specifications and their read traffic weights can be set.
• Read-only instances in the same RO group can have different expiration dates and billing methods.

1. On the instance list page, select the master instance for which to set an RO group and click Manage in the Action column.
2. On the RO Group Management tab on the read-only instance page, click Configure to enter the read-only instance RO group configuration page.
   
3. Configure the RO group options.
   
   • RO Group Name: The group name doesn't have to be unique and can contain up to 60 letters, digits, "-", "_", and ".".
   • Remove Instance When Delay Exceeds Threshold: This option indicates whether to enable the removal policy. If a read-only instance is removed when its delay exceeds the threshold, it will become inactive, its weight will be set to 0 automatically, and warning notifications will be sent out.
   • Delay Threshold: Set a delay threshold for a read-only instance. When the threshold is exceeded, the instance will be removed from the RO group.
   • Minimum Number of Retained Instances: This is the minimum number of instances that have to be retained in the RO group. When there are fewer instances in the RO group, even if an instance exceeds the delay threshold, it will not be removed.
   • Read Weight Allocation: The RO group supports two weight allocation methods: automatic allocation by the system and custom allocation. The weight value must be an integer between 0 and 100. Below is the list of read weights automatically set for High-IO TencentDB for MySQL instances by the system:

     Instance Specification	Weight
     1,000 MB memory	1
     2,000 MB memory	1
     4,000 MB memory	2
     8,000 MB memory	2
     12,000 MB memory	4
     16,000 MB memory	4
     24,000 MB memory	8
     32,000 MB memory	8
     48,000 MB memory	10
     64,000 MB memory	12
     96,000 MB memory	14
     128,000 MB memory	16
     244,000 MB memory	26
     488,000 MB memory	50

   • Load Rebalancing:
     If load rebalancing is disabled, modifying weight will take effect only for new loads but not affect the read-only instances accessed by existing persistent connections or cause short disconnection from the database.
     If load rebalancing is enabled, a short disconnection lasting for just seconds will occur to disconnect all connections from the database, and the loads of newly added connections will be balanced according to the set weights.

Terminating and Deleting an RO Group

• RO groups cannot be deleted manually.
• An RO group will be automatically deleted when the last read-only instance in it is terminated completely.
• Empty RO groups cannot be retained.