Re: Upgrade master-master replication

[Frederic Descamps]

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,