Upgrade to MariaDB 10.2 - Cloud - lists.wikimedia.org

List overview All Threads
Download

Upgrade to MariaDB 10.2

[Cloud-announce] cloudservices1003...

[Cloud-announce] NFS scratch mount...

Huji Lee

16 Jul 2018 16 Jul '18

8:11 p.m.

Hi all, Does anyone know when we will be upgrading the Clouds replica DBs to MariaDB 10.2? I am asking mainly because we are on 10.1.33, 10.3 is now out, and since 10.2 support for CTEs (WITH statements) has been added which is very handy. Thanks, Huji

Attachments:

attachment.htm (text/html — 784 bytes)

Reply

Show replies by date

Jaime Crespo

17 Jul 17 Jul

7:43 a.m.

Hi, There is no timeline at the moment for an upgrade. We are finishing at the moment the upgrade of other servers in production from 10.0 to 10.1 and from Debian Jessie to Stretch (87% completed), so that is the first blocker to not think about other upgrades (as we cannot support more than 2 versions and operating systems). We tested internally 10.3, and at the moment of the release we considered it not yet ready for production. We are also looking closely at MySQL 8.0, which also offers CTE support, but has other improvements, such as better metadata handling. We are likely going to skip over 10.2. However, I recently asked if CTEs were useful for someone at wikitech [0] and I got very few responses, so it is not at the moment a priority. Natural upgrades happen when: No older version host are longer around, the version is tested enough so we are confident it will cause not issues, and we have the resources to proceed with the upgrade. Note that while new features are always nice, bugs normally come with newer major versions, so every DBAs policy is normally wait a few minor versions to avoid being beta-testers. If I were to guess right now, a possible upgrade may happen mid-next year, tied to Debian Buster upgrade, to either 10.3 or 8.0, but that is just a guess, depends on the above factors. Please let us know how important are things like CTEs or other features are to you so we can prioritize them accordingly. [0] <url: https://lists.wikimedia.org/pipermail/wikitech-l/2018-February/089565.html&…

Reply

Huji Lee

10:29 p.m.

CTEs are not an absolute must-have, they are just very nice to have. Thanks for explaining the decision process. I can certainly wait longer. Huji On Tue, Jul 17, 2018 at 3:43 AM, Jaime Crespo <jcrespo(a)wikimedia.org> wrote:

Hi, There is no timeline at the moment for an upgrade. We are finishing at the moment the upgrade of other servers in production from 10.0 to 10.1 and from Debian Jessie to Stretch (87% completed), so that is the first blocker to not think about other upgrades (as we cannot support more than 2 versions and operating systems). We tested internally 10.3, and at the moment of the release we considered it not yet ready for production. We are also looking closely at MySQL 8.0, which also offers CTE support, but has other improvements, such as better metadata handling. We are likely going to skip over 10.2. However, I recently asked if CTEs were useful for someone at wikitech [0] and I got very few responses, so it is not at the moment a priority. Natural upgrades happen when: No older version host are longer around, the version is tested enough so we are confident it will cause not issues, and we have the resources to proceed with the upgrade. Note that while new features are always nice, bugs normally come with newer major versions, so every DBAs policy is normally wait a few minor versions to avoid being beta-testers. If I were to guess right now, a possible upgrade may happen mid-next year, tied to Debian Buster upgrade, to either 10.3 or 8.0, but that is just a guess, depends on the above factors. Please let us know how important are things like CTEs or other features are to you so we can prioritize them accordingly. [0] <url:https://lists.wikimedia.org/pipermail/wikitech-l/2018- February/089565.html> _______________________________________________ Wikimedia Cloud Services mailing list Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud

Reply

Huji Lee

2 Jun 2 Jun

3:04 p.m.

I wanted to follow-up on this question from 10 months ago and ask if there are any plans to upgrade to MariaDB 10.2 or higher Besides CTEs, another important feature added in 10.2 is the windowed functions LEAD() and LAG() On Tue, Jul 17, 2018 at 6:29 PM Huji Lee <huji.huji(a)gmail.com> wrote:

