<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hello, I think, that only way is to upgrade manually and can not without downtime. My way will be to put cluster to maintanance mode and perform upgrade on active node with mysql_upgrade cmd. On pasive node should be enough to just install newer mysql without starting it and running mysql_upgrade. But you can make second node primary, mount fs and them run standard mysql upgrade lik eon active node was.<div class=""><div class="">
<br class="Apple-interchange-newline"><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">S pozdravem Kristián Feldsam</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Tel.: +420 773 303 353, +421 944 137 535</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">E-mail.: <a href="mailto:support@feldhost.cz" class="">support@feldhost.cz</a></span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><a href="http://www.feldhost.cz" class="">www.feldhost.cz</a> -<span class="Apple-converted-space"> </span></span><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-weight: bold;" class="">Feld</span><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Host</span><span style="color: rgb(0, 0, 0); font-variant-caps: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">™</span><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><span class="Apple-converted-space"> </span>– profesionální hostingové a serverové služby za adekvátní ceny.</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">FELDSAM s.r.o.</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">V rohu 434/3</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Praha 4 – Libuš, PSČ 142 00</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">IČ: 290 60 958, DIČ: CZ290 60 958</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">C 200350 vedená u Městského soudu v Praze</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Banka: Fio banka a.s.</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Číslo účtu: 2400330446/2010</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">BIC: FIOBCZPPXX</span><br style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(0, 0, 0); font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">IBAN: CZ82 2010 0000 0024 0033 0446</span>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 12 Oct 2017, at 20:42, Attila Megyeri <<a href="mailto:amegyeri@minerva-soft.com" class="">amegyeri@minerva-soft.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; font-family: Baskerville; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt; color: rgb(31, 73, 125);" class="">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)<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt; color: rgb(31, 73, 125);" class="">thanks<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><a name="_MailEndCompose" class=""><span style="font-size: 11pt; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></a></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><b class=""><span lang="EN-US" style="font-size: 11pt;" class="">From:</span></b><span lang="EN-US" style="font-size: 11pt;" class=""><span class="Apple-converted-space"> </span>Kristián Feldsam [<a href="mailto:admin@feldhost.cz" class="">mailto:admin@feldhost.cz</a>]<span class="Apple-converted-space"> </span><br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Thursday, October 12, 2017 7:51 PM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>Attila Megyeri <<a href="mailto:amegyeri@minerva-soft.com" class="">amegyeri@minerva-soft.com</a>>; <a href="mailto:users@clusterlabs.org" class="">users@clusterlabs.org</a><br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>Re:[ClusterLabs] Mysql upgrade in DRBD setup<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class="">hello, you should put cluster to maintenance mode<span style="font-size: 12pt;" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class="">Sent from my MI 5<o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class="">On Attila Megyeri <<a href="mailto:amegyeri@minerva-soft.com" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">amegyeri@minerva-soft.com</a>>, Oct 12, 2017 6:55 PM wrote:<o:p class=""></o:p></div><blockquote style="border-style: none none none solid; border-left-width: 1pt; border-left-color: rgb(204, 204, 204); padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;" class=""><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class="">Hi all,</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class=""> </span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class="">What is the recommended mysql server upgrade methodology in case of an active/passive DRBD storage?</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class="">(Ubuntu is the platform)</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class=""> </span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 10pt; font-family: Calibri, sans-serif; text-indent: -18pt;" class=""><span style="font-size: 11pt;" class=""><span class="">1)<span style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";" class=""> <span class="Apple-converted-space"> </span></span></span></span><span lang="EN-US" style="font-size: 11pt;" class="">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).</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt 36pt; font-size: 10pt; font-family: Calibri, sans-serif; text-indent: -18pt;" class=""><span style="font-size: 11pt;" class=""><span class="">2)<span style="font-style: normal; font-variant-caps: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";" class=""> <span class="Apple-converted-space"> </span></span></span></span><span lang="EN-US" style="font-size: 11pt;" class="">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.</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class=""> </span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class="">Any hints are welcome!</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class=""> </span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class="">Thanks,</span><span style="font-size: 11pt;" class=""><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt;" class="">Attila</span></div></div></blockquote></div></div></div></blockquote></div><br class=""></div></body></html>