As per documentation, the default mysql version on CircleCI is 5.5.41.
I’m currently using MySQL statements (INET6_ATON) that require MySQL version 5.6 and above.
On top of that, our production environment is running
In circle.yml, it is easy to choose the PHP or Node versions. You just add
php: version: 5.5.21 node: version: 4.1.0
…But currently CircleCI does not support defining the MySQL version this way.
So 2 questions:
- How to specify the MySQL version in CircleCI ?
- How to change the database from MySQL to MariaDB ?
What I’ve already tried:
Error installing MySQL 5.6
This is not working, getting the following error:
sudo apt-get update; sudo DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server-5.6 returned exit code 100
Installing MySQL 5.7
I was able to install MySQL 5.7 using the command below. This way my tests run fine again. yay.
export DEBIAN_FRONTEND=noninteractive && curl -sSL https://s3.amazonaws.com/circle-downloads/install-mysql5.7-circleci.sh | sh
However I am still interested in hearing how I can easily pick ANY MySQL version, or how I can use the MariaDB database architecture