MySQL Forums
Forum List  »  Replication

Re: Getting consistent backup of slave that has foreign keys
Posted by: Alexander Spitzer
Date: March 01, 2016 08:24PM

Peter Brawley Wrote:
-------------------------------------------------------
> "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/replicatio
> n-compatibility.html


Right, but in the same page, right before your quote, it is stated:

"MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a master running MySQL 5.5 to a slave running MySQL 5.6, from a master running MySQL 5.6 to a slave running MySQL 5.7, and so on."

This is why I have to go 5.1 -> 5.5 -> 5.6 -> 5.7 and not just jump from 5.1 -> 5.7 due to the problems you mentioned. It sucks, but I can see why I can't do such a large leap.

>
> > 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.

yeah, the dump/import to one version up is really the only possible solution. I just dont understand why mysql is not taking a good backup.

I am interested to see how the new backup from the new slave works out. I'll know sometime tomorrow.

This is so frustrating.

Thanks!

Options: ReplyQuote


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


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.