MySQL

Presentation

Production-ready MySQL database via Docker Compose with persistent volumes, health checks, and native password authentication.

→ MySQL Documentation

What create-faster adds

Beyond the official setup, we include:

Docker Compose Configuration:

• Pre-configured mysql:latest service
• Project-specific naming (mysql-{projectName})
• Persistent data volume
• Health check with mysqladmin ping
• Connection limit (100 max connections)
• Native password authentication enabled
• Dedicated network for isolation

File created:

docker.compose.yml          # MySQL service configuration

Service Configuration:

• Image: mysql:latest
• Container: mysql-{projectName}
• Port: 3306 (MySQL default)
• Restart: always

Environment Variables:

• MYSQL_ROOT_PASSWORD: password (change in production)
• MYSQL_DATABASE: mysql-{projectName}
• MYSQL_USER: mysql
• MYSQL_PASSWORD: password

Volume:

• mysql-{projectName}-data:/var/lib/mysql (persistent storage)

Network:

• mysql-{projectName}-network (bridge network for isolation)

Command:

• --max-connections=100 - Connection pooling limit
• --default-authentication-plugin=mysql_native_password - Compatibility with older clients

Health Check:

• Test: mysqladmin ping -h localhost -u root -ppassword
• Interval: 10s, Timeout: 5s, Retries: 5
• Start period: 30s for initialization

Connection String:

mysql://mysql:password@localhost:3306/mysql-{projectName}