In one of the applications that I’m working on at the moment, there was a requirement to automate the DB migrations into the pipeline. Our database model is based on a multi-tenant database design. That means in the same database, you can find many schemas.
In one of the applications that I’m working on at the moment, there was a requirement to automate the DB migrations into the pipeline. Our database model is based on a multi-tenant database design. That means in the same database, you can find many schemas. The database structure will look something like the following.
Multi-tenant DB model
When there’s a need to do a DB migration, we used to run our migration script against every schema, which was a tedious task.
For example, let’s say that we want to add a new column,
table_1. We should write the following SQL statement to do that.
Alter table table_1 Add Column column_A varchar(255)
Since we use a multi-tenant database design, this same change needs to be done to every schema in the database because
table_1 is there in every schema.
After using Jenkins on several projects, we say it's time to move on. Jenkins is left behind with his old approach — found out more!
What is DevOps? What are the goals it helps achieves? What are its benefits? This article has answers!
To move or not to move? Benefits are multifold when you are migrating to the cloud. Get the correct information to make your decision, with our cloud engineering expertise.
DevOps and Cloud computing are joined at the hip, now that fact is well appreciated by the organizations that engaged in SaaS cloud and developed applications in the Cloud. During the COVID crisis period, most of the organizations have started using cloud computing services and implementing a cloud-first strategy to establish their remote operations. Similarly, the extended DevOps strategy will make the development process more agile with automated test cases.
Devops for Databases look like a perfect match. Database Devops can function like a well-oiled machine that ensures successful implementation of your devops strategy.