Streamline Database Change Management for TiDB Cloud with Bytebase
We are proud to announce our partnership with PingCAP, the company building TiDB, which provides scaling database infrastructure solutions via an open-source platform. This partnership will help developers and DBAs to more efficiently and safely manage the lifecycle of application database schemas.
Streamline schema management on TiDB Cloud
TiDB Cloud is a fully-managed database-as-a-service (DBaaS) offering of TiDB, the most capable, open source, distributed SQL database for building modern applications that are elastic, reliable, versatile, and downright powerful. TiDB’s Hybrid Transactional/Analytical Processing (HTAP) data engine unlocks greater developer productivity with a streamlined architecture while also providing real-time insights into operational data.
However, provisioning an instance of a cloud database is only the beginning of the lifecycle. As your business grows and changes, you need to modify the database schema (CREATE TABLE, CREATE INDEX) or change data (INSERT, UPDATE, DELETE). If this type of work is sidelined, it affects database performance. Worse, if a wrong statement is issued, such as accidentally using the DROP TABLE statement, the business will be interrupted for a long time.
Bytebase is a DevOps tool that gives you a unified web portal to change, query, secure, and govern the database throughout the application development lifecycle.
The following is a streamlined database change management flow for TiDB Cloud with Bytebase:
DBA, platform, or self-service DevOps engineers provision the database instance on TiDB Cloud.
They then add the instance into Bytebase. Bytebase will then automatically synchronize all the database schema information from the instance.
Each database is transferred to the specific Bytebase project owned by the application team. At this point, the database joins the software development lifecycle (SDLC) and is ready to be used by application developers. This way, application development teams can collaborate and be involved in database change management.
A more codified workflow with Terraform
Terraform is an Infrastructure-as-Code tool that defines and configures infra resources in a repeatable and predictable manner. This reduces human error, especially for large-scale infra management. Since both TiDB Cloud and Bytebase are verified Terraform providers, the workflow described above can be more streamlined with code (GitOps).
- Provision and configure TiDB Cloud instances with TiDB Cloud Terraform Provider. For more details, see TiDB Cloud Terraform Integration Overview.
For example, the following code creates a TiDB Cloud Serverless resource:
- Integrate TiDB Instances into the Bytebase change management process with the Bytebase Terraform provider. For more details, see Manage Bytebase with Terraform.
For example, the following code adds the specified TiDB Cloud instance into Bytebase:
Delivering the next-generation database change management experience
With TiDB Cloud, developers can provision a serverless, distributed HTAP database in seconds. With Bytebase, application teams can have a single portal to manage the entire TiDB development lifecycle.
Also, teams can use Terraform providers to adopt database-as-code and codify the entire database provisioning and preparation process.
This is the experience we hope to deliver: an easy-to-use database development and management solution for developers and DBAs to collaborate.
Try it out and let us know your thoughts on our Discord channel.