[Maria-discuss] Upgrading mariadb-galera-server
![](https://secure.gravatar.com/avatar/5780d81ca8ef00d7951b96617e1c3ee7.jpg?s=120&d=mm&r=g)
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?
![](https://secure.gravatar.com/avatar/01d86d32e4a72ce9ecd34dba70b74cc4.jpg?s=120&d=mm&r=g)
Yes.
http://galeracluster.com/documentation-webpages/upgrading.html
2015-06-19 18:55 GMT+02:00 Tom Worster
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
![](https://secure.gravatar.com/avatar/5780d81ca8ef00d7951b96617e1c3ee7.jpg?s=120&d=mm&r=g)
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
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
![](https://secure.gravatar.com/avatar/8d10122123d64386450efc191962fdfe.jpg?s=120&d=mm&r=g)
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
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
Date: Friday, June 19, 2015 at 1:22 PM To: Tom Worster Cc: maria-discuss email list 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
: 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
![](https://secure.gravatar.com/avatar/2718be5c7d9bae5985a62f13b79f3886.jpg?s=120&d=mm&r=g)
Hi Tom,
On Fri, Jun 19, 2015 at 9:55 AM, Tom Worster
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... 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
![](https://secure.gravatar.com/avatar/5780d81ca8ef00d7951b96617e1c3ee7.jpg?s=120&d=mm&r=g)
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
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
![](https://secure.gravatar.com/avatar/8d10122123d64386450efc191962fdfe.jpg?s=120&d=mm&r=g)
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
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
Date: Friday, June 19, 2015 at 1:22 PM To: Tom Worster Cc: maria-discuss email list Subject: Re: [Maria-discuss] Upgrading mariadb-galera-server Hi Tom,
On Fri, Jun 19, 2015 at 9:55 AM, Tom Worster
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...
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
![](https://secure.gravatar.com/avatar/2718be5c7d9bae5985a62f13b79f3886.jpg?s=120&d=mm&r=g)
On Fri, Jun 19, 2015 at 12:34 PM, Tom Worster
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
participants (4)
-
Bryan Traywick
-
Geoff Montee
-
Guillaume Lefranc
-
Tom Worster