doctl Verified current stable Not installed? Cloud Infrastructure

Doctl / Create Database Cluster

Create Database Cluster

Creates a new database cluster within the DigitalOcean infrastructure.

Terminal

doctl d c <database_name>

doctl d c <database_name>

#!/bin/bash

# Create Database Cluster
doctl {{[d|databases]}} {{[c|create]}} {{database_name}}

import subprocess

# Create Database Cluster
# Make sure to replace <placeholders> with actual values
def run_command():
    cmd = [
        "doctl",
        "d",
        "c",
        "<database_name>"
    ]
    
    try:
        print(f"Executing: {' '.join(cmd)}")
        subprocess.run(cmd, check=True)
    except subprocess.CalledProcessError as e:
        print(f"Error: {e}")
    except FileNotFoundError:
        print("Error: doctl not found. Please install it first.")

if __name__ == "__main__":
    run_command()

When To Use

When provisioning a fresh database environment for a new application or service.

Pro Tip

Consider specifying backups and high-availability settings initially; these cannot be altered post-creation.

Command Builder

Tune the command before you copy it

Back to syntax

Generated Command

doctl d c <database_name>

Terminal Output

Expected runtime feedback

Simulated preview

Output

$ doctl databases create my-database-cluster
Creating database cluster... Done!

Cluster Details:
+-------------------+---------------------+
| Name              | my-database-cluster |
| Engine            | postgres            |
| Version           | 13                  |
| Size              | db-s-1vcpu-1gb     |
| Region            | nyc1               |
| Status            | active              |
+-------------------+---------------------+

Anatomy of Output

Understanding the result

Creating new database cluster: <database_name> in <region>... Output Status

Indicates the initiation of the creation process.

Successfully created database cluster: <database_name>. Completion Status

Confirms successful database provisioning.

run 'doctl [[d|databases]] [[g|get]] <database_name>' for details. Next Steps

Suggests a command for retrieving detailed information on the new cluster.

Troubleshooting

Common pitfalls

Error: Database cluster <database_name> already exists

Solution: Choose a different name for the new database or check existing clusters.

Error: Invalid region specified

Solution: Refer to the available regions and ensure the selected region is correct.

Error: Insufficient resources to create database in <region>

Solution: Check the resource limits and try a different region or settings.

Command Breakdown

What each part is doing

doctl: Base Command; The executable that performs this operation. Here it runs Doctl before the shell applies any redirect operators.
d: d|databases; The value supplied for d|databases.
c: c|create; The value supplied for c|create.
<database_name>: database name; The value supplied for database name.

How To Run

Execution path

Step 1
Run `doctl databases create my-database-cluster` to initiate cluster creation.
Step 2
Verify the cluster status with `doctl databases list`.

Alternative Approaches

Comparable commands in other tools

Alternative cloud infrastructure tools for the same job.

Gcloud / Ssh Virtual Machine Instance gcloud compute ssh <user>@<instance> Flyctl / View Status Of Specific Application flyctl status --app <app_name> Aws / Delete Eks Cluster 1608 aws eks delete-cluster --name <cluster_name> Gh / Create Codespace Github Interactively gh cs create Cradle / Submit Elasticsearch Schema cradle elastic map