hello, i have a working master-slave replication, the problem i find is that if i restart the MASTER there is a difference in the MASTER_LOG_FILE and MASTER_LOG_POS on the SLAVE.
what is the correct way to keep the two slaves in sync even after i restart the server. the way i do it now is to: [MASTER] mysql> show master status; +------------------+----------+----------------------+--------------------------+ | mysql-bin.000010 | 13405429 | upgrade,tracker,bugs | mysql,information_schema | +------------------+----------+----------------------+--------------------------+ 1 row in set (0.00 sec) [SLAVE] mysql> stop slave; mysql> change master to MASTER_HOST='master.domain.com', MASTER_USER='replicator', MASTER_PASSWORD='xxx', MASTER_LOG_FILE='mysql-bin.000010', MASTER_LOG_POS=13301215; mysql> start slave; is this correct or is there a better way to do this? thanks -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ ǝq s,ʇǝן ʇǝʎ %>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org