I would also recommend setting wsrep_OSU_method to RSU before running mysql_upgrade on each node.
Honestly I don't normally run mysql_upgrade for minor version changes, but I probably should and the docs do recommend doing so: https://mariadb.com/kb/en/mariadb/mysql_upgrade/. With the ability for zero downtime upgrades their isn't really any reason not to and I will in the future. Bryan > On Jun 19, 2015, at 3:34 PM, Tom Worster <f...@thefsb.org> wrote: > > Thanks Geoff, I never would have though of this without your mentioning it. > > Unless I think there might be defects in my tables, do you think there's a > need to run mysql_upgrade for 10.0.15 -> .19? > > Tom > > From: Geoff Montee <geoff.mon...@gmail.com> > Date: Friday, June 19, 2015 at 1:22 PM > To: Tom Worster <f...@thefsb.org> > Cc: maria-discuss email list <maria-discuss@lists.launchpad.net> > Subject: Re: [Maria-discuss] Upgrading mariadb-galera-server > > Hi Tom, > > On Fri, Jun 19, 2015 at 9:55 AM, Tom Worster <f...@thefsb.org> wrote: > Can I upgrade a production cluster from 10.0.15 to 10.0.19 while the cluster > remains in service, upgrading one node at a time? > > > Yes, you can do this. If you plan to run mysql_upgrade on each node > after upgrading, you may want to set wsrep_OSU_method to RSU before > doing so. I think this is especially important for this upgrade, since > mysql_upgrade in 10.0.19 calls REPAIR VIEW. That statement doesn't > exist in 10.0.15. > > http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-osu-method > > https://mariadb.com/kb/en/mariadb/repair-view/ > > e.g.: > > service mysql stop > yum update MariaDB-Galera-server MariaDB-client MariaDB-devel > MariaDB-shared galera-3 > service mysql start > mysql --execute="SET GLOBAL wsrep_OSU_method=RSU;" > mysql_upgrade > mysql --execute="SET GLOBAL wsrep_OSU_method=TOI;" > > Geoff > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
