Gitlab CI MySQL Configuration - YAML Example

This example demonstrates how to configure a MySQL database for your Gitlab CI pipelines. It includes a health check to ensure the database is running before proceeding with other pipeline stages.

YAML Configuration

---
stages:
  - healthcheck
  - run

services:
- mysql:5.7

variables:
  # Configure mysql service (https://hub.docker.com/_/mysql/)
  MYSQL_DATABASE: test
  MYSQL_ROOT_PASSWORD: testpassword

connect:
  image: mysql:5.7
  stage: healthcheck
  tags:
    - docker
  script:
  - echo "SELECT 'OK';" | mysql --user=root --password="$MYSQL_ROOT_PASSWORD" --host=mysql "$MYSQL_DATABASE"

post:
  image: mysql:5.7
  stage: run
  dependencies:
    - connect
  tags:
    - docker
  script:
  - echo done

Further Considerations

Remember to replace test and testpassword with your actual database name and root password. Consider adding more robust error handling and security measures for production environments.

External Resources

• GitLab CI/CD YAML documentation
• MySQL Documentation
• MySQL Docker Image