Page cover
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Deploy a MariaDB Database on Clouddley

Learn how to deploy a MariaDB database on Clouddley.

Setting up and managing a MariaDB database is simple and efficient with Clouddley. MariaDB is a powerful, open-source relational database known for its speed and reliability. This guide walks you through the deployment process on Clouddley, making it easy for beginners and experienced developers to get their database up and running quickly.

Prerequisites

  • A Clouddley account.

  • A virtual machine on a Cloud platform or a bare metal server.

Step-by-step deployment

1

Accessing Databases

Image of Databases dashboard on Clouddley.
Accessing Databasess
2

Configure your Virtual Machine (VM)

In the Choose or add server dropdown, select your virtual machine (VM) if it’s already listed. If not, select + Add Virtual Machine.

Enter the required details:

VM Host

Provide the host address of your virtual machine.

VM User

Input the username required to access the virtual machine

Port

Specify the port number for the connection

  • Use the Clouddley CLI (recommended) or connect via SSH to verify.

The Clouddley CLI is a command-line tool that allows you to interact with the Clouddley Platform from your terminal.

  • Open the command line of the remote VM you want to configure to Clouddley and install Clouddley CLI by running the command:

curl -L https://raw.githubusercontent.com/clouddley/cli/main/install.sh | sh
  • To add the SSH public key, run the command:

clouddley add key

Using the CLI, you can deploy resources, manage configurations, and automate tasks efficiently.

  • Download the public key to your local machine.

  • Run the provided command on your local machine, allowing Clouddley to connect to your virtual machine.

ssh-copy-id -f -i ~/path/to/downloaded/Publickey username@ipaddress

Replace ~/path/to/downloaded/Publickey ,username and ipaddress with your actual values.

  • Click on Verify to validate the details and confirm the connection.

  • Click Next to proceed.

Configuring the virtual machine during database deployment on Clouddley.
Configuring the virtual machine to host your database
3

Database Name

  • Enter a unique name for your database for easy identification within the virtual machine (VM).

  • Click on Next

Configuring database name on Clouddley.
Defining a unique name for the MariaDB database
4

Select the Database type and version

  • Select MariaDB from the dropdown menu

  • Select the preferred version from the dropdown menu to ensure compatibility with your application.

  • (Optional) Enable the Delete Protection option to prevent accidental deletion of your MariaDB database.

This feature prevents the database from being destroyed unless explicitly disabled.

  • Click on Deploy DB

User selecting the MariaDB database type and version.
Selecting the MariaDB database type and specifying the version for deployment
5

Confirm Deployment

  • Once the deployment is complete, your MariaDB database is ready.

  • Click Go to Dashboard to access and manage your database.

Image of MariaDB database deployed successfully on Clouddley.
MariaDB database successfully deployed

Database Dashboard

You can access and manage your database using the user-friendly dashboard interface.

View details about your database, VM, and settings (e.g., Delete Protection), and use the option to delete the database if it is no longer needed.

An image of the overview section of the MariaDB database deployed on Clouddley..
The dashboard overview with a high-level summary of database performance and status

Access public and private network details, including username, password, host, port, and database type.

An image of the connections section of the MariaDB database deployed on Clouddley.
View the public and private network connections to the MariaDB database

Monitor real-time log streams for troubleshooting and download logs for further analysis.

An image of the logs section of the MariaDB database deployed on Clouddley.
Real-time logs for insights into database activity

Manage a list of database users and securely reset passwords as needed.

An image of the users section of the MariaDB database deployed on Clouddley.
Manage database users through the dashboard's users section

Conclusion

Clouddley makes deploying a MariaDB database easy and hassle-free, allowing you to focus on your applications instead of database management. Explore our other guides to learn how to deploy different databases on Clouddley.

Last updated