Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT, DELETE, DROP, TRUNCATE, etc, except for the replication thread? I know you can just change the user accounts to disallow write access to the tables, but I'm thinking it would be convenient to simply have a switch that restricts all non-replicated writes to ensure that the slave stays consistent with the master. I've had a few users with administrator accounts mistakenly write to slaves, screwing up replication.
Anyone else think this might be useful? If so, I might just implement it if it isn't implemented already. Jeremiah Gowdy Senior Software Engineer FreedomVOICE Systems http://www.freedomvoice.com
