Solved

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

Posted on 2014-07-28
1
436 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
1 Comment
 
LVL 142

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL database data submission 7 69
Multilanguage Database Design in MySQL 5 119
simple mysql statement 3 40
Trigger usage 2 69
Creating and Managing Databases with phpMyAdmin in cPanel.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 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