Lets assume you have a multi-primary cluster and you want to upgrade the nodes without taking them offline.
For this say we have 3 nodes, mysqlcluster1, mysqlcluster2, and mysqlcluster3 and the cluster is currently online.
- Move all traffic to mysqlcluster1
- Do upgrades on mysqlcluster2 and mysqlcluster3, when they finish the update they will auto rejoin the cluster but stay as R/O
- stop mysql on mysqlcluster1, as soon as you do that mysqlcluster2 and mysqlcluster3 will go R/W
- You will have to either:
- time switching your db hosts in your configs with when you bring down mysqlcluster1
- use mysqlrouter to automatically switch-over
- move all traffic to mysqlcluster2 and mysqlcluster3