CTEs are not an absolute must-have, they are just very nice to have. Thanks for explaining the decision process. I can certainly wait longer. Huji On Tue, Jul 17, 2018 at 3:43 AM, Jaime Crespo <jcrespo(a)wikimedia.org> wrote:

Hi, There is no timeline at the moment for an upgrade. We are finishing at the moment the upgrade of other servers in production from 10.0 to 10.1 and from Debian Jessie to Stretch (87% completed), so that is the first blocker to not think about other upgrades (as we cannot support more than 2 versions and operating systems). We tested internally 10.3, and at the moment of the release we considered it not yet ready for production. We are also looking closely at MySQL 8.0, which also offers CTE support, but has other improvements, such as better metadata handling. We are likely going to skip over 10.2. However, I recently asked if CTEs were useful for someone at wikitech [0] and I got very few responses, so it is not at the moment a priority. Natural upgrades happen when: No older version host are longer around, the version is tested enough so we are confident it will cause not issues, and we have the resources to proceed with the upgrade. Note that while new features are always nice, bugs normally come with newer major versions, so every DBAs policy is normally wait a few minor versions to avoid being beta-testers. If I were to guess right now, a possible upgrade may happen mid-next year, tied to Debian Buster upgrade, to either 10.3 or 8.0, but that is just a guess, depends on the above factors. Please let us know how important are things like CTEs or other features are to you so we can prioritize them accordingly. [0] <url: https://lists.wikimedia.org/pipermail/wikitech-l/2018-February/089565.html

_______________________________________________ Wikimedia Cloud Services mailing list Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud

Reply

Manuel Arostegui

3:52 p.m.

El dom., 2 jun. 2019 17:05, Huji Lee <huji.huji(a)gmail.com> escribió:

I wanted to follow-up on this question from 10 months ago and ask if there are any plans to upgrade to MariaDB 10.2 or higher Besides CTEs, another important feature added in 10.2 is the windowed functions LEAD() and LAG()

Hello, At the moment, we are thinking about combining the upgrade to Debian Buster with upgrading to MariaDB 10.3. Cheers Manuel

On Tue, Jul 17, 2018 at 6:29 PM Huji Lee <huji.huji(a)gmail.com> wrote:

CTEs are not an absolute must-have, they are just very nice to have. Thanks for explaining the decision process. I can certainly wait longer. Huji On Tue, Jul 17, 2018 at 3:43 AM, Jaime Crespo <jcrespo(a)wikimedia.org> wrote:

Hi, There is no timeline at the moment for an upgrade. We are finishing at the moment the upgrade of other servers in production from 10.0 to 10.1 and from Debian Jessie to Stretch (87% completed), so that is the first blocker to not think about other upgrades (as we cannot support more than 2 versions and operating systems). We tested internally 10.3, and at the moment of the release we considered it not yet ready for production. We are also looking closely at MySQL 8.0, which also offers CTE support, but has other improvements, such as better metadata handling. We are likely going to skip over 10.2. However, I recently asked if CTEs were useful for someone at wikitech [0] and I got very few responses, so it is not at the moment a priority. Natural upgrades happen when: No older version host are longer around, the version is tested enough so we are confident it will cause not issues, and we have the resources to proceed with the upgrade. Note that while new features are always nice, bugs normally come with newer major versions, so every DBAs policy is normally wait a few minor versions to avoid being beta-testers. If I were to guess right now, a possible upgrade may happen mid-next year, tied to Debian Buster upgrade, to either 10.3 or 8.0, but that is just a guess, depends on the above factors. Please let us know how important are things like CTEs or other features are to you so we can prioritize them accordingly. [0] <url: https://lists.wikimedia.org/pipermail/wikitech-l/2018-February/089565.html

_______________________________________________ Wikimedia Cloud Services mailing list Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud

_______________________________________________

Wikimedia Cloud Services mailing list Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud

Reply

1788

days inactive

2109

days old

cloud@lists.wikimedia.org

Manage subscription

4 comments

3 participants

tags (0)

participants (3)

Huji Lee
Jaime Crespo
Manuel Arostegui