Hey everyone! I'm pretty new to Docker and infrastructure in general, and I'm currently working on setting up CI/CD alongside automatic database migrations. I'm facing a problem: when my database migration fails because of a bad connection, Docker still ends up recreating my frontend container, which leaves my service offline since it doesn't start. I'd like to keep the frontend service running even if the migration fails, and I don't want the current frontend container to be overwritten. I'm using a Next.js app with a PostgreSQL database hosted on Dokploy, and the database is in another container that I created through Dokploy, not through my Docker Compose file. Here's my `docker-compose.yml` for context. Any advice on how to handle this?
2 Answers
It sounds like you're dealing with service dependencies that can be tricky! One way to tackle this is by modifying the `depends_on` condition in your `docker-compose.yml`. Currently, you're using `service_completed_successfully`, which will lead to your frontend being recreated if the migration fails. You might want to consider using health checks for the migration service that can help the frontend stay alive if the migration fails. This way your frontend service won't get stuck waiting for a migration that isn't happening. Also, ensure your migration container can handle failures gracefully!
I totally get your frustration! If the migration must fail without affecting your frontend, one idea could be to decouple your migration process from the deployment of your frontend. Consider running the migration as a separate step that you trigger manually or in a controlled way, instead of putting it directly in your container management. You'd need to ensure that your database state remains consistent at all times, though.
That makes sense! I hadn't thought about making it a manual process. I guess I need to put a bit more thought into how the migration impacts the overall deployment.
Thanks for the tip! I've been thinking about health checks too. Can you point me to some resources on how to set those up for my migration service?