On Wed, Feb 16, 2011 at 10:23 AM, Machiel Richards <machi...@rdc.co.za>wrote:
> Due to differences within the 2 versions, we had to exclude the > mysql database from the backup and restore. > Yep :-) > When setting up the replication, should we still > exclude the mysql database from the replication and manually do any > changes if required or can we replicate all databases without any > problems? > Ah :-) If you use statement-based replication, I would hazard a guess that grant statements will replicate perfectly fine and will work as expected on both sides (you DON'T pilfer with the authentication tables manually, do you?). If you use row-based replication, I would definitely exclude the mysql database. The question is, however: how often do you need to change privileges or routines during this migration period? I would assume rarely to not at all; so why not just leave the mysql database out of the replication, just in case ? You presumably already set it up manually on the new server, so just let good enough alone. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel