MySQL How-Tos

Generated on 18 Aug 2026

MySQL is an open source, object-relational database built with speed and reliability in mind. Its large and active developer community has created many third-party applications, tools, and libraries that expand MySQL’s functionality.

Getting Started

How to Create MySQL Database Clusters

Create a MySQL database cluster from the DigitalOcean Control Panel.

How to Create MySQL Advanced Edition Clusters

MySQL Advanced Edition public preview documentation.

How to Connect to MySQL Database Clusters

Connect to MySQL database clusters from the command line or other applications.

How to Secure MySQL Managed Database Clusters

Add additional security to a MySQL managed database cluster by restricting incoming connections and using encrypted connections.

How to Import MySQL Databases into DigitalOcean Managed Databases

Import an existing MySQL database into DigitalOcean Managed Databases.

How to Migrate MySQL Databases

Migrate an existing MySQL database internally or from another provider to DigitalOcean.

Manage Users

How to Manage MySQL Users and Databases in a Database Cluster

Create and delete a database cluster’s databases and database users from the DigitalOcean Control Panel.

How to Modify User Privileges in MySQL Databases

Set and revoke user privileges in MySQL and understand the privilege restrictions on MySQL database clusters.

Monitor

How to Monitor MySQL Database Performance

Access and interpret MySQL database and cluster performance metrics.

How to Set Up MySQL Cluster Monitoring Alerts

Configure alert policies based on database cluster performance metrics.

How to Forward Logs from a MySQL Cluster

Forward database logs to OpenSearch, Elasticsearch, or Rsyslog.

How to Monitor Managed MySQL with PMM 1-Click App

Add Managed MySQL Standard Edition clusters to PMM using the Marketplace 1-Click PMM Integration helper.

Scale Cluster

How to Resize MySQL Database Clusters

Change the size of your database cluster to accommodate your data needs.

How to Add Standby Nodes to MySQL Database Clusters

Add standby nodes to new or existing MySQL database clusters for high availability.

How to Add Read-Only Nodes to MySQL Database Clusters

Add read-only nodes to reduce latency for users in specific regions.

Manage Cluster

How to Schedule Automatic Software Updates for MySQL Database Clusters

Customize the maintenance window for automatic software updates to your database cluster.

How to Tag MySQL Database Clusters

Organize MySQL databases clusters with tags to group and filter databases or create monitoring alert policies for multiple databases at once.

How to Relocate Database Clusters

Change a cluster’s regional datacenter.

How to Configure Custom CNAME Records for MySQL Clusters

Assign custom domain names to MySQL Standard Edition clusters using the DigitalOcean API.

How to Fork a MySQL Database Cluster

Fork a MySQL database cluster to create a new cluster from a point in time or the latest transaction.

How to Manually Restore MySQL Database Clusters from Backups

Recover from accidental data loss by manually restoring a MySQL database cluster from backups.

How to Set Global SQL Mode on MySQL Clusters

Set a MySQL database cluster’s global SQL mode to change its SQL syntax and data validation checks for better integration in different environments or with other database servers.

How to Reconfigure MySQL Database Clusters

Edit your database engine’s configuration and parameters via the CLI or API.

How to Create Primary Keys for MySQL Database Tables

Create primary keys to increase search accuracy, performance, and ensure reliable data replication.

How to Migrate from Managed to Self-Managed MySQL

Export a DigitalOcean Managed MySQL cluster to a MySQL instance you run.

How to Destroy MySQL Database Clusters

Destroy a database cluster to permanently and irreversibly destroy the cluster, its contents, and its automated backups.

We can't find any results for your search.

Try using different keywords or simplifying your search terms.