MySQL horizontal partitioning scheme SpockProxy

SpockProxy is an open-source project generated by a real project (Spock is a Rails application, and SpeckProxy should be used outside Rails, such as PHP or. is a branch of MySQLProxy and supports range-basedhorizontalparitioning. His improvements to MySQLProxy include: ). do not

Spock Proxy is an open-source project generated by a real project (Spock is a Rails application, and Speck Proxy should be used outside Rails, such as PHP or. is a branch of MySQL Proxy. It supports range-based horizontal paritioning. His improvements to MySQL Proxy include: ). do not

Spock Proxy is an open-source project generated by a real project (Spock is a Rails application, and Speck Proxy should be used outside Rails, such as PHP or. is a branch of MySQL Proxy. It supports range-based horizontal paritioning. Its Improvements to MySQL Proxy include:

A). Improve performance without using LUA scripts. For example, if you want to set the results returned from multiple data sources and interact with the LUA script during the process, the performance overhead is relatively high.

B) client login verification. MySQL Proxy supports direct login verification between the client and each server. Spock Proxy manages the client in a unified manner and isolates the connection between the client and the server.

C). Dynamic connection pool. Benefits from the improvement of the client login authentication mechanism

Architecture: