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:
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!
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 =
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.