[Maria-discuss] Galera: jump through major versions at once
Hi, Does Galera support rolling upgrades between multiple major versions? I will be upgrading my Galera cluster from MariaDB 10.3.34 to 10.6.x. It'd save a lot of time to jump straight from 10.3 to 10.6 instead of upgrading 10.3 -> 10.4 -> 10.5 -> 10.6. The documentation at https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-gal... implies that the MariaDB version is irrelevant, and only the Galera version matters.
Next, make sure that the Galera version numbers are compatible.
If you are upgrading from the most recent MariaDB 10.3 release to MariaDB 10.4, then the versions will be compatible. MariaDB 10.3 uses Galera 3 (i.e. Galera wsrep provider versions 25.3.x), and MariaDB 10.4 uses Galera 4 (i.e. Galera wsrep provider versions 26.4.x). This means that upgrading to MariaDB 10.4 also upgrades the system to Galera 4. However, Galera 3 and Galera 4 should be compatible for the purposes of a rolling upgrade, as long as you are using Galera 26.4.2 or later.
-- With kind regards, William Edwards
William, Recently a lot of testing was done on this (https://jira.mariadb.org/browse/MDEV-27437).
From reading https://jira.mariadb.org/browse/MDEV-28247 an upgrade to 10.3.35 might be required first (or an explicit disable of background merge - if possible).
So sst=rsync is required with innodb_use_native_aio=0. https://mariadb.com/kb/en/introduction-to-state-snapshot-transfers-ssts/#rsy... There's a task to upgrade the documentation, but I agree there are a few gaps at the moment. https://jira.mariadb.org/browse/MDEV-28483 The reddit user https://www.reddit.com/r/mariadb/comments/us7wbs/joining_node_to_galera_clus... is attempting the same. On Thu, May 19, 2022 at 4:02 AM William Edwards <wedwards@cyberfusion.nl> wrote:
Hi,
Does Galera support rolling upgrades between multiple major versions?
I will be upgrading my Galera cluster from MariaDB 10.3.34 to 10.6.x. It'd save a lot of time to jump straight from 10.3 to 10.6 instead of upgrading 10.3 -> 10.4 -> 10.5 -> 10.6.
The documentation at https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-gal... implies that the MariaDB version is irrelevant, and only the Galera version matters.
Next, make sure that the Galera version numbers are compatible.
If you are upgrading from the most recent MariaDB 10.3 release to MariaDB 10.4, then the versions will be compatible. MariaDB 10.3 uses Galera 3 (i.e. Galera wsrep provider versions 25.3.x), and MariaDB 10.4 uses Galera 4 (i.e. Galera wsrep provider versions 26.4.x). This means that upgrading to MariaDB 10.4 also upgrades the system to Galera 4. However, Galera 3 and Galera 4 should be compatible for the purposes of a rolling upgrade, as long as you are using Galera 26.4.2 or later.
-- With kind regards,
William Edwards
_______________________________________________ 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
Hello Daniel, Daniel Black schreef op 2022-05-19 01:09:
William,
Recently a lot of testing was done on this (https://jira.mariadb.org/browse/MDEV-27437).
The general consensus seems to be: use rsync SST. This is the case.
From reading https://jira.mariadb.org/browse/MDEV-28247 an upgrade to 10.3.35 might be required first (or an explicit disable of background merge - if possible).
So sst=rsync is required with innodb_use_native_aio=0.
https://mariadb.com/kb/en/introduction-to-state-snapshot-transfers-ssts/#rsy...
The page says:
Use of this SST method could result in data corruption when using innodb_use_native_aio (the default) if the donor is older than MariaDB 10.3.35, MariaDB 10.4.25, MariaDB 10.5.16, MariaDB 10.6.8, or MariaDB 10.7.4; see MDEV-25975. Starting with those donor versions, wsrep_sst_method=rsync is a reliable way to upgrade the cluster to a newer major version.
So, I should either: - Use MariaDB < 10.3.35 with sst=rsync and innodb_use_native_aio=0 - Use MariaDB > 10.3.35 with sst=rsync and any value for innodb_use_native_aio MariaDB 10.3.35 is listed at https://mariadb.com/kb/en/mariadb-10335-release-notes/, but not at https://mariadb.org/mariadb/all-releases/ and is not to be found in the repositories. The release notes mention this:
Note: This page describes features in the source repository for MariaDB 10.3. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.
Why is this? Will the binaries be published later?
There's a task to upgrade the documentation, but I agree there are a few gaps at the moment.
For future reference: this answers my other post to this mailing list with the subject "Major upgrade instructions missing for Galera". Are there any special steps for upgrading MariaDB 10.5 to 10.6? Thanks so much for the useful information you have provided.
The reddit user https://www.reddit.com/r/mariadb/comments/us7wbs/joining_node_to_galera_clus... is attempting the same.
On Thu, May 19, 2022 at 4:02 AM William Edwards <wedwards@cyberfusion.nl> wrote:
Hi,
Does Galera support rolling upgrades between multiple major versions?
I will be upgrading my Galera cluster from MariaDB 10.3.34 to 10.6.x. It'd save a lot of time to jump straight from 10.3 to 10.6 instead of upgrading 10.3 -> 10.4 -> 10.5 -> 10.6.
The documentation at https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-gal... implies that the MariaDB version is irrelevant, and only the Galera version matters.
Next, make sure that the Galera version numbers are compatible.
If you are upgrading from the most recent MariaDB 10.3 release to MariaDB 10.4, then the versions will be compatible. MariaDB 10.3 uses Galera 3 (i.e. Galera wsrep provider versions 25.3.x), and MariaDB 10.4 uses Galera 4 (i.e. Galera wsrep provider versions 26.4.x). This means that upgrading to MariaDB 10.4 also upgrades the system to Galera 4. However, Galera 3 and Galera 4 should be compatible for the purposes of a rolling upgrade, as long as you are using Galera 26.4.2 or later.
-- With kind regards,
William Edwards
_______________________________________________ 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
-- With kind regards, William Edwards
There's a typo in my email, see below. William Edwards schreef op 2022-05-19 11:38:
Hello Daniel,
Daniel Black schreef op 2022-05-19 01:09:
William,
Recently a lot of testing was done on this (https://jira.mariadb.org/browse/MDEV-27437).
The general consensus seems to be: use rsync SST. This is the case.
From reading https://jira.mariadb.org/browse/MDEV-28247 an upgrade to 10.3.35 might be required first (or an explicit disable of background merge - if possible).
So sst=rsync is required with innodb_use_native_aio=0.
https://mariadb.com/kb/en/introduction-to-state-snapshot-transfers-ssts/#rsy...
The page says:
Use of this SST method could result in data corruption when using innodb_use_native_aio (the default) if the donor is older than MariaDB 10.3.35, MariaDB 10.4.25, MariaDB 10.5.16, MariaDB 10.6.8, or MariaDB 10.7.4; see MDEV-25975. Starting with those donor versions, wsrep_sst_method=rsync is a reliable way to upgrade the cluster to a newer major version.
So, I should either:
- Use MariaDB < 10.3.35 with sst=rsync and innodb_use_native_aio=0 - Use MariaDB > 10.3.35 with sst=rsync and any value for innodb_use_native_aio
MariaDB 10.3.35 is listed at https://mariadb.com/kb/en/mariadb-10335-release-notes/, but not at https://mariadb.org/mariadb/all-releases/ and is not to be found in the repositories. The release notes mention this:
Note: This page describes features in the source repository for MariaDB 10.3. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.
Why is this? Will the binaries be published later?
There's a task to upgrade the documentation, but I agree there are a few gaps at the moment.
For future reference: this answers my other post to this mailing list with the subject "Major upgrade instructions missing for Galera".
Are there any special steps for upgrading MariaDB 10.5 to 10.6?
I don't mean standalone MariaDB. I mean upgrading a Galera cluster with MariaDB 10.5 nodes to MariaDB 10.6. (As this page is missing from the documentation.)
Thanks so much for the useful information you have provided.
The reddit user https://www.reddit.com/r/mariadb/comments/us7wbs/joining_node_to_galera_clus... is attempting the same.
On Thu, May 19, 2022 at 4:02 AM William Edwards <wedwards@cyberfusion.nl> wrote:
Hi,
Does Galera support rolling upgrades between multiple major versions?
I will be upgrading my Galera cluster from MariaDB 10.3.34 to 10.6.x. It'd save a lot of time to jump straight from 10.3 to 10.6 instead of upgrading 10.3 -> 10.4 -> 10.5 -> 10.6.
The documentation at https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-gal... implies that the MariaDB version is irrelevant, and only the Galera version matters.
Next, make sure that the Galera version numbers are compatible.
If you are upgrading from the most recent MariaDB 10.3 release to MariaDB 10.4, then the versions will be compatible. MariaDB 10.3 uses Galera 3 (i.e. Galera wsrep provider versions 25.3.x), and MariaDB 10.4 uses Galera 4 (i.e. Galera wsrep provider versions 26.4.x). This means that upgrading to MariaDB 10.4 also upgrades the system to Galera 4. However, Galera 3 and Galera 4 should be compatible for the purposes of a rolling upgrade, as long as you are using Galera 26.4.2 or later.
-- With kind regards,
William Edwards
_______________________________________________ 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
-- With kind regards, William Edwards
participants (2)
-
Daniel Black -
William Edwards