maria-discuss team mailing list archive

[Bryan Traywick <bryantraywick@xxxxxxxxx>]

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 <fsb@xxxxxxxxxx> 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.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
> 
> Hi Tom,
> 
> 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.
> 
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp