[ClusterLabs] Mysql upgrade in DRBD setup

[Attila Megyeri]

Hi, This does not really answer my question. Placing the cluster into maintenance mode just avoids monitoring and restarting, but what about the things I am asking below? (data dir related questions)

thanks


From: Kristián Feldsam [mailto:admin at feldhost.cz]
Sent: Thursday, October 12, 2017 7:51 PM
To: Attila Megyeri <amegyeri at minerva-soft.com>; users at clusterlabs.org
Subject: Re:[ClusterLabs] Mysql upgrade in DRBD setup

hello, you should put cluster to maintenance mode



Sent from my MI 5
On Attila Megyeri <amegyeri at minerva-soft.com<mailto:amegyeri at minerva-soft.com>>, Oct 12, 2017 6:55 PM wrote:
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: <https://lists.clusterlabs.org/pipermail/users/attachments/20171012/8905cf73/attachment-0003.html>