MySQL - How do I upgrade on a hot replication se
More DBA job interview questions and answers at
MySQL - How do I upgrade on a hot replication setup?
If you are upgrading pre-3.23.26 versions, you should just lock the master tables, let the slave catch up, then run FLUSH
MASTER on the master, and FLUSH SLAVE on the slave to reset the logs, then restart new versions of the master and the slave.
Note that the slave can stay down for some time - since the master is logging all the updates, the slave will be able to
catch up once it is up and can connect.
Other Job Interview Questions