For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

You can resize existing MySQL database clusters at any time to change CPUs, RAM, and storage, including scaling up or down when disk utilization and plan limits allow.

Scaling Down

You can scale down compute and storage when the target configuration keeps projected disk utilization at or under 80%. Projected utilization is calculated using the size of your most recent backup plus your current log size. The combined size must be within 80% of the target storage.

Each compute plan enforces minimum and maximum storage values. When scaling down, the target storage must remain within these limits, even if the 80% utilization check would otherwise allow a smaller size. You can choose a smaller compute tier only if the requested storage falls within that tier’s allowed range.

For example, starting from a General Purpose Dedicated CPU plan with 4 vCPU / 16 GiB RAM, 100 GiB storage, and 80 GiB used for data:

Resize a Database Cluster Using Automation

You can resize a database cluster using the DigitalOcean CLI (doctl) or the API.

Resize a Database Cluster via CLI

To resize a database cluster using doctl, you need to provide a value for the --size flag, which specifies the cluster’s new configuration (number of CPUs, amount of RAM, and hard disk space). Use the doctl databases options slugs command to get a list of available values.

Resize a Database Cluster via API

To resize a database cluster using the API, you need to provide a value for the size field, which specifies the cluster’s configuration (number of CPUs, amount of RAM, and hard disk space). Use the /v2/databases/options endpoint to get a list of available values.

curl -X PUT \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
-d '{"size":"db-s-4vcpu-8gb", "num_nodes":3, "storage_size_mib":163840}' \
"https://api.digitalocean.com/v2/databases/9cc10173-e9ea-4176-9dbc-a4cee4c4ff30/resize" 

import (
    "context"
    "github.com/digitalocean/godo"
)

func main() {
    pat := "mytoken"

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

    resizeRequest := &godo.DatabaseResizeRequest{
        SizeSlug: "db-s-4vcpu-8gb",
        NumNodes: 3,
        StorageSizeMib: 163840,
    }
}

import os
from pydo import Client

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

req = {
  "size": "db-s-4vcpu-8gb",
  "num_nodes": 3,
  "storage_size_mib": 163840
}

update_resp = client.databases.update_cluster_size(database_cluster_uuid="a7a8bas", body=req)

Resize a Database Cluster Using the Control Panel

To resize a MySQL database cluster, go to the Databases page, and select the cluster you want to resize. On the cluster’s Overview page, click the Settings tab.

In the Cluster configuration section, click Edit, and then select a CPU option and plan.

Then, select your storage size.

In the Autoscale storage section, you can select the option to automatically increase storage when disk utilization on any node in the cluster reaches the specified threshold. The threshold is based on the worst-performing node in the cluster, not the average across nodes.

Click Customize to set a custom threshold and storage increment. The system bills this increase as additional storage.

Autoscaling takes several minutes, depending on the cluster size. It runs without downtime, and you don’t need to take any action.

Once you have selected your new configuration and size, click Save to apply your changes. The provisioning takes several minutes but the total time depends on the size of the cluster.

Your cluster’s state changes from Active to Resizing until the process is done. You can expect no downtime, and you don’t need to take any action.