u/Mystery2058

Hello everyone,
We are running a small startup and the problem I am facing right now is single point of failure. Since we don't have much budget, we have hosted in cheap VPS as of now.

We have multiple services(python, node, db, redis, etc) and everything is dockerized inside a compose. So we run staging and production environment behind a nignx revere proxy. Both environment is hosted in single vps. We don't have any monitoring and observisibilty tool right now. The way we deploy is build docker image via github action and push it into vps and run it.

So for our setup, how can we improve our deployment and what are the best strategies we can adapt.

Thank you.

I am using TypeORM with a MySQL database. I've noticed that if I have a single migration file containing multiple structural changes (like several CREATE TABLE or ALTER TABLE statements) and the migration fails halfway through, the database gets stuck in a partially updated state.

Even though TypeORM wraps the migration in a transaction and logs a ROLLBACK when the error occurs, the structural changes that ran before the error remain in the database. I understand this happens because MySQL issues an "implicit commit" for DDL statements, effectively ignoring the transaction. Because the migration fails, it isn't recorded in the migrations table, which leaves my codebase and database schema out of sync.

What is the best way to handle this?

I am using TypeORM with a MySQL database. I've noticed that if I have a single migration file containing multiple structural changes (like several CREATE TABLE or ALTER TABLE statements) and the migration fails halfway through, the database gets stuck in a partially updated state.

Even though TypeORM wraps the migration in a transaction and logs a ROLLBACK when the error occurs, the structural changes that ran before the error remain in the database. I understand this happens because MySQL issues an "implicit commit" for DDL statements, effectively ignoring the transaction. Because the migration fails, it isn't recorded in the migrations table, which leaves my codebase and database schema out of sync.

What is the best way to handle this?

Hello everyone, I am currently working on a start-up for the past 1.5 years and now I am thinking of change. I am also one of the founding engineer too and have worked from the ground up making everything from scratch and scaling it.

Now I feel like work is repetitive and mostly mentoring interns. So I am looking for new change, I again want to work in early stage startup where the iteration is very fast. If there is anything you know, I would love to talk to.

Thank you