ApsaraDB RDS:Configure the read attribute for a secondary RDS instance

Prerequisites

• Your RDS cluster meets the following requirements:

  • The RDS cluster runs SQL Server 2017 EE (Always On), SQL Server 2019 EE (Always On), or SQL Server 2022 EE (Always On).

  • The RDS cluster runs RDS Cluster Edition.

  • The RDS cluster uses enhanced SSDs (ESSDs) or general ESSDs.

  Note

  You can go to the Basic Information page of the RDS cluster to view the preceding information.

• The read/write splitting feature is enabled for the RDS cluster. For more information, see Enable the read-only routing endpoint to implement read/write splitting.

Usage notes

• After you create an RDS cluster, a secondary node is automatically provisioned and is read-only by default. Therefore, an RDS cluster consists of one primary node and one read-only node.

• After you enable read/write splitting for a primary node, you can specify read weights for the primary node, secondary node, and read-only RDS instances. For more information, see Procedure.

• If you use an existing RDS cluster and enable the read/write splitting feature for the primary node, the secondary node in the RDS cluster is readable by default. If the read/write splitting feature is disabled, you must enable the feature and configure a read-only routing endpoint. For more information, see Procedure.

Procedure

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

2. In the left-side navigation pane, click Cluster Management.

3. Click Configure Readonly Splitting Address in the Basic Information section to configure read weights.

4. Click OK.

Related operations