MySQL Quickstart

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.

To follow along, you will need a DigitalOcean account. If you don’t already have one, you can register on the sign up page.

Create MySQL Database Clusters

  1. From the Create menu in the top right of the control panel, click Databases.
  2. Select MySQL as the database engine.
  3. Choose the cluster configuration and datacenter, and give the cluster a unique name.
    Tip
    For the best performance, create your database cluster in the same region as your Droplets.
  4. Click Create a Database Cluster.

Change Size or Number of Cluster Nodes

  1. Select your database cluster from the Databases page.
  2. Click the Settings tab.
  3. Click Edit in the Cluster configuration section.
  4. Select the node size and number of optional standby nodes.
  5. Click Save.

Relocate or Migrate Database Clusters

  1. Select your database cluster from the Databases page.
  2. Click the Settings tab.
  3. Click Edit in the Cluster datacenter section.
  4. Select the region and datacenter to which you want to relocate/migrate your cluster.
  5. Click Save.

Add Additional Users or Databases

  1. Select your database cluster from the Databases page.
  2. Click the Users & Databases tab.
  3. Enter users or database names in the corresponding field.
  4. Click Save.

Use a client application or command-line tool to manage specific user permissions.

Delete Database Clusters

  1. Select your database cluster from the Databases page.
  2. Click the Settings tab.
  3. Click Destroy in the Destroy this database cluster section.
  4. Enter the name of the database cluster.
  5. Click Destroy.