The SQL-based load-balancing layer

The network load-balancer layer is now mature enough, as it can distribute and process requests via protocol header identification, weight calculation, and current limiting. Nevertheless, the industry currently still lacks a load-balancer layer suitable for SQL.

Currently, there isn't a load-balancing layer that can understand SQL, which means that a lack of SQL interpretation causes unsatisfactory granularity of request dispatching in any database system. Developing a Smart SQL Load Balancer (LB) solution capable of understanding SQL is the best solution to supplement the database load-balancer layer.

In addition to common load-balancer features such as high performance, traffic governance, service discovery (SD), and high availability (HA), Smart SQL LB also has the capability to parse SQL and calculate query costs.

When it really understands SQL characteristics and query costs, its next move is to label computing nodes and even...