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,
Ben
Subject
Views
Written By
Posted
Upgrade master-master replication
1972
August 20, 2018 05:34AM
896
August 20, 2018 04:06PM
662
August 21, 2018 03:06AM
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.