Greetings,
In converting a master into a slave, I would like to IGNORE all writes instead of blocking them. If I block writes with LOCK TABLES then once the server is converted into a slave and the tables are unlocked all of the blocked writes in the interrum period will be written. The idea is to keep the (former master future slave ) server running so the slaves can be kept up to date. The only solution I can think of is to shutdown the slave server while the database is locked, I assume then, when the server is shutdown if will not write the blocked writes. Many Thanks, Trevor