how to proxy sql queries (INSERT, UPDATE e.t.c.)
Posted
by
XakRu
on Server Fault
See other posts from Server Fault
or by XakRu
Published on 2013-04-11T13:39:35Z
Indexed on
2013/11/07
9:58 UTC
Read the original article
Hit count: 182
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
© Server Fault or respective owner