On Wed, Feb 16, 2011 at 10:23 AM, Machiel Richards <machielr@stripped>wrote:
> Due to differences within the 2 versions, we had to exclude the
> mysql database from the backup and restore.
> 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
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
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