List:General Discussion« Previous MessageNext Message »
From:Rod Heyd Date:June 14 2006 5:55pm
Subject:Trouble with read-only
View as plain text  
Hello,

I'm trying to set up a replication slave as read-only, but the read-only
part doesn't seem to be working.

Replication between the master and the slave works fine.  I have added the
read-only keyword to the slave's my.cnf, and looking at the output of show
variables indicates that read-only is set to 'ON'  So as far as I can tell,
it I should not be able to connect to the slave and insert rows into my
tables.  However, I AM able to insert rows into the tables.

Have I missed some additional configuration option?

I'm running 5.0.21 on Solaris...

Thanks!

Thread
Trouble with read-onlyRod Heyd14 Jun
  • Re: Trouble with read-onlyravilr14 Jun
    • Re: Trouble with read-onlyRod Heyd14 Jun
  • Re: Trouble with read-onlyLudwig Pummer15 Jun