Hi, I'm currently looking at te best way to do a master switch in a replication setup (4.1).
Let's say I'm switching from M1 to M2. I'm looking particularly at the different possible way to hold the query (Write) on the M2 server till I can check that the replicate was done playing the query on M1... If I do a FLUSH TABLES WITH READ LOCK; the SQL_THREAD will be also block so it will never catch up... Is there a way to allow the SQL_THREAD to write while holding everything else ? Best Regards, PS: I know about MySQL 5.0 multi-master setup :) just not the case at the moment ------ Math aka ROunofF argontechnologies.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
