Sample Header Ad - 728x90

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