Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 08-31-2010, 07:20 AM   #1
Registered: Jul 2008
Location: Chennai, India
Distribution: RHEL5, Ubuntu
Posts: 191

Rep: Reputation: 37
MySQL Master-Slave Replication - How to make the slave read-only?

I have setup master-slave MySQL replication, I would like to make sure, that slave database cannot be modified by clients but replication should be done from the master. Is there any way i could make it "read-only"?

Thanks in advance

Last edited by saagar; 08-31-2010 at 07:21 AM.
Old 08-31-2010, 08:13 AM   #2
Registered: Aug 2007
Location: Vietnam
Distribution: RedHat based, Debian based, Slackware, Gentoo
Posts: 724

Rep: Reputation: 100Reputation: 100
Why didn't you prevent clients from modifying the Slave by granting the only SELECT privileges for them.

Edited: Take a look at --read-only option:

Last edited by quanta; 07-30-2011 at 06:21 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Master-SLave Replication?? linuxshadow Linux - Server 7 06-13-2008 09:22 AM
LDAP in master-slave replication aravind1024004 Linux - Networking 1 04-20-2008 12:18 PM
LDAP in master-slave replication aravind1024004 Linux - Server 1 04-10-2008 10:21 PM
Multiple Master to one Slave for MySQL Replication Swakoo Linux - General 0 03-31-2007 04:40 AM
ldap replication master - slave jadid Linux - Software 2 10-18-2006 11:25 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:41 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration