Master-master replication and the mysql system database

[Keith Wessel]

Hi,

We're setting up two MySQL 5.7 servers, and we'd like to have full data replication of all databases. We'd also like users and passwords to be replicated, and I suspect there are other useful tidbits such as the grants tables that we want replicated as well to keep things fully in sync. The idea is to not need to run SQL statements on both servers.

From what I've read, there's no harm in replicating the mysql database to cover all of these things. However, we're using table storage for the relay log and master info to make the replication more resiliant to crashes. So, I assume we'll want to do replicate-wild-ignore-table = mysql.slave_%.

Question is are there other tables in the mysql database that we should avoid replicating to prevent from breaking something or just otherwise making our lives difficult?

Thanks,
Keith