Importing a large mysql dump while replication is running
2
votes
2
answers
2438
views
So we have a simple master/slave mysql replication running between two CentOS Servers.
The master has multiple databases. eg..
Database1
Database2
Database3
The issue is we have a mysql dumpfile of a new 60GB database (Database4).
What's the best way to import Database4 without breaking replication?
I was thinking we could stop replication, and import the mysqldump onto both master and slave. Then restart replication, but was hoping there was an alternate way that would minimize downtime.
Asked by user125340
(21 rep)
May 22, 2017, 09:58 PM
Last activity: Jun 25, 2025, 06:08 PM
Last activity: Jun 25, 2025, 06:08 PM