I am wondering if it is possible to spin up two different databases on the same mysql instance in bitbucket pipelines during testing
You could call the mysql client with the root password to create another database, like so:
image: php:7.2-fpm-alpine
pipelines:
default:
- step:
script:
- ...
- RUN apk add mysql-client
- mysql -u root -pyo -h 127.0.0.1 -e "CREATE DATABASE pipelines_secondary"
- ...
services:
- mysql
definitions:
services:
mysql:
image: mysql:5.7
environment:
MYSQL_DATABASE: 'pipelines'
MYSQL_ROOT_PASSWORD: 'yo'
MYSQL_USER: 'test_user'
MYSQL_PASSWORD: 'test_user_password'