I have a two node MySQL cluster with Master Slave replication. The MySQL version is 5.7.22 and the OS is CentOS.
I need to upgrade the MySQL version to 5.7.24 due to some security reasons.
However, I need to
- keep the existing data
- keep the existing user privileges
- do with a zero downtime
- keep the master slave replication after upgrading
What would be the correct approach to do this with the above requirements.