> > Here is how you can do the above: > > > > * make sure slave runs with log-bin. > > > > * before you direct updates to the slave, record the binlog offset and > > position on the slave by running SHOW MASTER STATUS ( on the slave not on the > > master!) > > > Whoops! When the failover occurs, there is nobody at the console to > record the offset! It's an automatic failover when the master fails! > It might have happened at 4 in the morning yesterday. > How do we automatically know the master has failed and record that offset?
You need to have your system set up in such a way that failover event will trigger the execution of a script, which will do all the magic. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
