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 change the read/write mode, existing connections are closed. Make sure that
your application can automatically reconnect to the PolarDB for PostgreSQL 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.
- If you set Read/write Mode 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 unavailable, 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 Consistency levels.
- If you set Read/write Mode 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 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).
|