On Tue, Jan 22, 2002 at 02:28:32PM -0500, Wendell Dingus wrote: > You might have just hit the nail on the head.. Server1 is > replicating everything to server2 but it is only saving changes to > one particular database. Those changes are being manually gathered > via mysqlbinlog and sent to server3. Here are the relative entries > in my.cnf > > Server1: > log-bin > server-id=1 > > Server2: > master-host=shelby1 > master-user=repl > master-password=xxxxxx > server-id=2 > log-bin=/var/lib/mysql/shelby-bin > binlog-do-db=registrydb_tn > log-slave-updates > > Took me a while to find the log-slave-updates in the docs to get the > slave server to log a second copy. Everything seems to work great > except for the table changes though... > > Anyway, thanks and hopefully this info can help you or whomever on > the development team to track this down.
I *think* this problem is related to the fact that you've got: binlog-do-db=registrydb_tn in your file. Why? Because MySQL is a little funny about how it handles replication on a per-table basis. The fact is that it works best when you replicate ALL the data between two servers. I know there are documented cases when per-table or per-db replication may miss queries, but I haven't had a chance to lookk them up. I'll need to do that soon anway, but that's what I recal. My recommendation (if you can) is that you replicate everyting. Then the filtering that MySQL is currently doing won't be a problem for you. Hope that helps (sort of). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 513,727,280 queries (266/sec. avg) --------------------------------------------------------------------- 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
