It seems that the trunk version supports RO/RW splitting: http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting and http://jan.kneschke.de/2007/8/26/mysql-proxy-more-r-w-splitting
-- Augusto Bott On 9/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan <[EMAIL PROTECTED] > > > > wrote: > > > >> Hi All, > >> > >> I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and > 8GB > >> of RAM. > >> Master & Slave servers have same hardware configration. > >> > >> Now i want to know, should i use slave server for fetching read only > >> queries. > >> if yes, then how ?. > > > > You could do it in the application logic, i.e. create a separate > > connection to the slave server that you use for reading, or perhaps this > > would be a good use of the MySQL Proxy <URL: > > http://forge.mysql.com/wiki/MySQL_Proxy >. > > This doesn't look like it will work just yet > > > http://forge.mysql.com/wiki/MySQL_Proxy_FAQ#In_load_balancing.2C_how_can_I_separate_reads_from_writes.3F > > Which is a real shame because I can't see that sqlrelay can do this either > > http://sqlrelay.sourceforge.net/sqlrelay/loadbalfailover.html > > Dave > > > -- > MySQL Replication Mailing List > For list archives: http://lists.mysql.com/replication > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >