MySQL How-Tos

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

Create a MySQL database cluster from the DigitalOcean Control Panel.
Connect to MySQL database clusters from the command line or other applications.
Migrate an existing MySQL database internally or from another provider to DigitalOcean.
Import an existing MySQL database into DigitalOcean Managed Databases.
Add additional security to a MySQL managed database cluster by restricting incoming connections and using encrypted connections.
Customize the maintenance window for automatic software updates to your database cluster.
Organize MySQL databases clusters with tags to group and filter databases or create monitoring alert policies for multiple databases at once.

MySQL Management

Create and delete a database cluster’s databases and database users from the DigitalOcean Control Panel.
Set and revoke user privileges in MySQL and understand the privilege restrictions on MySQL database clusters.
Access and interpret MySQL database performance metrics.
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.
Create primary keys to increase search accuracy, performance, and ensure reliable data replication.
Edit your database engine’s configuration and parameters via the CLI or API.

Cluster Infrastructure

Add standby nodes to new or existing MySQL database clusters for high availability.
Add read-only nodes to reduce latency for users in specific regions.
Access and understand performance metrics for nodes in a database cluster.
Configure alert policies based on database cluster performance metrics.

Cluster Management

Fork a database cluster to create a new cluster from an existing cluster based on a specific point in time.
Recover from accidental data loss by manually restoring a MySQL database cluster from backups.
Destroy a database cluster to permanently and irreversibly destroy the cluster, its contents, and its automated backups.