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

07/09/2007, 21h46

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 way is to use the --read-only startup parameter on the slave.
The only updates it will allow must come through replication or from a
SUPER user.

http://dev.mysql.com/doc/refman/5.0/...sqld_read_only

--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html

07/09/2007, 21h46	#5
Shawn Green Messages: n/a Hébergeur:	Re: Use of slave server for read only queries 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 way is to use the --read-only startup parameter on the slave. The only updates it will allow must come through replication or from a SUPER user. http://dev.mysql.com/doc/refman/5.0/...sqld_read_only -- Shawn Green, Support Engineer MySQL Inc., USA, www.mysql.com Office: Blountville, TN __ ___ ___ ____ __ / \|/ /_ __/ __/ __ \/ / / /\|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ <___/ Join the Quality Contribution Program Today! http://dev.mysql.com/qualitycontribution.html