# Deploy a MariaDB Database on Clouddley

Setting up and managing a [MariaDB](https://mariadb.org/) database is simple and efficient with [Clouddley](https://clouddley.com/triggr). 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](https://clouddley.com/) account.
* A virtual machine on a Cloud platform or a bare metal server.

## Step-by-step deployment

{% stepper %}
{% step %}

### Accessing Databases

* Log in to your [Clouddley](https://clouddley.com/) account.
* Navigate to [**Databases**](https://app.clouddley.com/services) and Click on **Deploy Database**

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FtlRPvmaVyzDFS1T11G8o%2FDbs-dashboard.png?alt=media&#x26;token=68180a8b-c163-4d5d-962e-fe7b862f4e9a" alt="Image of Databases dashboard on Clouddley."><figcaption><p>Accessing Databasess</p></figcaption></figure>
{% endstep %}

{% step %}

### 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:

<table><thead><tr><th width="127"></th><th></th></tr></thead><tbody><tr><td><strong>VM Host</strong></td><td><em>Provide the host address of your virtual machine.</em></td></tr><tr><td><strong>VM User</strong></td><td><em>Input the username required to access the virtual machine</em></td></tr><tr><td><strong>Port</strong></td><td><em>Specify the port number for the connection</em></td></tr></tbody></table>

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

{% tabs %}
{% tab title="Clouddley CLI" %}
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:

```bash
curl -L https://raw.githubusercontent.com/clouddley/cli/main/install.sh | sh
```

* To add the SSH public key, run the command:

```bash
clouddley add key
```

Using the CLI, you can deploy resources, manage configurations, and automate tasks efficiently.
{% endtab %}

{% tab title="SSH" %}

* Download the public key to your local machine.
* Ru**n** 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
```

{% hint style="info" %}
Replace `~/path/to/downloaded/Publickey` ,`username` and `ipaddress`  with your actual values.
{% endhint %}
{% endtab %}
{% endtabs %}

* Click on **Verify** to validate the details and confirm the connection.
* Click **Next** to proceed.

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FAp7SFQG9SID9WIIdLs1k%2FDbs-configure-vm.png?alt=media&#x26;token=cdaf77cf-c40a-4fe3-8707-28bcf62fb7f5" alt="Configuring the virtual machine during database deployment on Clouddley."><figcaption><p>Configuring the virtual machine to host your database</p></figcaption></figure>
{% endstep %}

{% step %}

### Database Name

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

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2Fe6rwFfpNdZn3WwalHltx%2FDbs-mariadb-name.png?alt=media&#x26;token=0f64f89c-7bd3-4c9c-8b83-7ace9e3d0591" alt="Configuring database name on Clouddley."><figcaption><p>Defining a unique name for the MariaDB database</p></figcaption></figure>
{% endstep %}

{% step %}

### 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.

{% hint style="info" %}
This feature prevents the database from being destroyed unless explicitly disabled.
{% endhint %}

* Click on **Deploy DB**

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2Fg0MRx8f0YX6oCzake3JR%2FDbs-mariadb.png?alt=media&#x26;token=4469bfa3-dd4f-4cda-9ece-1605b12a362f" alt="User selecting the MariaDB database type and version."><figcaption><p>Selecting the MariaDB database type and specifying the version for deployment</p></figcaption></figure>
{% endstep %}

{% step %}

### Confirm Deployment

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

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FxvhqK2CRhloyPtDkGTLd%2FTD-successDeploy.png?alt=media&#x26;token=e37f5b70-e33d-465b-bf92-5eec3b490771" alt="Image of MariaDB database deployed successfully on Clouddley."><figcaption><p>MariaDB database successfully deployed</p></figcaption></figure>
{% endstep %}
{% endstepper %}

## Database Dashboard

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

{% tabs %}
{% tab title="Overview" %}
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.&#x20;

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FXCNxPzip67GJLQ8nfEKg%2FDbs-mariadb-overview.png?alt=media&#x26;token=3c70c6e3-f3f7-48d7-8e1a-b7385ac82f94" alt="An image of the overview section of the MariaDB database deployed on Clouddley.."><figcaption><p>The dashboard overview with a high-level summary of database performance and status</p></figcaption></figure>
{% endtab %}

{% tab title="Connections" %}
Access public and private network details, including username, password, host, port, and database type.

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FmlHVmMjnYy1WvvAblCfH%2FDbs-mariadb-conn.png?alt=media&#x26;token=7cd7baea-49a7-481e-901e-acd652a2afd7" alt="An image of the connections section of the MariaDB database deployed on Clouddley."><figcaption><p>View the public and private network connections to the MariaDB database</p></figcaption></figure>
{% endtab %}

{% tab title="Logs" %}
Monitor real-time log streams for troubleshooting and download logs for further analysis.

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FfDhDEnPFwAROc3akLwPp%2FDbs-mariadb-logs.png?alt=media&#x26;token=a89beee9-8982-463d-a5e8-2d67699888f3" alt="An image of the logs section of the MariaDB database deployed on Clouddley."><figcaption><p>Real-time logs for insights into database activity</p></figcaption></figure>
{% endtab %}

{% tab title="Users" %}
Manage a list of database users and securely reset passwords as needed.

<figure><img src="https://3695617198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1yp2SdNQtlQTJArGRUVU%2Fuploads%2FtNLx3bsXDEidpbCEJL6d%2FDbs-mariadb-users.png?alt=media&#x26;token=824584f4-fae2-4993-9dd0-27ca764767af" alt="An image of the users section of the MariaDB database deployed on Clouddley."><figcaption><p>Manage database users through the dashboard's users section</p></figcaption></figure>
{% endtab %}
{% endtabs %}

## 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](https://docs.clouddley.com/databases/how-to-guides) to learn how to deploy different databases on Clouddley.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.clouddley.com/databases/how-to-guides/deploy-a-mariadb-database-on-clouddley.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.