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!