Automated Rollback for Database Schemas
This topic describes how Harness Database DevOps implements automated rollback to maintain the stability and integrity of your database schema workloads.
Accelerate Innovation Velocity
Harness DB DevOps is a powerful tool that helps accelerate innovation velocity, particularly in the context of managing and evolving database schemas. By using DB DevOps, development teams can introduce new features, improve existing ones, and deploy updates more rapidly and safely.
By integrating DB DevOps into your development workflow, teams can accelerate their innovation velocity by automating and streamlining database schema changes. DB DevOps reduces the friction associated with database updates, allowing teams to focus on delivering new features and improvements faster and with greater confidence. This, in turn, enhances the overall agility of the development process, enabling organizations to stay competitive and responsive to market demands.
Built in failure strategies including rollback
When managing database schema changes, it’s crucial to have mechanisms in place to handle failures gracefully. Built-in failure strategies, including rollback, are designed to protect your application and data by providing automated responses when something goes wrong during a database update.
Rollback is the process of undoing changes that were made to the database if an error occurs during an update. This ensures that the database is returned to its previous state, preventing partial updates that could lead to inconsistencies or application crashes.
This reduces the risk of downtime or data corruption and allows teams to quickly address issues without having to manually intervene.
Automated Rollback for Database Schema Changes
When managing database schema changes, the risk of something going wrong is always present. With Harness DB DevOps, you can help mitigate this risk by providing an automated rollback feature. This feature ensures that if a schema change fails, the database can be quickly and automatically restored to its previous state, maintaining stability and data integrity.
What is Automated Rollback?
Automated rollback is a feature that automatically reverses database changes if an error occurs during a deployment. This prevents partial or inconsistent updates that could disrupt your application or lead to data corruption.
In Harness DB DevOps, automated rollback leverages tags and versioning to ensure a smooth and reliable process. There are two main scenarios where rollback can occur:
- Immediate Rollback: If a change fails to apply during deployment.
- Delayed Rollback: If a change is successfully applied, but a rollback is later required.
Immediate Rollback
By default, if a change fails to apply during deployment, Harness DB DevOps will automatically roll back the change using the database's built-in transaction rollback mechanism. This is what we call an immediate rollback. This ensures that the database remains in a consistent state, even if a part of the deployment fails.
Delayed Rollback
In some cases, you might need to roll back changes that were successfully applied. This could be due to:
- A subsequent change in the deployment pipeline failing
- An application health check failing after deployment
- Other operational or business reasons
For these scenarios, Harness DB DevOps provides a 'Rollback Schema' pipeline step. This step can be configured in your pipeline to roll back to a particular tag, allowing you to revert your database schema to a known good state.
What are tags?
A tag is a marker or label assigned to a specific point in a database's migration history. Harness recommends creating a change every time you deploy a changeset to a database so that you always have a rollback point for future changes.