Use Docker Compose for testing

[AlekSi]

It can be used to simplify Travis CI configuration, add less painful testing with different versions of MySQL, as well as enable easier local testing. For example, see Prometheus' mysqld_exporter:

• https://github.com/prometheus/mysqld_exporter/blob/master/docker-compose.yml
• https://github.com/prometheus/mysqld_exporter/blob/master/.travis.yml

I can work on it if you are interested.

[julienschmidt]

If you feel like this would beneficial, we would be happy to accept a PR!
We would e.g. also like to test different authentication methods, which seems cumbersome to set up with Travis.

[methane]

I don't like running 4 * 9 = 36 builds for every pull requests...
Could you make it more efficient to reduce resource usage on Travis?

[AlekSi]

Sure. What combinations should be excluded?

[methane]

• All Go versions should be tested with latest stable MySQL (5.7 for now)
• All MySQL and MariaDB versions should be tested with latest stable Go (1.9 for now)

4 + 9 - 1 = 12 builds are tested.

[AlekSi]

That way you will miss that unique failure with Go 1.7 and MySQL 5.5: https://travis-ci.org/AlekSi/mysql/jobs/294436832

[methane]

Is it really issue reproducible only on MySQL 5.5 and Go 1.7 combination?
Isn't it a random failure?

[AlekSi]

You are right, now it looks like a random failure to me.
I will do as you proposed.

[methane]

Close because we have moved to GitHub Actions.