Version 3.23.46-max on a dual Xeon RedHat 7.2 machine with all RedHat patches and their latest -smp kernel.
I turned on binary logging on a particular database with binlog-do-db= and later try this: mysqlbinlog -uroot -pxxxyyy binlogfilename-bin.001 It shows me the inserts and deletes that were logged but does not give the prompt back. It hangs and takes a CTRL-C to get back to the prompt. Redirecting output >file does the same thing, requires an interrupt. I kind of need this ability since I'm doing a poor-mans off-site replication this way as sort of a many-master to one slave type setup. I have all the masters save up a bunch of logged queries and once an hour or so mysqlbinlog >file dump them and copy them up to a master web server which imports them via the standard client. The masters are all on DSL with dynamic IPs so it's not really possible to have the "slave" connect to them for proper realtime replication. This is working great with over 30 remote internet-connected servers "replicating" to a master web server. This problem with mysqlbinlog hanging on this version is a show stopper though, I hope someone has an answer or it gets fixed if it's a known bug (at least now it's known). Since I've described this setup, an additional question. I occasionally miss a transaction or two and must manually update the entire databases to make sure everything is in sync. I do a mysqlbinlog >file and immediately do a "flush master" via the client to reset the binary log file. There appears to be a race condition where updates are being done to the database and hence the log file at the time the flush is done and an insert or update or two get lost in the shuffle. Just wondering if anyone is doing anything similar and has any pointers or suggestions. Thanks in advance! --------------------------------------------------------------------- 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
