[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):

 Replying to [comment:8 netweb]:
 > Did some research on this yesterday, caching is only available for "paid
 accounts" but we can work around this with some custom build scripts and
 hosting these files ourselves.

 I noticed Travis allow custom apt-get repos - we could potentially build a
 repo with just our test versions of MySQL. That'd let us remove the
 perl/cpanm/MySQL Sandbox stuff, too.

 > ''This is beyond the scope of this ticket though and we should look at
 doing "something" with these databases as each DB is coming in at ~300mb
 per DB version! ''

 We can look at stripping things out of the official builds, but I don't
 like our chances. I suspect our better option is going to be a self-hosted
 CI, so that all the transfers stay within our network.

 > With 6 versions of PHP we are currently testing against and the above 7
 databases brings us to 42 tests, if we add MariaDB 5.1, 5.2 and 5.3 to
 this we we end up at 60 jobs / build (Or 80 if we include HHVM & HHVM
 Nightly). MySQL Sandbox does not support, nor work, with MariaDB 10.1alpha
 at this stage ([https://travis-ci.org/ntwb/wordpress/jobs/41939687#L229
 src]).

 I submitted a MySQL Sandbox feature request to add MariaDB 10.1 to the
 allowed versions list:

 https://bugs.launchpad.net/mysql-sandbox/+bug/1395965

 I definitely wouldn't bother with MariaDB 5.1, 5.2 and 5.3.

 > A sneak peek at this is here https://travis-
 ci.org/ntwb/wordpress/builds/41943470 (I'm not actually running PHPUnit
 tests here, these should be listed as `failing` and not `passing` BTW ;)

 That's looking super cool!

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