MySQL Forums
Forum List  »  Replication

Re: Migration from 5.5.31 to 8.0
Posted by: Peter Brawley
Date: July 28, 2020 09:51AM

Good overview of upgrade options & advice at https://www.percona.com/blog/2014/09/19/mysql-upgrade-best-practices/

You mustn't try to jump from 5.5 to 8.0---it'll fail on cascading incompatibilities. You need to step through each major version.

I think that's an argument for creating a new mysql instance that starts with a copy of 5.5, step through upgrade-and-debug to 5.6, 5.7 then 8.0, and when no more bugs can be found in the new 8.0 instance then on the slave change master to that new 8.0 instance.

Options: ReplyQuote


Subject
Views
Written By
Posted
1427
July 28, 2020 05:59AM
Re: Migration from 5.5.31 to 8.0
696
July 28, 2020 09:51AM


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.