MySQL Forums
Forum List  »  Replication

Re: Upgrading MySQL with GTID replication to MySQL 5.7
Posted by: Frederic Descamps
Date: August 06, 2018 05:56AM

Hi Sandra,

If you are already using GTID in 5.6 that should not be a problem. You should take a backup (physical or logical) and restore it on a new server. Make this new machine a slave from the original (don't forget to change the server_id). Then upgrade the files to 5.7 (install 5.7) and run mysql_upgrade, restart and now you should have the master in 5.6 and the new slave in 5.7.

You can find more info at https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html

Regards,

lefred

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Upgrading MySQL with GTID replication to MySQL 5.7
505
August 06, 2018 05:56AM


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.