You can create custom cluster endpoints for PolarDB for PostgreSQL clusters. You can specify cluster endpoint settings, such as the read/write mode, the consistency level, and the associated read-only nodes, to meet your business requirements and improve service flexibility. This topic describes how to create a custom cluster endpoint for a PolarDB for PostgreSQL cluster.
Procedure
FAQ
- How do I create a single-node endpoint?
You can create a single-node endpoint only if the read/write mode of the cluster endpoint is set to Read Only and the cluster has at least three nodes. The reader nodes of the single-node endpoint can be only read-only nodes. For the detailed procedure, see Procedure.Warning 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 1 hour. We recommend that you do not create single-node endpoints in the production environment.
- What is the maximum number of single-node endpoints that I can create for a cluster?
If your cluster has three nodes, you can create a single-node endpoint for only one of the read-only nodes. If your cluster has four nodes, you can create two single-node endpoints for two of the read-only nodes, one for each read-only node. Similar rules apply if your cluster has five or more nodes.
- If a single-node endpoint is created for a read-only node, can the read-only node
function as the new primary node during a failover in the event of a system exception?
No, the read-only node that has a single-node endpoint configured cannot automatically function as the new primary node during a failover. However, you can manually preform a switchover to specify the read-only node as the new primary node. For more information, see Perform a switchover.
- What is the maximum number of cluster endpoints that a cluster can have?
A cluster can have a maximum of four cluster endpoints, one of which is the default cluster endpoint and the other three are custom cluster endpoints.
- Can I modify a cluster endpoint?
Yes, you can modify the settings of the default cluster endpoint and the custom cluster endpoints. For more information, see Modify a cluster endpoint.
- Can I delete a cluster endpoint?
Yes, you can delete only custom cluster endpoints. You cannot delete the default cluster endpoint. For more information, see Delete a custom cluster endpoint.
Related API operations
API | Description |
---|---|
CreateDBClusterEndpoint | Creates a custom cluster endpoint. |
DescribeDBClusterEndpoints | Queries cluster endpoints. |