Re: Use of slave server for read only queries

2007-09-07 Thread Shawn Green
Ashok Chauhan 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 ?. Thanks Ashok The simple wa

Re: Use of slave server for read only queries

2007-09-07 Thread Augusto Bott
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:3

Re: Use of slave server for read only queries

2007-09-07 Thread dave
> 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

Re: Use of slave server for read only queries

2007-09-06 Thread Vetle Roeim
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 q

Use of slave server for read only queries

2007-09-06 Thread Ashok Chauhan
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 ?. Thanks Ashok -- MySQL General Mailing List For lis