> 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
