TencentDB for MySQL Database Proxy

What TencentDB for MySQL Database Proxy is

TencentDB for MySQL Database Proxy sits between an application and TencentDB for MySQL, relaying database requests through a separate proxy address. One application connection address can route reads to read-only instances and writes to the source instance. Connection pooling can reduce load from frequent or excessive connections, while transaction splitting can send reads and writes within a transaction to different instances to reduce load on the source. A multi-node cluster deployed across availability zones supports failover and availability. Proxy resources are isolated per instance, and each proxy can process up to 100,000 requests per second. Nodes can be scaled from 1 to 60, and request, CPU, and memory metrics are monitored at second-level granularity. Configuration can be hot-loaded after source switches, configuration changes, or read-only instance changes without network disconnections or restarts. The managed service supports MySQL 5.7 and 8.0 and the TencentDB for MySQL read-only analysis engine. A 15-day trial promotion is listed; there is no free plan. Pay-as-you-go pricing is listed as $0.07 a month, with billing described as $0.06865672 per CU per hour in specified regions; other regions have different prices.

Who it suits

It suits teams running supported TencentDB for MySQL versions that need request routing, connection pooling, or load balancing. It is also relevant where proxy-node scaling and failover are required.

Limits

There is no free plan. Connection pooling requires MySQL 5.7 kernel minor version 20211030 or later, or MySQL 8.0 kernel minor version 20230630 or later. With network forwarding enabled, adaptive load balancing, connection pooling, and transaction splitting are unsupported.

Getting started

1. Visit the Tencent Cloud product page.
2. Use a supported TencentDB for MySQL database version or read-only analysis engine.
3. Connect the application through the proxy address.
4. Choose balanced distribution or nearby access.
5. Scale the proxy node count as needed.

Verdict

The proxy provides routing, pooling, scaling, and failover for supported TencentDB for MySQL deployments. Check the version requirements for connection pooling and the forwarding limitations before choosing an access configuration.