[wp-trac] [WordPress Trac] #30462: Test multiple MySQL versions on Travis

[WordPress Trac]

#30462: Test multiple MySQL versions on Travis
------------------------------+------------------------------
 Reporter:  pento             |       Owner:
     Type:  enhancement       |      Status:  new
 Priority:  normal            |   Milestone:  Awaiting Review
Component:  Build/Test Tools  |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  has-patch         |     Focuses:
------------------------------+------------------------------

Comment (by pento):

 Going by some recent testing, it looks like we should try and cache the
 MySQL builds, or host them ourselves - sometimes the download is really
 slow. I'm not sure if that's the MySQL CDN or the Travis network, though.

 As suggested by @netweb, we should test against MariaDB, as well. For
 reference, here's an approximate version match:

 MariaDB 5.1 = MySQL 5.1
 MariaDB 5.2 = MySQL 5.1
 MariaDB 5.3 = MySQL 5.1 + some of 5.5
 MariaDB 5.5 = MySQL 5.5
 MariaDB 10.0 = MySQL 5.5 + some of 5.6
 MariaDB 10.1 (alpha) = MySQL 5.5 + most of 5.6 + some of 5.7

 As of 10.0, MariaDB is starting to diverge from MySQL more heavily. It
 still aims to be compatible, but incompatibilities will inevitably be
 introduced.

 I'm inclined to test against MariaDB 10.0 and 10.1, and also add MySQL 5.7
 for alpha testing. It's tricky to drag MariaDB usage out of our MySQL
 stats, but I'd expect MariaDB 5.x to be lower than 10.0, which is already
 pretty small.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/30462#comment:7>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform