MySQL Forums
Forum List  »  Replication

Re: Upgrade master-master replication
Posted by: Frederic Descamps
Date: August 20, 2018 04:06PM

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:

Now back to your procedure, SET sql_log_bin = X is for the session you are in (

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 (


Options: ReplyQuote

Written By
August 20, 2018 05:34AM
Re: Upgrade master-master replication
August 20, 2018 04:06PM

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.