Re: MariaDB 10.5 has entered Debian testing (will be in Bullseye)

[Otto Kekäläinen]

> So, if I understand well, if I have 3 MariaDB Buster nodes in a cluster,
> I just need to dist-upgrade them to Bullseye, and it will automagically
> just work and upgrade to Galera 4? If so, that's just great, because
> during our last discussion in Brazil, you told me about something a way
> more risky (ie: turn off 2 nodes, upgrade the 3rd one, then upgrade node
> 1 and 2).

Yes, after we spoke 1,5 years ago Galera has started to support
rolling upgrades from 3->4. I have personal experience that it works.

So keep all 3 nodes on. Upgrade fully one node, wait until it joins
and syncs and cluster is PRIMARY again, then proceed with the 2nd node
etc.

Re: MariaDB 10.5 has entered Debian testing (will be in Bullseye)

[Thomas Goirand]

On 11/26/20 7:35 PM, Otto Kekäläinen wrote:
> 
> 
> to 26. marrask. 2020 klo 18.45 Thomas Goirand  > kirjoitti:
> 
> Hi Otto,
> 
> On 11/26/20 4:44 PM, Otto Kekäläinen wrote:
> > Hello!
> >
> > MariaDB 10.5 release 1:10.5.8-3 finally entered Debian testing
> > today[1]. It has been in unstable since early September, and the work
> > on the successor of 10.3 in Debian started already in January (with
> > 10.4 which then turned into 10.5 as upstream released it this spring).
> 
> Thanks for maintaining MariaDB in Debian.
> 
> Do you happen to know the procedure for upgrading a Galera cluster of 3
> MariaDB nodes from 10.3 to 10.5? Is this formalized in some doc
> anywhere?
> 
> 
> You can do a live rolling upgrade. New hosts with Galera 4 can join a
> running Galera 3 cluster one by one, but once upgrade starts no new old
> hosts can join anymore, only leave.
> 
> https://www.slideshare.net/ottokekalainen/debconf-2020-whats-new-in-mariadb-server-105-and-galera-4#34
> 
> 
> https://galeracluster.com/library/documentation/upgrading.html
> 
> 
> MariaDB 10.4 intoduced Galera 4, so this applies for MariaDB 10.3
> (Galera 3) -> 10.5 ((Galera 4) upgrades as well:
> https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-galera-cluster/
> 

So, if I understand well, if I have 3 MariaDB Buster nodes in a cluster,
I just need to dist-upgrade them to Bullseye, and it will automagically
just work and upgrade to Galera 4? If so, that's just great, because
during our last discussion in Brazil, you told me about something a way
more risky (ie: turn off 2 nodes, upgrade the 3rd one, then upgrade node
1 and 2).

Cheers,

Thomas Goirand (zigo)

Re: MariaDB 10.5 has entered Debian testing (will be in Bullseye)

[Otto Kekäläinen]

to 26. marrask. 2020 klo 18.45 Thomas Goirand  kirjoitti:

> Hi Otto,
>
> On 11/26/20 4:44 PM, Otto Kekäläinen wrote:
> > Hello!
> >
> > MariaDB 10.5 release 1:10.5.8-3 finally entered Debian testing
> > today[1]. It has been in unstable since early September, and the work
> > on the successor of 10.3 in Debian started already in January (with
> > 10.4 which then turned into 10.5 as upstream released it this spring).
>
> Thanks for maintaining MariaDB in Debian.
>
> Do you happen to know the procedure for upgrading a Galera cluster of 3
> MariaDB nodes from 10.3 to 10.5? Is this formalized in some doc anywhere?
>

You can do a live rolling upgrade. New hosts with Galera 4 can join a
running Galera 3 cluster one by one, but once upgrade starts no new old
hosts can join anymore, only leave.

https://www.slideshare.net/ottokekalainen/debconf-2020-whats-new-in-mariadb-server-105-and-galera-4#34

https://galeracluster.com/library/documentation/upgrading.html

MariaDB 10.4 intoduced Galera 4, so this applies for MariaDB 10.3 (Galera
3) -> 10.5 ((Galera 4) upgrades as well:
https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-galera-cluster/

>

Re: MariaDB 10.5 has entered Debian testing (will be in Bullseye)

[Thomas Goirand]

Hi Otto,

On 11/26/20 4:44 PM, Otto Kekäläinen wrote:
> Hello!
> 
> MariaDB 10.5 release 1:10.5.8-3 finally entered Debian testing
> today[1]. It has been in unstable since early September, and the work
> on the successor of 10.3 in Debian started already in January (with
> 10.4 which then turned into 10.5 as upstream released it this spring).

Thanks for maintaining MariaDB in Debian.

Do you happen to know the procedure for upgrading a Galera cluster of 3
MariaDB nodes from 10.3 to 10.5? Is this formalized in some doc anywhere?

Cheers,

Thomas Goirand (zigo)

MariaDB 10.5 has entered Debian testing (will be in Bullseye)

[Otto Kekäläinen]

Hello!

MariaDB 10.5 release 1:10.5.8-3 finally entered Debian testing
today[1]. It has been in unstable since early September, and the work
on the successor of 10.3 in Debian started already in January (with
10.4 which then turned into 10.5 as upstream released it this spring).

This also means that MariaDB 10.3 will be removed (or the remaining
traces of it to be exact) in the following weeks.

MariaDB 10.5 has a rather massive 45 step CI pipeline just for
Debian[2] and we hope the number of bugs is small, but still it is
always expected that in a major upgrade like 10.3 -> 10.5 users might
experience some issues.

If you encounter issues

1) file a high quality bug report at bugs.debian.org, and consider
filing one in parallel at upstream at jira.mariadb.org if the issue
does not seem to be packaging related

2) send a merge request on Salsa following guidelines at
https://wiki.debian.org/Teams/MySQL/patches

MariaDB in Debian is quite heavily on my shoulders right now. I would
be very glad to see more merge requests, even small ones are nice and
show that people contribute.

Some git stats for the post-10.3 cycle in Debian:

git summary 7bf99ca66..HEAD

 project  : mariadb-10.5
 commits  : 197
 authors  :
   187 Otto Kekäläinen 94.9%
 2 Christian Göttsche  1.0%
 2 Helmut Grohne   1.0%
 1 Aurelien Jarno  0.5%
 1 Bastian Germann 0.5%
 1 Christian Ehrhardt  0.5%
 1 Daniel Black0.5%
 1 Faustin Lammler 0.5%
 1 Miroslav Kure   0.5%

Thanks to all contributors! [3]
Also a big thanks those who sent patches as files and very helpful
hints, in particular jrtc27 and the porter folks!

[1] https://tracker.debian.org/pkg/mariadb-10.5
[2] https://salsa.debian.org/mariadb-team/mariadb-10.5/-/pipelines/200608
[3] https://salsa.debian.org/mariadb-team/mariadb-10.5/-/graphs/master