[ClusterLabs] Mysql upgrade in DRBD setup

[Attila Megyeri]

Hi all,

What is the recommended mysql server upgrade methodology in case of an active/passive DRBD storage?
(Ubuntu is the platform)


1)      On the passive node the mysql data directory is not mounted, so the backup fails (some postinstall jobs will attempt to perform manipulations on certain files in the data directory).

2)      If the upgrade is done on the active node, it will restart the service (with the service restart, not in a crm managed fassion...), which is not a very good option (downtime in a HA solution). Not to mention, that it will update some files in the mysql data directory, which can cause strange issues if the A/P pair is changed - since on the other node the program code will still be the old one, while the data dir is already upgraded.

Any hints are welcome!

Thanks,
Attila

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/users/attachments/20171012/5329c9aa/attachment-0002.html>