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: 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,

Options: ReplyQuote


Subject
Views
Written By
Posted
1517
August 20, 2018 05:34AM
Re: Upgrade master-master replication
689
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.