I have 2 machines 'master' and 'slave'. I have the mysql 5.0.51a-log databases 
both replicating wonderfully. They are configured in a dual master scenario so 
that one can take over for the other in my HA environment I've built. All is 
working great until... If one or the other box reboots or the mysql restarts, 
the replication gets out of whack. Especially if I simulate both of them 
crashing in a worst case scenario, they are then both trying to sync from the 
wrong Master_log_file and Read_Master_Log_Pos...

Since catastrpohe WILL happen eventually (heence the need for HA) how do I 
direct the newly restarted boxes to the right position in the correct files on 
restart?

Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to