A MySQL/MariaDB DBA/Consultant/Trainer with Expertise in Database Designing, Development, Maintenance, Installation, Upgradation, Configuration optimization, Setting and Managing Replication, Backup and Restore,Cross Database Migration, Optimization, Synchronization of replicated database, Performance and Monitoring, High Availability
Thursday, July 19, 2012
Replicate a Database with different Name in MySQL
It happened to me first
time, so I was very excited about it until I noticed that this command has been
with us from nearly the very beginning (ie MySQL 4). We need to replicate a
database with different name. Was thinking it will be a big task J
finally got the easy solution and working now. J
Master Server contains db1
Slave Server contains db1 and db2
Slave Server needs db1 from the Master to replicate to db2
On my.cnf on the slave server:
Thus, this situation would dictate the following:
In replication there may be scenario like below Part 1
What if the Master Server contained db1 and db2; and
the Slave needs only db1 from the Master to replicate to db2 on the Slave?
We don't want to replicate both db1 and db2 to this slave, although we want to
replicate both databases to another slave - this means that the filter for
databases should reside on my.cnf on the slave...
Assuming that we are using replicate-rewrite-db=db1->db2:
Using replicate-do-db on the my.cnf file on the slave, which database would you
use with that command?
db1 or db2? It only takes a moment in time to find out... :)