Disable the read-only endpoint when you no longer need read/write splitting or when you are removing secondary nodes from your cluster. Before disabling, confirm that the change will not affect your application's performance or availability.
When to disable:
You are decommissioning read-only secondary nodes from the cluster.
You are restructuring your application architecture and read/write splitting is no longer required.
Prerequisites
Before you begin, make sure that:
Read/write splitting is enabled. For more information, see Enable read/write splitting (read-only endpoint).
Before you disable
After you disable a read-only endpoint—whether unified or secondary node—the endpoint becomes invalid. Applications can no longer use that endpoint to connect to the instance. The public and internal endpoints of the instance are not affected.
Disabling a read-only endpoint causes a transient disconnection lasting less than 30 seconds. Disable the endpoint during off-peak hours and make sure your application has an automatic reconnection mechanism to prevent service interruptions.
After disabling, update your application's connection string to remove any reference to the read-only endpoint.
Each time you re-enable a unified or secondary node read-only endpoint, the new endpoint may differ from the previous one. Update your application's connection string accordingly.
Which procedure to use
| Endpoint type | When to use |
|---|---|
| Unified read-only endpoint | Disables the read/write splitting address for the cluster |
| Secondary node read-only endpoint | Disables the endpoint dedicated to a specific secondary node |
Disable the unified read-only endpoint
Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region where the RDS instance resides. Find the RDS instance and click the instance ID.
In the navigation pane on the left, click Cluster Management.
In the Read-only Network Information section, click Disable Readonly Splitting Address.
In the dialog box, click OK.
Disable the secondary node read-only endpoint
Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region where the RDS instance resides. Find the RDS instance and click the instance ID.
In the navigation pane on the left, click Cluster Management.
In the Secondary Instance Network Information section, click Disable Secondary Instance Endpoint.
In the dialog box, click OK.
What's next
To re-enable read/write splitting or the secondary node read-only endpoint, see Enable read/write splitting (read-only endpoint).