Create Separate Databases for Each Microservice
Currently, all microservices share a single database (finance_db), which causes schema conflicts and migration issues. To improve isolation and scalability, each microservice should have its own dedicated database.
Tasks:
-
Update docker-compose.yml to define separate Postgres instances for each microservice. -
Modify each microservice's database connection string to point to its respective database. -
Update environment variables and secrets to reflect the new database structure. -
Test connectivity and data isolation between services.
Acceptance Criteria:
- Each microservice has its own database instance.
- No schema conflicts or migration issues across services.
- Services can still communicate where needed via APIs.
Edited by Obeng, Sinead (UG - Comp Sci & Elec Eng)