31 Oct
2018
31 Oct
'18
11:11 a.m.
On 31/10/2018 10:52, Thomas Mortagne wrote:
On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol
<vincent(a)massol.net> wrote:
Since we provide Debian package one good reference to know which
version of MySQL to support IMO would be
https://packages.debian.org/search?keywords=mysql-server&searchon=names…
So it would be good to support 5.5 and 5.7
Maybe it worth it to also look on Ubuntu packages for the LTS, as they
don't follow the same cycle:
https://packages.ubuntu.com/search?keywords=mysql-server
Apparently for now version are the same than for Debian.
On 31 Oct 2018, at 10:15, Simon Urli
<simon.urli(a)xwiki.com> wrote:
Hi,
On 31/10/2018 09:06, Vincent Massol wrote:
You mean the versions from apt-get for ex (when using the default repos)?
Indeed the idea could to follow one of them. Any suggestion for which one to follow and
where the info is? Hi devs,
We currently have https://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy
However, it doesn’t say explicitly which versions we officially support:
* For HSQLDB it says 2.3.3 which is wrong since the latest version is 2.4.1
* For MySQL it says 5.x but doesn’t specify which specific version(s)
* Same for other DBs
We cannot really support every versions since supporting means testing too.
So what I propose:
Question 1: definition
* We say we support the latest stable version of the databases for a given version cycle
** For MySQL, it’s the latest of the 5.x cycle, which is 5.7.24 as of today (see
https://hub.docker.com/_/mysql/)
** For PostgreSQL, it’s the latest of the 9.x cycle, which is 9.6.10 as of today (see
https://hub.docker.com/_/postgres/)
** For Oracle, it’s the latest of the 11.x cycle, which is 11.2.0.4.0 as of today (see
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/in…)
+1
Question 2: review what we support
* For MySQL I think we could also start supporting MySQL 8.x (ie the latest version of
that cycle). We have an issue open for it currently:
https://jira.xwiki.org/browse/XWIKI-15215
* For PostgreSQL we could also start supporting versions 11.x (ie the latest version of
that cycle)
* For Oracle, we could also start supporting versions 12.x (ie the latest version of that
cycle)
+0 I don't really know how much effort it involves to ensure the support of the
latest version of each database and to fix the bugs accordingly.
Question 3: decide if we drop some support
* Is there any cycle that we should support for? Right now I think that MySQL 5.x is
still heavily used, same for postgreSQL 9.x I guess. Don’t know for Oracle.
* Any idea?
What about the cycles that are bundled in major LTS distributions?
Here is the one for postgresql (since we also have a pgsql based Debian package)
https://packages.debian.org/search?keywords=postgresql&searchon=names&a…
https://packages.ubuntu.com/search?suite=default§ion=all&arch=a…
So here I see 9.3, 9.5, 10.5
So 9.4, 9.6 and 11
--
Simon Urli
Software Engineer at XWiki SAS
simon.urli(a)xwiki.com
More about us at http://www.xwiki.com
Thanks
-Vinent
Simon
So WDYT about the 3 questions?
Thanks
-Vincent
--
Simon Urli
Software Engineer at XWiki SAS
simon.urli(a)xwiki.com
More about us at http://www.xwiki.com