So we have a simple master/slave mysql replication running between two CentOS Servers.
The master has multiple databases. eg..
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.