I agree the wording is a little confusing but you are correct that the server will decide between IST and SST based on whether galera.cache is large enough to hold the write sets that occur during the upgrade. Note that if an SST is required then the changes to the table structure made by mysql_upgrade will be undone. Bryan

On Jun 19, 2015, at 3:30 PM, Tom Worster <fsb@thefsb.org> wrote:

Thanks Guillaume.

The doc says

Unless you use Incremental State Transfer, as you bring each node back online after an upgrade, it initiates a full State Snapshot Transfer, which can take a long time to process on larger databases and slower state transfer methods.

The wording suggests that it's up to me to choose IST. But isn't it the case that the server choses IST or SST, depending on whether galera.cache has enough writesets for an IST?

From: Guillaume Lefranc <guillaume@adishatz.net> Date: Friday, June 19, 2015 at 1:22 PM To: Tom Worster <fsb@thefsb.org> Cc: maria-discuss email list <maria-discuss@lists.launchpad.net> Subject: Re: [Maria-discuss] Upgrading mariadb-galera-server

Yes. http://galeracluster.com/documentation-webpages/upgrading.html

2015-06-19 18:55 GMT+02:00 Tom Worster <fsb@thefsb.org>:

...

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?

_______________________________________________ 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

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@gmail.com> Date: Friday, June 19, 2015 at 1:22 PM To: Tom Worster <fsb@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 <fsb@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

On Fri, Jun 19, 2015 at 12:34 PM, Tom Worster <fsb@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?

There's not usually a need to run mysql_upgrade for minor release upgrades. In this case, I don't think you'll need to run mysql_upgrade unless you created views while running Oracle MySQL using your current datadir before migrating to MariaDB, and you think you might be negatively affected by this bug: https://mariadb.atlassian.net/browse/MDEV-6916 Geoff