MySQL replication, what about DB "mysql", "information_schema" and "performance_schema"?

Hi experts,

I started testing MySQL Master-Slave replication in a lab heren.
On the master I enabled binary logging, without setting following:

#binlog_do_db           = 
#binlog_ignore_db       = 

Open in new window


I then dumed my database and copied it to the slave server.
After starting the Replication, I see that my productive db is replicated.
But what about the following DBs:
- mysql (users, etc.)
- performance_schema
- information_schema

Will changes in those DBs also be replicated as soon as I do a change?
Thiat would mean, that my root-account on the slave would change, if I change the root-password on the master.
Is this correct?

How do you handle that?
Must slave and master have the same credentials?

Thanks in advance!
SystemadministrationAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
those 3 system database shall not be replicated, otherwise you would end up with corrupted systems.

>Will changes in those DBs also be replicated as soon as I do a change?
certain changes will be implicitly replicated, but otherwise they refer to the local instance, which will be partially the same due to the fact that it's replicated. performance_schema for example will NOT be the same, as the load and the specs of the 2 machines are eventually completely different.

>Must slave and master have the same credentials?
it's not required, but for the applications, if this is for a fallback scenarios, they just need to change the server address (name or ip), and not all the username/password information also.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.