Afficher un message
Vieux 07/09/2007, 17h26   #4
Augusto Bott
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Use of slave server for read only queries

It seems that the trunk version supports RO/RW splitting:
http://jan.kneschke.de/2007/8/1/mysq...-r-w-splitting and
http://jan.kneschke.de/2007/8/26/mys...-r-w-splitting

--
Augusto Bott

On 9/7/07, dave@cpfc.org <dave@cpfc.org> wrote:
>
> > 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
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?u...bott@gmail.com
>
>


  Réponse avec citation
 
Page generated in 0,05614 seconds with 9 queries