Read/write Mode |
The read/write mode for the custom cluster endpoint. Read Only and Read and Write (Automatic Read-write Splitting) are available.
Note After you modify the read/write mode, existing connections to the cluster endpoint
are closed. Make sure that your applications can automatically reconnect to the PolarDB-O
cluster.
|
Reader Nodes |
The nodes that you associate with the cluster endpoint to process read requests. You
can select the primary node and read-only nodes in the Unselected Nodes section.
Note
- If you set Read/write Mode to Read and Write (Automatic Read-write Splitting), you must select at least two nodes, including the primary node.
- When the read/write mode is set to Read Only, you can create single-node endpoints. However, if you create a single-node endpoint
for a read-only node and the read-only node becomes faulty, the single-node endpoint
may be unavailable for up to one hour. We recommend that you do not create single-node
endpoints in your production environment. We recommend that you select at least two
nodes for processing read requests to improve cluster availability.
|
Automatically Associate New Nodes |
Specifies whether a new node is automatically associated with the cluster endpoint. |
Load Balancing Policy |
The policy for scheduling read requests among multiple read-only nodes if read/write
splitting is enabled. The default value is Load-based Automatic Scheduling and cannot be changed.
|
Consistency Level |
- If you set Read/write Mode to Read and Write (Automatic Read-write Splitting), the following consistency levels are available: Eventual Consistency and Session Consistency (Recommended). For more information, see PolarDB-O consistency levels.
- If the read/write mode is set to Read Only, the default consistency level is Eventual Consistency and cannot be changed.
|
Offload Reads from Primary Node |
After this feature is enabled, SQL query statements are sent to only read-only nodes.
This reduces the load on the primary node and ensures the stability of the primary
node.
Note You can configure this feature only after you set Read/write Mode to Read and Write (Automatic Read-write Splitting).
|
Transaction Splitting |
Specifies whether to enable the transaction splitting feature. For more information,
see Configure transaction splitting.
Note You can configure this feature only after you set Read/write Mode to Read and Write (Automatic Read-write Splitting).
|