The access mode is mainly used to control the connection link between applications or clients and the database proxy. It is divided into two modes: balanced distribution and nearby access. The following introduces the rules, advantages, and disadvantages of the two access modes of TencentDB for MySQL database proxy.
Prerequisites
The database architecture is two-node (except economical), three-node, and Cluster Edition.
Balanced Distribution
Rule: In the Balanced Distribution access mode, the client application connects to all available database proxy nodes. If the database proxy nodes are spread across multiple availability zones, application connections to the database are evenly distributed among all availability zone nodes.
Advantage: Traffic is evenly distributed, resolving the issue of excessive load on a single node.
Disadvantages: If there are proxy nodes in different availability zones, high request latency is prone to occur due to extended access paths.
Nearby Access
Rules: In nearby access mode, applications will connect to the database proxy node in the same availability zone (AZ) or with the shortest access path. If the database proxy nodes exist in multiple AZs, applications still select the database proxy node with the shortest access path to connect.
Advantage: Low access latency and high speed.
Disadvantage: If your client application changes to an availability zone with fewer database proxy nodes than the original zone, it can lead to excessive load on the nodes and performance delays.
Changing Access Mode