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 <jcre...@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 lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud >
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud