docs
udb-mysql
rwrouter
Functional Superiority

Functional Advantages

Business Transparent Access

In the original master-slave node mode, the master UDB node and each slave node have a separate connection address. Users need to configure and manage each address separately in the business program to send write requests to the master UDB node and read requests to the slave nodes.

The read-write separation middleware of UDB integrates multiple master-slave nodes into a cluster, and by providing an additional read-write separation address, you can perform read-write operations on the master-slave nodes. The forwarding logic of read-write statements is completely transparent to the business, reducing maintenance costs.

Dual-Active High Availability

Compared to the single-node deployment mode of open-source read-write separation middleware in the industry, UDB read-write separation Proxy adopts dual-active deployment. The front end uses the distributed load balancing product ULB for load balancing and disaster recovery, the entire Proxy layer has no single point, ensuring high availability and stability.

Easy Management

The read-write separation feature can be enabled/released with one click on the console, and four read request distribution modes are provided for customers to flexibly choose and configure according to business needs. These four modes are:

1. Master node: Read requests are sent only to the master node, and no requests are sent to the slave nodes;

2. Node balance: Read requests are evenly distributed to the master and slave nodes;

3. Read-only node balance: Read requests are evenly distributed to all slave nodes, but not to the master node;

4. Custom: Customers define the distribution ratio of read requests.

Automatic Fault Tolerance

The read-write separation Proxy will perform health checks on all nodes of the master-slave replication cluster. When the master node is found to be unavailable, it will refuse to send write requests and system commands to the master node. When it finds that the slave node is unavailable or the data delay with the master node exceeds the threshold (this threshold can be configured), it will remove the unavailable slave node from the distribution target list until the slave node recovers or the data delay is lower than the threshold, before adding it back to the distribution target list.

Permanently Free

The UDB read-write separation function is permanently free for all customers, and customers do not need to pay any additional fees.

  • Company
  • ContactUs
  • Blog
Copyright © 2024 SurferCloud All Rights Reserved