Hi
On Sat, 24 Oct 2009 16:01:26 -0400, Joseph Hardeman
<jharde...@colocube.com> wrote:
> Hey Guys,
> 
> I was wondering if there was a way to have Haproxy handle mysql 
> requests.  I know that I can use the TCP option instead of HTTP and
> it will work, but I was wondering if anyone has a way to make haproxy
> send all requests for Select statements to a set of servers and all
> Insert, Updates, and Deletes to a master MySQL server.
> 
> I was just thinking about it and was wondering if this was possible
> and if anyone has done it.  If you have would you be willing to share
> how your setup is.
U can't do that, u either have to use something like 
http://forge.mysql.com/wiki/MySQL_Proxy_RW_Splitting
or (better) rewrite ur app to split write and read requests

Regards
Mariusz
-- 
Mariusz Gronczewski (XANi) <xani...@gmail.com>
GnuPG: 0xEA8ACE64
http://devrandom.pl

Attachment: signature.asc
Description: PGP signature

Reply via email to