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.
If the "Specify RO Group" option is configured as Create RO group, the following basic information of the new RO group should be entered on the purchase page.
- Group Name: the RO group name doesn't have to be unique and can contain up to 60 letters, digits,
-
,_
, and.
.- Eliminate Instances with Out-of-limit Delay: 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 (for more information on how to configure the RO instance elimination alarm and recipients, please see Alarming Feature). 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.
- Min 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 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 ID 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. |
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.
-
, _
, and .
.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 |
Was this page helpful?