How to Setup MongoDB Database Admin Tools on Ubuntu Server

MongoDB Database Admin Tools (DBA Tools) are essential for managing and interacting with your MongoDB database. These tools, including mongodump, mongorestore, mongoexport, and mongoimport, empower you to perform crucial tasks like backups, restores, data migration, and more.

This guide provides a comprehensive walkthrough on how to install MongoDB DBA Tools on an Ubuntu 24.04 LTS Virtual Machine (VM). We'll cover everything from setting up your VM on Google Cloud Compute Engine to verifying the installation, ensuring you're ready to manage your MongoDB v8 (and other versions) databases effectively.

This tutorial is divided into two main parts:

Part 1: Setting up your Ubuntu 24.04 LTS VM on Google Cloud Compute Engine

For this guide, we'll utilize Google Cloud Compute Engine to create our VM. Here are the recommended specifications:

• Machine type: E2-medium (or equivalent based on your needs)
• Operating System: Ubuntu 24.04 LTS (Long-Term Support) - This guide is specifically tailored for this version.
• Storage: 500 GiB SSD - Adjust storage based on your anticipated data and backup needs.

You can adjust these specifications based on your specific requirements and budget. Follow the Google Cloud documentation to create a Compute Engine VM instance with these settings.

Part 2: Installing MongoDB DBA Tools

Now that your Ubuntu 24.04 LTS VM is ready, let's proceed with installing the MongoDB DBA Tools.

Important Note: Ensure that the version of your DBA tools is compatible with your MongoDB server version. This guide focuses on MongoDB v8, but the steps can be adapted for other versions by adjusting the repository configuration accordingly. Always refer to the official MongoDB release documentation for version compatibility.

Here are the step-by-step instructions:

Step 1: Update System Packages

Start by updating your Ubuntu system's package lists and upgrading existing packages to their latest versions. This ensures you have a stable and up-to-date base for installing new software.

Bash

sudo apt update && sudo apt upgrade -y

Step 2: Import the MongoDB Public Key

To ensure the authenticity of the MongoDB packages, import the MongoDB public GPG key. This key is used by the APT package manager to verify the integrity of the packages you download from the MongoDB repository.

Bash

wget -qO - https://www.mongodb.org/static/pgp/server-8.0.asc | sudo gpg --dearmor -o /usr/share/keyrings/mongodb-archive-keyring.gpg

Version Consideration: Notice that the URL server-8.0.asc is specific to MongoDB version 8.0. If you are working with a different MongoDB version, you will need to adjust this URL to match the correct version. Consult the MongoDB Release Notes for the appropriate key and repository information for other versions.

Step 3: Add the MongoDB Repository

Next, add the official MongoDB APT repository to your system's software sources list. This tells your system where to find the MongoDB DBA Tools packages. We'll configure the repository for Ubuntu 24.04 LTS (Jammy) and MongoDB 8.0.

Bash

echo "deb [signed-by=/usr/share/keyrings/mongodb-archive-keyring.gpg] https://repo.mongodb.org/apt/ubuntu jammy/mongodb-org/8.0 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-8.0.list > /dev/null

Ubuntu Version Note: While the original draft mentioned "focal," Ubuntu 24.04 LTS is based on the "jammy" release. We've updated the repository configuration accordingly to jammy.

Step 4: Update the Package Lists Again

After adding the new repository, update the APT package lists again to include the MongoDB packages in your system's awareness.

Bash

sudo apt update

Step 5: Install MongoDB DBA Tools

Now you can install the mongodb-database-tools package using APT. This package contains mongodump, mongorestore, mongoexport, mongoimport, and other essential utilities.

Bash

sudo apt install mongodb-database-tools

Step 6: Verify the Installation

To confirm that the installation was successful, check the versions of the installed DBA tools. Run the following commands:

Bash

mongodump --version
mongorestore --version
mongoexport --version
mongoimport --version

If the commands return version information similar to the output below (version numbers might vary slightly depending on the exact tool version), then the installation is complete!

mongodump version: x.x.x
git version: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Go version: gox.x.x
   ... (and similar output for other tools) ...

Congratulations! You have successfully installed MongoDB DBA Tools on your Ubuntu 24.04 LTS VM. You are now equipped to use these powerful tools (mongodump, mongorestore, mongoexport, mongoimport) to manage various tasks related to your MongoDB databases.

Start Managing Your MongoDB Database 😃

With MongoDB DBA Tools installed, you can now leverage their features for tasks such as:

• Backing up your MongoDB data using mongodump.
• Restoring backups with mongorestore.
• Exporting data to various formats like CSV or JSON using mongoexport.
• Importing data from CSV, JSON, and other formats into MongoDB using mongoimport.

Explore the extensive documentation for each tool to understand their full capabilities and options.

References:

• MongoDB Database Tools Downloads - Official MongoDB page for downloading and learning about DBA Tools.