• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

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!
0
Systemadministration
Asked:
Systemadministration
1 Solution
 
Guy Hengel [angelIII / a3]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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now