Introduction to Proxy Basic Information
After the database proxy is enabled, you can manage it by referring to the following configuration.
Operation Method
1. Log in to the eSurfing Cloud official website.
2. Click Console in the upper right corner to jump to the Console page.
3. Click the resource pool selection box in the upper left corner to select the Region.
4. In the database category, find RDS-PostgreSQL and click to go to the RDS-PostgreSQL Console.
5. Click the List of Instances menu on the left menu bar, select the corresponding instance on the List of Instances page, and click the Manage button to go to the Instance Details page.
6. Select the Database Proxy tab.
7. Locate the Connection Address bar and click the Modify button.
8. In the pop-up box, modify and configure the grouping type, weight, and other information. Then, click the Confirm button.
Basic Information
The specific meaning of the basic information of the database proxy is as follows:
• Running status: Proxy running status.
• Primary instance: Database instance name.
• Number of enabled services: Number of database proxies enabled by the current database instance.
Link Address
The connection information for the database proxy is as follows:
• Proxy grouping: ID of the proxy instance.
• Proxy mode: The current operation mode of the proxy instance supports read/write separation and read-only mode.
• Connection address: The connection address of the proxy, usually the VIP of the proxy.
• Proxy port: The connection port for the proxy.
• Delay threshold settings: The maximum delay allowed when a read-only instance or slave node synchronizes data from the primary instance.
• Operation: Detailed configuration management entrance of proxy group.
Proxy List
The node information of the database proxy is as follows:
• IP: The actual running IP for the database proxy instance.
• Installation directory: The actual installation path of the database proxy instance.
• Version number: the version number of the database proxy instance.
• Status: The current running status of the database proxy instance.
• Start time: Start time of the database proxy instance.
• Run Time: Actual running time after the database proxy instance is started.
Proxy Grouping Description
The configuration information of the database proxy read/write separation configuration information, as follows:
• Group ID: Database proxy instance ID.
• Type of grouping: Database proxy running mode. The read-only mode and read/write separation mode are supported.
– Read/write separation: The primary instance and the read-only instance are connected at the same time, and write requests can be accepted. Write requests are only sent to the primary instance, and read weights can be assigned to the standby nodes of the primary instance.
– Read-only: Requires at least one read-only instance. Only the read-only instances can be connected, and write requests are not accepted. Read permission cannot be assigned to the primary instance.
• Delay Threshold Settings: The maximum delay allowed when a read-only instance or slave node synchronizes data from the primary instance. If the latency time of a node exceeds this value, the database proxy will not forward the request to the node, regardless of the weight of the node. The range is from 0 to 360 seconds.
• Allocation of Read-write Separation Weights: Proportionally, nodes with higher weights handle more read requests. Support system assignment and customization modes.
– System Assignment: The system automatically allocates the read weight of each node according to the instance specification. Subsequent read-only instances added under the primary instance will also be automatically configured according to the weight assigned by the system, without the need for manual setting. For specific weight assignment methods, see Weight Assignment Rules of Database Proxy System.
– Customize: Manually set the read weight of each instance, ranging from 0 to 10,000. All nodes cannot be 0. The read weight of the new read-only instance under the primary instance defaults to 0, which needs to be manually modified.