How to Create MySQL Database Clusters

Create a Database Cluster Using the CLI

Create a Database Cluster Using the API

curl -X POST \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
  -d '{"name": "backend", "engine": "pg", "version": "14", "region": "nyc3", "size": "db-s-2vcpu-4gb", "num_nodes": 2, "storage_size_mib": 61440, "tags": ["production"]}' \
  "https://api.digitalocean.com/v2/databases"

import (
    "context"
    "os"

    "github.com/digitalocean/godo"
)

func main() {
    token := os.Getenv("DIGITALOCEAN_TOKEN")

    client := godo.NewFromToken(token)
    ctx := context.TODO()

    createRequest := &godo.DatabaseCreateRequest{
        Name:       "backend",
        EngineSlug: "pg",
        Version:    "14",
        Region:     "nyc3",
        SizeSlug:   "db-s-2vcpu-4gb",
        NumNodes:   2,
        StorageSizeMiB : 61440,
    }

    cluster, _, err := client.Databases.Create(ctx, createRequest)
}

import os
from pydo import Client

client = Client(token=os.environ.get("DIGITALOCEAN_TOKEN"))

create_req = {
  "name": "backend",
  "engine": "pg",
  "version": "14",
  "region": "nyc3",
  "size": "db-s-2vcpu-4gb",
  "num_nodes": 2,
  "storage_size_mib": 61440,
  "tags": [
    "production"
  ]
}

create_resp = client.databases.create_cluster(body=create_req)

Create a Database Cluster Using the Control Panel

You can create a MySQL database cluster at any time from the Create menu by selecting Databases. This takes you to the Create a Database page.

In the create menu, click Databases to open the database cluster creation page. This is where you choose your database cluster’s configuration, like the number and size of nodes and the datacenter region.

Choose a datacenter

In the Choose a datacenter section, select the datacenter for your database cluster.

This page lists the datacenters in which you currently have the most resources. The number of resources you have in each datacenter is listed to the right as X resources. Hover over this text to see the specific resources you have in that datacenter.

For the best performance, create your database in the same datacenter as your other DigitalOcean resources. After creation, you can relocate your cluster to another datacenter.

Choose a database engine

In the Choose a database engine section, choose MySQL.

We currently support MySQL 8. You cannot change the MySQL version after creating a cluster.

Choose a cluster configuration

In the Choose a cluster configuration section, select a Droplet plan and quantity of nodes for the cluster.

If you select the Shared CPU plan, you also need to select a CPU option. Each option lists its combined monthly cost, equivalent hourly cost, and node specifications. For more options, click See all plans.

After creation, you can increase the number or size of nodes in the cluster at any time. However, you cannot downsize nodes to have less storage than the current storage the cluster is currently using.

Choose a storage size

In the Choose a storage size section, you can increase your storage by clicking the up arrow or entering your desired storage amount, in increments of 10 GiB, up to the maximum listed in the storage range. Each 10 GiB of storage you add costs $2 per month.

You can increase your storage at any time. However, You cannot reduce the amount of added storage in a cluster lower than the amount of storage you are currently using in your cluster. If you need to downscale, you can instead fork the cluster and select a smaller storage size for the new cluster.

Finalize and Create

In the last section, Finalize and Create, choose the name for the cluster, the project to add it to, and any tags you want to use.

There are three sub-headers in this section:

• Choose a name: You can leave the automatically-generated name for the database or choose a custom name. Names must be unique, be between 3 and 63 characters long, and only contain alphanumeric characters, dashes, and periods.

• Select a project: You can leave the default project or choose another one.

• Tags: You can add a tag by typing it into the text box and pressing enter. Tags can only contain letters, numbers, colons, dashes, and underscores.

After creation, you can always edit the database’s tags or move it to another project; however, its name cannot be changed.

When you’re ready, click the Create a Database Cluster button.

Clusters typically take five minutes or more to provision, but you can complete important configuration tasks such as restricting inbound connections while you wait.