MySQL Forums
Forum List  »  Replication

Upgrade master-master replication
Posted by: Ben Klauke
Date: August 20, 2018 05:34AM

Hi all,

We'd like to use a row-based master-master replication scenario with MySQL 8.0 using GTIDs.

I'm not pretty sure how to perform MySQL upgrades in our case. After reading the documentation, I think these steps might work, but maybe I mixed something up:

1) stop first master and perform the following steps on it

2) replace MySQL binaries

3) start server with --skip-networking and --skip-slave-start options

4) execute SET sql_log_bin = 0

5) run mysql_upgrade

6) execute SET sql_log_bin = 1

7) repeat steps 1 to 6 for second master

8) restart both masters without --skip-networking and --skip-slave-start options

Please tell me if my planned proceeding is right.

Thanks so much for your help.

All the best,


Options: ReplyQuote

Written By
Upgrade master-master replication
August 20, 2018 05:34AM

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.