Deploy a MySQL Database on Clouddley Triggr

Learn how to deploy a MySQL database on Triggr.

With Clouddley Triggr, 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 Triggr. 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

1

Accessing Triggr Databases

• Log into your Clouddley account.

• Navigate to Triggr Databases and Click on Deploy Database

Accessing Triggr Databases

2

Configure the Virtual Machine (VM)

Start by configuring your virtual machine environment to host your database. Follow the instructions below:

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

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:

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

• To install Triggr, run the command:

clouddley triggr install

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

SSH

• Download the public key to your local machine.

• Run the provided command in your local machine allowing Triggr 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 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

Defining a unique name for the MySQL database

4

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

Selecting the MySQL database type and specifying the version for deploymen

5

Confirm Deployment

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

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

MySQL database successfully deployed

Triggr Database Dashboard

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

Overview

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

The dashboard overview with a high-level summary of database performance and statu

Connections

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

View the public and private network connections to the MySQL database

Logs

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

Real-time logs for insights into database activity

Users

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

Manage database users through the dashboard's users section

Conclusion

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