ApsaraDB RDS:Configure the nearest access feature for database proxies

Overview

If database proxies are deployed in one zone and you disable the nearest access feature, all service traffic is processed by the database proxies that reside in the same zone and then routed to the backend databases. If the database proxies reside in different zones than the zones of the databases, cross-zone communication is triggered and the response time (RT) is increased. The following figure shows an example.

If database proxies are deployed in two zones and you enable the nearest access feature, only the database proxies deployed in the zone in which the required database proxy endpoint resides can receive, process, and route service traffic. You can add the databases in the same zone to the database proxy endpoint. This ensures that all service traffic is routed in the same zone, which significantly reduce access latency. The following figure shows an example.

Prerequisites

The RDS instance meets the following requirements:

• The RDS instance runs MySQL 5.7 or MySQL 8.0.

• The RDS instance runs RDS High-availability Edition or RDS Cluster Edition.

• The RDS instance uses cloud disks.

• The database proxy feature is enabled for the RDS instance and the following settings are configured for the feature. For more information, see Enable the database proxy feature.

  • The RDS instance use dedicated database proxies.

  • The dual-zone deployment mode is used for the database proxies of the RDS instance.

  • A total of four database proxies are enabled.

Billing rules

You are not charged additional fees when you use the nearest access feature.

Usage notes

• If you enable the nearest access feature, the following impacts occur on the cross-zone migration of database proxies:

  If you enable the nearest access feature and want to migrate database proxies to different zones, you must configure a destination vSwitch for each database proxy endpoint (formerly proxy terminal). After the migration is complete, the settings of each database proxy endpoint remain unchanged. The zone for the nearest access feature is the same as the zone in which the destination vSwitch resides.

• If you enable the nearest access feature, the following impacts occur on the specification change of database proxies:

  The nearest access feature is supported only for four dedicated proxies that are deployed in two zones. If you want to use general-purpose database proxies or change the deployment mode of database proxies, you must disable the nearest access feature. For more information, see Deployment architecture of database proxies.

• The nearest access feature has no impacts on the allocation of read weights.

  The nearest access feature ensures that the business application, the database proxies, and the read-only RDS instances reside in the same zone. This prevents latency caused by cross-zone access. The proxies forward read requests to RDS instances based on the read weights that you specify for the instances. The forwarding is not affected by the nearest access policies.

Enable or disable the nearest access feature

You can enable or disable the nearest access feature based on your business requirements.

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

2. In the left-side navigation pane, click Database Proxy.

3. In the Connection Information section, find the database proxy endpoint that you want to modify and click Modify Configuration in the Actions column.

4. In the dialog box that appears, click Enable or Disable next to the Nearest Access parameter.

Related operations