MySQL Backup and Restore – Database Administrators Stack Exchange

I have a specific situation and I will try to explain as much as I can.

  • L1-Master DB1 (Slave for L2-Master DB1)

  • L1-Slave DB2 (Slave for L1-Master DB1)

  • L2-Master DB1 (Slave for L1-Master DB1)

  • L2-Slave DB2 (Slave for L2-Master DB1)

So, 4 DB servers, master-slave and master-master replication in place.

What bothers me is this.

I should restore one database which is around 500 Gb in size and it should be restored on L1-MasterDB1.

What do you think is the best approach on restoring this amount of data, since the production is already under heavy load? How much of an impact will this be on those 4 servers since replication is in place?

I would appreciate any answer or suggestion.

Thank you all very much.