In this article, We will explain to you how to set up MySQL following multiple databases using Docker-Compose
- root (use can use it for local development)
- test (use can use it for testing)
Production Env:
The production database environment. You can use cloud databases such as AWS RDS, Heroku, etc.
Development Env:
A dedicated environment for database for local development.
Test Env:
A dedicated environment for database testing.
Why we need multiple databases?
If you have only a Production Database and you are developing a new feature if something breaks it will affect the whole Production Database.
For best practice, You must have a different Database Development Environment because if you are developing a new feature in a Development Environment if…