Please lower MySQL requirements in next release

List overview All Threads
Download

newer

older

What is this database error...

CACHE_ACCEL and "You may want to...

Jeffrey Walton

22 Dec 2018 22 Dec '18

5:16 p.m.

We use CentOS 7. Red Hat supplies antique software. It offers Media wiki 1.21, if I recall correctly. It is what it is. We had to take on maintenance of Mediawiki because we wanted to offer newer features users. Skins and extensions sometimes need something newer than what the platform provides. We've managed to update Apache, Python and PHP using SCL (https://wiki.centos.org/AdditionalResources/Repositories/SCL). However, we cannot get the MySQL update to work. We are stuck at MySQL 5.5.60. MySQL 5.5.60 was released April 2018. We can't upgrade to to MW 1.31 due to CentOS's MySQL. We tried to install MW 1.31 but maintenance/update.sh died when trying to update the database. We had to go to backup and restore the installation. It is not just CentOS. Other OSes, like Ubuntu 14 LTS, are boxing users. For example Ubuntu 14 provides MySQL 5.5.62 (https://packages.ubuntu.com/search?keywords=mysql-server). MySQL 5.5.62 was released October 2018. Earlier I said "We've managed to update Apache, Python and PHP...". SCL does not offer Composer. Composer is an entirely new set of hardships. SCL probably does not offer Composer because dev tools have no business being on a production server. While you may think 'composer update' is easy, it took us a day and a half to work around all the problems and exceptions. Please consider lowering the MySQL requirements. Most helpful would be to lower and freeze all requirements for the next 3 or 5 years. A requirements freeze would allow us (and other users) to upgrade Mediawiki without the hassles and aggravations. Thanks in advance.

Show replies by thread

John

22 Dec 22 Dec

5:44 p.m.

