Solved

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

Posted on 2014-07-28
1
448 Views
Last Modified: 2014-09-15
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
Comment
Question by:Systemadministration
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 40224395
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Creating and Managing Databases with phpMyAdmin in cPanel.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question