maria-discuss team mailing list archive

[William Edwards <wedwards@xxxxxxxxxxxxxx>]

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/#rsync-rsync_wan
>
> 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.
> >
> > https://jira.mariadb.org/browse/MDEV-28483
>
> 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_cluster_failed/
> > is attempting the same.
> >
> > On Thu, May 19, 2022 at 4:02 AM William Edwards 
> > <wedwards@xxxxxxxxxxxxxx> 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-galera-cluster/
> > > 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@xxxxxxxxxxxxxxxxxxx
> > > Unsubscribe : https://launchpad.net/~maria-discuss
> > > More help   : https://help.launchpad.net/ListHelp
> >
> > _______________________________________________
> > 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

--
With kind regards,

William Edwards