Re: Force replication slaves READ-ONLY
Posted by:
Pedro Ribeiro ()
Date: August 29, 2004 11:29AM
Ok, i'v found it deep in the documentation PDF.
Here goes to anyone who needs the same "feature".
Quoting:
######################################################
read_only
When the variable is set to ON for a replication slave server, it causes the slave
to allow no updates except from slave threads or from users with the SUPER
privilege. This can be useful to ensure that a slave server accepts no updates
from clients. This variable was added in MySQL 4.0.14.
######################################################
Sorry, you can't reply to this topic. It has been closed.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.