DevOps: Database Change Management with MongoDB
A series of articles about DevOps: Database Change Management with MongoDB.
- DevOps: Database Change Management with MongoDB (this one)
- DevOps: Database Change Management with MongoDB and GitHub
MongoDB is a document database used to build highly available and scalable internet applications.
This tutorial will guide you step-by-step to set up database change management for MongoDB (Cloud and Server) in Bytebase. With Bytebase, a team can have a formalized review and rollout process to make MongoDB data change.
You’ll have a GUI and the full change history. You can use Bytebase free version to finish the tutorial.
- Change Workflow
- Change History
Before you start this tutorial, make sure:
- You have either of
- You have Docker installed locally.
Step 1 - Start Bytebase in Docker
Make sure your docker daemon is running, and start the Bytebase docker container.
Bytebase is running successfully in Docker, and you can visit it via
Visit localhost:5678 in your browser. Register the first admin account which will be granted
Step 2 - Add MongoDB in Bytebase
In Bytebase, an Instance could be your on-premises MySQL instance, an AWS RDS instance etc, in this tutorial, a MongoDB Atlas account or a MongoDB Server instance.
localhost:5678and log in as
Click Add Instance.
Add a MongoDB instance and click Create.
Pay attention to some fields:
Test, if you choose
Prod, issues will wait for approval by default. In this tutorial, we try to keep it simple. However, it’s all configurable.
Cloud (MongoDB Atlas)
If you use Cloud version.
Go to Atlas MongoDB Security > Network Access and add IP allowing access from
Go to Atlas MongoDB Deployment > Database, and click Connect.
Click Connect to your application.
Find this string
cluster0.8bxxxbz.mongodb.net. Go back to Bytebase, put the string into Host or Socket, and leave Port empty.
mongodb+srv:// as Connection String Schema.
If you run MongoDB server, fill in Host or Socket with
mongodb:// as Connection String Schema.
Step 3 - Create a project with MongoDB instance
In Bytebase, Project is the container to group logically related Databases, Issues and Users together, which is similar to the project concept in other dev tools such as Jira, GitLab. So before you deal with the database, a project must be created.
After the instance is created, click Projects on the top bar.
Click New Project to create a new project
TestMongo, key is
TMG, mode is
standard. Click Create.
Step 4 - Create a database in MongoDB via Bytebase
In Bytebase, a Database is the one created by 'CREATE DATABASE xxx'. A database always belongs to a single Project. Issue represents a specific collaboration activity between Developer and DBA such as creating a database, altering a schema. It's similar to the issue concept in other issue management tools.
Go into the project
TestMongo. Click New DB on the project top bar.
Fill the form with New Database Name -
dbdemo, New Collection Name -
cdemo, Environment -
Test, and your created instance. Click Create.
It will create an issue automatically. Because it’s for
Testenvironment, the issue will run without waiting for your approval by default. Click Resolve, and the issue is
Done. A database and a collection are created.
Go back to the home page by clicking Home on the left sidebar. On the home page, you can see the project, the database, and the issue you just resolved.
Step 5 - Add data in MongoDB via Bytebase
In Step 4, you created an issue to create a database and a collection via UI workflow and then executed it. Let’s try to create another issue to add data to it.
Go to project
TestMongoDB, and click Change Data.
dbdemoand click Next. It could generate a pipeline if you have different databases for different environments.
Input statement as follows, and click Create.
Bytebase will do some basic checks and then execute the statement. Since it’s for
Testenvironment, the issue is automatically approved by default. Click Resolve issue, and the issue status will become
Go to Change History under the project to view the full history. Or go into a specific database to view its history.
Summary and Next
Now you have connected MongoDB with Bytebase, and tried out the UI workflow to do data change. Bytebase will record the full change history for you.
In the next article, you’ll try out GitOps workflow, which will store your MongoDB in GitHub and trigger the change upon committing the change to the repository, to bring your MongoDB change workflow to the next level, aka Database DevOps - Database as Code.