how to proxy sql queries (INSERT, UPDATE e.t.c.)
- by XakRu
I have installed cluster MYSQL (galley with mariadb)
As an application server installed Apache. on a server with Apache installed haproxy which proxies requests from php in this case installed for zabbix server cluster. But faced with deadlocks, now I want to proxy requests WRITE, INSERT, UPDATE to the second server. SELECT queries to the second and third server. I would be happy to see your suggestions. Please do not write: use mysql - proxy.
I want to see what program it may to proxy SQL requests.
scheme: http://www.gliffy.com/pubdoc/4474830/L.png