Hi All, I'm new to this list and have some questions about BDB tables and replication. Hope some of the more enlightened ones on this list might shed some light on the following :
1. I've a master-slave replication setup with BDB tables. If for some reason the BDB tables on the slave go out of sync (e.g. failover master->slave, then failback slave->master), what's the best way to sync these tables and restart the replication on the slave? 2. How would I be able to get a decent snapshot of the BDB (or other MyISAM) tables in (1) without stopping the master (the master is running a live 24x7 service hence cannot stop the master without affecting uptime)? 3. Related to (1), what's the best way to do recovery on BDB tables using the MySQL binary logs + BDB table snapshot + BDB logs? I've read the manual but could not find such info :) Thanks in advance! Cheers, Geoffrey __________________________________________________ Geoffrey Soh, Software Architect Ufinity - http://www.ufinity.com Leading Enterprise Access Management Software! 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 Tel : +65 830-0341 Fax : +65 737-0213 __________________________________________________ --------------------------------------------------------------------- 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
