868869 - Bump MySQL minimum requirement to 5.6.10 to support fulltext indexes on InnoDB tables

Status: NEW

(Bugzilla :: Database, enhancement)

Description

[Frédéric Buclin]

Since MySQL 5.6.4, full-text indexes are supported with InnoDB tables, see http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html. This would let us convert our last MyISAM table to InnoDB: bugs_fulltext, or even drop it entirely in favour of the current longdescs table.

As said in bug 868867, we won't be able to require such a new version before a very long time as RHEL6 still has MySQL 5.1.

Comment 1

[Frédéric Buclin]

Per https://mariadb.com/kb/en/fulltext-index-overview/, this also requires MariaDB 10.0.5 (there is no MariaDB 5.6).

Comment 2

[Sheeri Cabral [:sheeri]]

FYI, MariaDB 10 has lots of features (like cassandra integration) that might not be useful for those running Bugzilla. We tried MariaDB 5.5 in production on our own systems because of the better subqueries, which Oracle put into MySQL in 5.6 anyway...for 5.6 and higher, we have not seen a compelling reason to be on MariaDB.

Please make sure documentation says "MySQL 5.6 and higher or MariaDB 10.0 and higher", or similar. Let's not give the impression that it matters (because it doesn't), and if you need to throw in a reference to Percona Server, go ahead (Percona server uses the same as MySQL versions, as they're still mostly a patch set).

Comment 3

[Bram Mertens]

According to a post by Thomas Schöning in the support forum the minimal version of MySQL is already 5.6. (see https://groups.google.com/d/msg/mozilla.support.bugzilla/ecOWbVlVpns/3qsK3zPOCQAJ)
The docs still mention version 5.0.15 or higher (https://bugzilla.readthedocs.io/en/5.0/installing/mysql.html#mysql).

On RHEL7 MySql 5.6 or MariaDB 10.0 as mentioned here is not available out of the box.

Please update the installation guide.

Is there a way to make bugzilla 5.0.6 run on RHEL7 with mysql 5.5?
mysql Ver 15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64) using readline 5.1

Comment 4

[Frédéric Buclin]

(In reply to Bram Mertens from comment #3)

Is there a way to make bugzilla 5.0.6 run on RHEL7 with mysql 5.5?

There is no problem running Bugzilla 5.0.x with MySQL 5.5. Bugzilla stills supports MySQL 5.0.15.
And I wouldn't install Bugzilla 5.0.5 or 5.0.6 but stay with 5.0.4. Bugzilla 5.0.5 and 5.0.6 have DB changes, which is unacceptable for a stable branch.

Comment 5

[Dave Miller [:justdave]]

Harmony already requires 5.6.12
Bug 1851354 will set the minimum MySQL requirement to 5.6.12 on Bugzilla 5.2, and additionally will auto-detect MariaDB and require MariaDB 10.0.5 or newer on both Harmony and 5.2.

Comment 6

[Dave Miller [:justdave]]

We're no longer blocking MySQL 8 so that bug isn't fixing this one, the one for MariaDB support will include though.