Plan reference Mysql-proxy Write Mssql-proxy

Currently, Haproxy has been used to load balance the MSSQL read library, which runs well in the production environment.

However, this scenario has drawbacks: the client needs to choose whether to use a read library or a write library. This is still not convenient, if you can implement automatic routing is better, that is, let Haproxy automatically choose to send the request to read library or write library.

I plan to write a haproxy module that implements the automatic routing function in this module. After writing, open up the module.

To do this, you need to overcome the following two technical difficulties:

(1) Haproxy module writing method.

(2) TDB agreement.

PS: A software named SQL Server Proxy has been found on the network, but it is closed source and charged.

Plan reference Mysql-proxy Write Mssql-proxy