Deploy a MySQL Database on Clouddley

Learn how to deploy a MySQL database on Clouddley.

With Clouddley, you can easily deploy and manage a MySQL database, a widely used open-source relational database known for its reliability and performance. This guide walks you through setting up a MySQL database on Clouddley. Whether you're a beginner or an experienced developer, you'll have your database running smoothly in no time.

Prerequisites

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

Step-by-step deployment

Accessing Databases

Log in to your Clouddley account.
Navigate to Databases and Click on Deploy Database

Configure the 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.

Database Name

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

Select the Database type and version

Select MySQL 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 MySQL database type and version.

Confirm Deployment

Once the deployment is complete, your Redis database is ready.
Click Go to Dashboard to access and manage your database.

Image of MySQL database deployed successfully on Clouddley.

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 MySQL database deployed on Clouddley.

Conclusion

Clouddley simplifies MySQL database deployment with its user-friendly interface, automated management, and scalable infrastructure. Whether you're handling small projects or large-scale applications, Clouddley ensures your database is properly managed. Explore our other guides to discover more about deploying other databases on Clouddley.

PreviousDeploy a Redis Database on Clouddley NextExtras

Last updated 29 days ago

Was this helpful?