Hey everyone...

I had replication stop on a slave server on which I had added a few extra summary tables. The error that caused replication to stop didn't mention any of these new tables... but my sysadmin is suspicious that the change in db structure could have been part of the reason replication broke. It's my understanding that it's ok to add extra tables on a slave... that mysql replication isn't smart enough to care about that... it basically just replays queries from the master's binary log. I've been searching the internet and mysql online documentation and haven't been able to find a statement supporting either argument.

Can anyone help me clear this up?
Thanks,
Rob

_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php

Reply via email to