Hello, We are in a weird situation where we don't say we support MariaDB but "the latest MySQL version of stable Debian repository", which is currently... MariaDB [1]
So we need to update our strategy about this fact. I am currently setting up a server with debian 9 (stable) and I don't know if I should install MySQL from the Oracle repository our continue with the standard debian package (MariaDB). On my side, I am not against aligning ourself to debian. Basically, all users installing XWiki with our Debian packages are using MariaDB for a year now [2], and we never encounter any problem so far. Thanks, [1] https://packages.debian.org/stretch/default-mysql-server (dep: mariadb-server-10.1) [2] https://www.debian.org/News/2017/20170617.en.html Le lun. 12 nov. 2018 à 18:54, Thomas Mortagne <thomas.morta...@xwiki.com> a écrit : > Indeed mysql-server package (version 5.5.9999) leads to > mariadb-server-10.1 in current stretch repository. > > What is surprising is that this is not the case for sid which is more > or less supposed to be the future. It's also not the case in Ubuntu > which is doing the same thing as sid. > On Mon, Nov 12, 2018 at 6:22 PM Eduard Moraru <enygma2...@gmail.com> > wrote: > > > > I am not up to date on the topic, but I would like to add the fact that > > Debian 9 ("stretch") has actually dropped MySQL and moved officially to > > MariaDB, forcefully migrating existing MySQL installed versions to > MariaDB. > > > > > https://www.debian.org/releases/stable/amd64/release-notes/ch-whats-new.en.html#mariadb-replaces-mysql > > > > The default mysql-server package now redirects to MariaDB instead. > > > > If we are going to follow Debian's lead, we might want to at least > consider > > this move. > > > > Thanks, > > Eduard > > > > On Mon, Nov 12, 2018 at 6:38 PM Vincent Massol <vinc...@massol.net> > wrote: > > > > > > > > > > > > On 12 Nov 2018, at 16:52, Vincent Massol <vinc...@massol.net> wrote: > > > > > > > > So we need to conclude on this thread. I’m proposing to update the > page > > > with: > > > > > > > > * HSQLDB - Latest only > > > > * MySQL - latest of oldstable/stable/unstable from > > > > https://packages.debian.org/search?keywords=mysql-server&searchon=names&exact=1 > > > (i.e. latest of 5.5.x and 5.7.x today) > > > > * PostgreSQL - latest of oldstable/stable/unstable fromhttps:// > > > packages.debian.org/search?keywords=postgresql&searchon=names&exact=1 > > > (i.e. latest of 9.4.x, 9.6.x and 11.x today) > > > > * Oracle - latest of 12.x (we currently test on 11.x AFAIK so we > need to > > > start testing on 12.x from now on) > > > > > > > > Note that by “support" we mean test on. And it’s not because a > version > > > is not supported that it doesn’t work nor that we won’t fix it if a > problem > > > happens. > > > > > > > > I hesitated a long time for the mysql/pgsql versions since I wanted > only > > > a single version supported, but since we provide a debian packaging it > > > makes sense to test the versions defined by the debian repos, and now > that > > > we have automated functional tests on various configurations, we can > test > > > on them. BTW I suggest we run all tests on the latest version only > (i.e. > > > 5.7.x for mysql and 11.x for postgresql, and move to mysql 8.x when we > fix > > > the bug on it) and then we do smoke tests on the other versions. > > > > > > > > Let me know quickly if you have a problem with this strategy since > I’d > > > like to update the page + add the configs in our CI tests. > > > > > > FYI, I’ve now updated the page at > > > https://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy > > > (but I can update/revert if need be). > > > > > > Thanks > > > -Vincent > > > > > > > > > > > Thanks > > > > -Vincent > > > > > > > > > > > >> On 31 Oct 2018, at 09:06, Vincent Massol <vinc...@massol.net> > wrote: > > > >> > > > >> 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/index.html > > > ) > > > >> > > > >> 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) > > > >> > > > >> 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? > > > >> > > > >> So WDYT about the 3 questions? > > > >> > > > >> Thanks > > > >> -Vincent > > > > > > > > > > > > > > -- > Thomas Mortagne > -- Guillaume Delhumeau (guillaume.delhum...@xwiki.com) Research & Development Engineer at XWiki SAS Committer on the XWiki.org project