MySQL Forums
Forum List  »  Replication

Legacy 5.1 Upgrade (Replicate 5.1 - 5.7)
Posted by: Matthew Walstra
Date: February 16, 2018 01:07AM

Good Day Everyone,

I am hoping that this is the correct forum.
We have a legacy system operating My SQL 5.1 (unreplicated) but is quite important across multiple solutions.
We are planning on upgrading it to 5.7 at least, however the big risks we are concerned about is potential downtime.

Our key plan is to set up replication from 5.1 -> 5.7, which from research shows is actually impossible (due to key differences from a key attribute perspective).
So my thoughts are the following steps:

1) Replicate DB1 (5.1) -> DB2 (5.6) (Master -> Master);
2) Configure all solutions to connect to DB2
3) Upgrade DB1 -> 5.7
4) Configure all solutions to connect to DB1
5) Upgrade DB2 -> 5.7
6) Connect systems to LB and allow solutions to connect to LB so that the systems are load balanced.

Any thoughts / concerns / advise / criticism in this regard would be appreciated.

- MW

Options: ReplyQuote

Written By
Legacy 5.1 Upgrade (Replicate 5.1 - 5.7)
February 16, 2018 01:07AM

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.