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: 183

Filed under:

proxy

|

sql

|

haproxy

|

cluster

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

Related posts about proxy

DNS lookup failures while accessing my website some proxy error

as seen on Server Fault - Search for 'Server Fault'
Here is a situation until today morning,every thing has been working perfectly fine with me. From past 6 months many of my domains wer accessible as http://site1.myserver.com http://site2.myserver.com http://site3.myserver.com http://site4.myserver.com All these were Reverse Proxy configurations… >>> More
Apache2 mod_proxy to remote Tomcat7 - slow response

as seen on Server Fault - Search for 'Server Fault'
Been stuck with this one for a few days. Will try to provide as much information as possible, but please feel free to ask for extra detail. I have 2 VMs behind a NAT, 192.168.0.100 and 192.168.0.102, both running Ubuntu 11.04 x64. The first one is mapped to the exterior and is our webserver, has… >>> More
How to set a proxy for Webbrowser Control without effecting the SYSTEM/IE proxy

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I set a proxy for a Webbrowser Control without setting a proxy for IE. Basically I want my application to use a certain proxy however obviously I don't want to change user's IE proxy settings. >>> More
Difference between proxy server and reverse proxy server

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the difference between proxy server and reverse proxy server? >>> More
[MAJ] Transformer APACHE 2.0 en Proxy HTTP - Comment utiliser le Module Proxy d'Apache

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification du script suite ? l'alerte concernant la possibilit? offerte ? n'importe qui d'utiliser le moteur APACHE comme proxy sans aucun contr?le. >>> More

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More