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

Reply via email to