Re: Upgrade master-master replication
Hi Ben,
First of all, and I now this kind of answer is not pleasant but I should warn you that doing Master-Master replication is not something recommended. Certainly if you write on both node at the same time.
In case you really need to write on both node, I would suggest you to take a look at Group Replication (InnoDB Cluster) where it's possible to have a 3 nodes cluster multi-primary (with some constraints that you can read about here:
https://lefred.be/content/mysql-group-replication-single-primary-or-multi-primary/)
Now back to your procedure, SET sql_log_bin = X is for the session you are in (https://dev.mysql.com/doc/refman/8.0/en/set-sql-log-bin.html).
Can you have downtime for both servers at the same time ? If so just stop them both, upgrade the binaries and please don't forget mysql_upgrade (https://lefred.be/content/how-to-safely-upgrade-to-mysql-8-0/)
Regards,
Subject
Views
Written By
Posted
1961
August 20, 2018 05:34AM
Re: Upgrade master-master replication
894
August 20, 2018 04:06PM
660
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.