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
signature.asc
Description: PGP signature