Hi,
> 1. flush logs on the master (only if it's accessible, of course).
>
Not really necessary if you block clients (firewall rule for new
connections to port 3306?).
Anyway, why don't you use a dual-master setup?
I find that this is a whole lot easier to administer than a master/
fallback-slave situation. In particular, restoring the master after it
comes back happens automatically, or (if you need to re-install the master
from scratch) the command
slave# mysqldump --single-transaction --master-data=1 --all-databases \
| ssh master mysql
ensures that you can continue to use the slave while restoring the master.
Assuming you use only transaction-safe tables, of course.
(You should.)
--
-- Matthias Urlichs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
