Link to home
Start Free TrialLog in
Avatar of Systemadministration
Systemadministration

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial