MySQL Slave Read Only

2005-06-06 Thread Jeremiah Gowdy
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

Re: MySQL Slave Read Only

2005-06-06 Thread Eric Bergen
There is an option starting in 4.0.14 called read-only that will allow only the slave i/o thread and users with the super priv to execute write queries. Jeremiah Gowdy wrote: Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT, DELETE, DROP, TRUNCATE, etc, except