MySQL Horizontal Partitioning Scheme Spock Proxy

Spock Proxy is an open source project generated by the actual project (Spock is the application of rails, Speck proxy should be available for use outside of rails, such as PHP or. NET), based on MySQL proxy development, is a branch of MySQL proxy, With support for range-based horizontal paritioning, his improvements to MySQL proxy include:

a). Do not use LUA scripts to improve performance. For example, the result set returned by multiple data sources is also interacting with the Lua script during the merge, which has a higher performance cost

b). client logon authentication. MySQL Proxy supports client to authenticate with each server directly, Spock Proxy will manage it and separate the connection between client and server.

c). Dynamic Connection pool. Benefit from the improvement of the client login authentication mechanism

Architecture diagram: