PHWinfo - Afficher un message - Use of slave server for read only queries

07/09/2007, 09h50

> 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_Pr...from_writes.3F

Which is a real shame because I can't see that sqlrelay can do this either

http://sqlrelay.sourceforge.net/sqlr...lfailover.html

Dave

07/09/2007, 09h50	#3
dave@cpfc.org Messages: n/a Hébergeur:	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_Pr...from_writes.3F Which is a real shame because I can't see that sqlrelay can do this either http://sqlrelay.sourceforge.net/sqlr...lfailover.html Dave