maria-discuss team mailing list archive
Mailing list archive
Re: Upgrading mariadb-galera-server
MariaDB discuss <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Tom Worster <fsb@xxxxxxxxxx>
Fri, 19 Jun 2015 15:34:55 -0400
[Maria-discuss] Upgrading mariadb-galera-server
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?
From: Geoff Montee <geoff.montee@xxxxxxxxx>
Date: Friday, June 19, 2015 at 1:22 PM
To: Tom Worster <fsb@xxxxxxxxxx>
Cc: maria-discuss email list <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Maria-discuss] Upgrading mariadb-galera-server
On Fri, Jun 19, 2015 at 9:55 AM, Tom Worster <fsb@xxxxxxxxxx> 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.
service mysql stop
yum update MariaDB-Galera-server MariaDB-client MariaDB-devel
service mysql start
mysql --execute="SET GLOBAL wsrep_OSU_method=RSU;"
mysql --execute="SET GLOBAL wsrep_OSU_method=TOI;"