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
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
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@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@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
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@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@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@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
El dom., 2 jun. 2019 17:05, Huji Lee huji.huji@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@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@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@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud