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

 Replying to [comment:9 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.
 Due to download speeds locally here reminding me of dial up I ain't
 touching this :P But yes, a custom `apt-get` repo is one way, as is a
 single/multiple custom archives of our own hosted on `s.wp.org` (or
 wherever).

 > > ''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.
 I'll post the reply I received from Travis-CI regarding pricing of said
 self-hosted versions to Slack via DM's (not sure that they want the
 pricing public)

 > > 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.
 Cool :)

 > > 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!
 >
 Thanks

 Replying to [comment:10 nacin]:
 > Once we switch over the GitHub repos and use the official
 wordpress/wordpress repo on Travis (later December, I expect), setting up
 a paid account is not a problem. We can also do that temporarily with a
 particular account now.
 Cool +1

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