MySQL Forums
Forum List  »  Replication

Re: Getting consistent backup of slave that has foreign keys
Posted by: Peter Brawley
Date: March 01, 2016 08:15PM

"You may encounter difficulties when replicating from an older master to a newer slave if the master uses statements or relies on behavior no longer supported in the version of MySQL used on the slave." --
https://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.html

> There is no off peak time to do a backup.

So you can't try Flush tables With Read Lock either.

If I could not manage a dump-based upgrade to master & slave in the same timeframe, I think I would be working up another solution ASAP.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Getting consistent backup of slave that has foreign keys
902
March 01, 2016 08:15PM


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.