On Thu, Oct 25, 2001 at 04:22:33PM +0800, Geoffrey Soh wrote: > 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?
Have a look at mysqlsnapshot: http://jeremy.zawodny.com/mysql/ It's designed for MyISAM files, but it could be modified for BDB pretty easily (I'd love the patch). > 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)? Same answer. :-) > 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 :) Look at the mysqlbinlog command. It turns a binary log into something you can pipe back thru the mysql command-line tool. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 --------------------------------------------------------------------- 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