MySQL Forums
Forum List  »  Replication

Re: Getting consistent backup of slave that has foreign keys
Posted by: Alexander Spitzer
Date: March 08, 2016 06:37AM

Correct, we usually clone the slaves just by copying the data dir, but in this case, we are upgrading the DBs to a newer version of the db.

We are going from:
5.1 --> 5.5 --> 5.6 --> 5.7, so I will have to do a dump and restore 3 times.

NOTE: I WILL be copying over the datafiles from this 5.5 mysql to all the other slaves (instead of doing an import). The difference is like 5 hours to copy vs 24+ hours to import.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Getting consistent backup of slave that has foreign keys
856
March 08, 2016 06:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.