Re: Use of slave server for read only queries

> On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan <ashok.linux@gmail.com>
> 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/replication?unsub=lists@pantek.com