LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   MySQL Master-Slave Replication - How to make the slave read-only? (http://www.linuxquestions.org/questions/linux-server-73/mysql-master-slave-replication-how-to-make-the-slave-read-only-829499/)

saagar 08-31-2010 07:20 AM

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

quanta 08-31-2010 08:13 AM

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: http://dev.mysql.com/doc/refman/5.1/...sqld_read-only


All times are GMT -5. The time now is 09:44 AM.