I hate to be a downer (I’m normally the one complaining about said updates breaking stuf$ but realistically major version bumps are needed. Ubuntu 14.04 is almost 5 years old and only has 4 more months of support. MySQL 5.5.x went EOL 3 years ago. You want to push support past that? CentOS to my knowledge is the only major distro with issues supporting newer versions of mediawiki. Mediawiki provides support for their LTS releases for 3 years, and releases them about every two years. Forcing mediawiki devs to keep the same requirements for 6+ years is not reasonable. I will also note that if CentOS is shipping with mediawiki 1.21 they are doing it wrong that branch is 6+ years old. On Sat, Dec 22, 2018 at 11:17 AM Jeffrey Walton <noloader(a)gmail.com> wrote:

...

Ryan Schmidt

6:58 p.m.

Try installing MariaDB instead of MySQL. It is a drop-in replacement and the version available in CentOS 7 is recent enough to run modern MediaWiki once you enable the MariaDB yum repo.

...

On Dec 22, 2018, at 9:44 AM, John <phoenixoverride(a)gmail.com> wrote: I hate to be a downer (I’m normally the one complaining about said updates breaking stuf$ but realistically major version bumps are needed. Ubuntu 14.04 is almost 5 years old and only has 4 more months of support. MySQL 5.5.x went EOL 3 years ago. You want to push support past that? CentOS to my knowledge is the only major distro with issues supporting newer versions of mediawiki. Mediawiki provides support for their LTS releases for 3 years, and releases them about every two years. Forcing mediawiki devs to keep the same requirements for 6+ years is not reasonable. I will also note that if CentOS is shipping with mediawiki 1.21 they are doing it wrong that branch is 6+ years old.

On Sat, Dec 22, 2018 at 11:17 AM Jeffrey Walton <noloader(a)gmail.com> wrote: We use CentOS 7. Red Hat supplies antique software. It offers Media wiki 1.21, if I recall correctly. It is what it is. We had to take on maintenance of Mediawiki because we wanted to offer newer features users. Skins and extensions sometimes need something newer than what the platform provides. We've managed to update Apache, Python and PHP using SCL (https://wiki.centos.org/AdditionalResources/Repositories/SCL). However, we cannot get the MySQL update to work. We are stuck at MySQL 5.5.60. MySQL 5.5.60 was released April 2018. We can't upgrade to to MW 1.31 due to CentOS's MySQL. We tried to install MW 1.31 but maintenance/update.sh died when trying to update the database. We had to go to backup and restore the installation. It is not just CentOS. Other OSes, like Ubuntu 14 LTS, are boxing users. For example Ubuntu 14 provides MySQL 5.5.62 (https://packages.ubuntu.com/search?keywords=mysql-server). MySQL 5.5.62 was released October 2018. Earlier I said "We've managed to update Apache, Python and PHP...". SCL does not offer Composer. Composer is an entirely new set of hardships. SCL probably does not offer Composer because dev tools have no business being on a production server. While you may think 'composer update' is easy, it took us a day and a half to work around all the problems and exceptions. Please consider lowering the MySQL requirements. Most helpful would be to lower and freeze all requirements for the next 3 or 5 years. A requirements freeze would allow us (and other users) to upgrade Mediawiki without the hassles and aggravations. Thanks in advance. _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Jeffrey Walton

7:18 p.m.

On Sat, Dec 22, 2018 at 12:59 PM Ryan Schmidt <skizzerz(a)gmail.com> wrote:

...

Try installing MariaDB instead of MySQL. It is a drop-in replacement and the version available in CentOS 7 is recent enough to run modern MediaWiki once you enable the MariaDB yum repo.

Let me ask this... CentOS provides Postgres 9.2, which meets minimum requirements: Available Packages Name : postgresql-server Arch : x86_64 Version : 9.2.24 Release : 1.el7_5 The question is, has anyone had success with a Wiki MySQL to Postgres conversion like at https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_Postgre… ? I personally like Postgres but I am not a hard core database or web guy. I have not hit the painpoints real database and web guys know. Postgres also makes fewer appearances on Bugtraq than MySQL. Jeff Jeff

Jonathan Aquilina

7:24 p.m.

If you guys require newer db versions for centos usually you can find other repos like EPEL or others that will have the newer versions and get the newer versions uploaded to them. https://dev.mysql.com/downloads/repo/yum/ Regards, Jonathan -----Original Message----- From: MediaWiki-l <mediawiki-l-bounces(a)lists.wikimedia.org> On Behalf Of Jeffrey Walton Sent: 22 December 2018 19:18 To: MediaWiki announcements and site admin list <mediawiki-l(a)lists.wikimedia.org> Subject: Re: [MediaWiki-l] Please lower MySQL requirements in next release On Sat, Dec 22, 2018 at 12:59 PM Ryan Schmidt <skizzerz(a)gmail.com> wrote:

...

Try installing MariaDB instead of MySQL. It is a drop-in replacement and the version available in CentOS 7 is recent enough to run modern MediaWiki once you enable the MariaDB yum repo.

David Gerard

10:53 p.m.

I'd always recommend MySQL or a highly compatible variant such as MariaDB - Postgres is great, but Wikimedia runs MariaDB so I do too. - d. On Sat, 22 Dec 2018 at 18:18, Jeffrey Walton <noloader(a)gmail.com> wrote:

...

On Sat, Dec 22, 2018 at 12:59 PM Ryan Schmidt <skizzerz(a)gmail.com> wrote:

Try installing MariaDB instead of MySQL. It is a drop-in replacement and the version available in CentOS 7 is recent enough to run modern MediaWiki once you enable the MariaDB yum repo.

Brian Wolff

23 Dec 23 Dec

4:22 a.m.

On Sat, Dec 22, 2018 at 4:17 PM Jeffrey Walton <noloader(a)gmail.com> wrote:

...

MediaWiki requires MySQL 5.5.8 or greater. Well its not obvious, these version numbers are not "decimal". i.e. 5.5.8 < 5.5.60, so 5.5.60 should work fine If you encounter problems installing on mysql 5.5.60, it is a bug, please tell us the errors you get (unless it was the error from your other post).

...

We can't upgrade to to MW 1.31 due to CentOS's MySQL. We tried to install MW 1.31 but maintenance/update.sh died when trying to update the database. We had to go to backup and restore the installation. It is not just CentOS. Other OSes, like Ubuntu 14 LTS, are boxing users. For example Ubuntu 14 provides MySQL 5.5.62 (https://packages.ubuntu.com/search?keywords=mysql-server). MySQL 5.5.62 was released October 2018. Earlier I said "We've managed to update Apache, Python and PHP...". SCL does not offer Composer. Composer is an entirely new set of hardships. SCL probably does not offer Composer because dev tools have no business being on a production server. While you may think 'composer update' is easy, it took us a day and a half to work around all the problems and exceptions.

Composer is part of the build process. You only need it if installing from git. If downloading the official tarball release you don't need composer (Some skins & extensions like to use composer, but most don't). Generally you probably don't want composer on your production server. Typically people (who are using a git install) would use composer to generate the dependencies on a staging server and copy them over to production. For example, Wikimedia uses a git repo of the composer dependencies ( https://gerrit.wikimedia.org/g/mediawiki/vendor ) for its production servers.

...

Please consider lowering the MySQL requirements. Most helpful would be

to lower and freeze all requirements for the next 3 or 5 years. Mysql 5.5.8 was released in 2010. -- Brian

1945

days inactive

1946

days old

mediawiki-l@lists.wikimedia.org

Manage subscription

6 comments

6 participants

tags (0)

participants (6)

Brian Wolff
David Gerard
Jeffrey Walton
John
Jonathan Aquilina
Ryan Schmidt