Starting August 29, 2024, if the database proxy version of your ApsaraDB RDS for MySQL instance is 2.9.1 or later, you can configure connection pooling and latency threshold settings for database proxy endpoints set to read-only, in addition to read/write endpoints.
Feature description
The database proxy supports connection pooling and latency threshold settings on both read/write and read-only endpoints.
Connection pooling: Select a connection pool type to reduce the connection frequency between your application and the RDS instance, lower main thread overhead, and limit the total number of connections. For details, see Configure the connection pooling feature.
Latency threshold: Set a replication latency threshold for a database proxy endpoint. If the replication latency of a read-only RDS instance exceeds the threshold, requests are not forwarded to that instance.
The endpoint types that support these settings depend on the database proxy version:
| Database proxy version | Supported endpoint types |
|---|---|
| Earlier than 2.9.1 | Read/write endpoints only |
| 2.9.1 or later | Read/write and read-only endpoints |
Effective date
August 29, 2024
Billing
No additional fees apply for connection pooling and latency threshold settings. For details, see Billing rules for database proxies.
Prerequisites
Before you begin, ensure that you have:
An RDS instance running MySQL 5.6, 5.7, or 8.0
RDS High-availability Edition or RDS Cluster Edition
Cloud disks or local disks
The database proxy feature enabled with version 2.9.1 or later. For details, see Enable the database proxy feature
If the RDS instance uses RDS High-availability Edition, you must create at least one read-only RDS instance for the primary RDS instance. For details, see Create a read-only ApsaraDB RDS for MySQL instance.
Configure connection pooling and latency threshold settings
Go to the Instances page. In the top navigation bar, select the region where the RDS instance resides. Find the instance and click its ID.
In the left-side navigation pane, click Database Proxy.
In the Connection Information section, find the database proxy endpoint to modify and click Modify Configuration in the Actions column.
In the dialog box, configure the connection pooling and latency threshold settings.
Click OK.