pydo.databases

DigitalOcean’s managed database service simplifies the creation and management of highly available database clusters.

Currently, it offers support for PostgreSQL, Redis, MySQL, MongoDB, and OpenSearch.

By sending requests to the /v2/databases endpoint, you can list, create, or delete database clusters as well as scale the size of a cluster, add or remove read-only replicas, and manage other configuration details.

Database clusters may be deployed in a multi-node, high-availability configuration. If your machine type is above the basic nodes, your node plan is above the smallest option, or you are running MongoDB, you may additionally include up to two standby nodes in your cluster.

The size of individual nodes in a database cluster is represented by a human-readable slug, which is used in some of the following requests. Each slug denotes the node’s identifier, CPU count, and amount of RAM, in that order.

For a list of currently available database slugs and options, use the /v2/databases/options endpoint or use the doctl databases options command.

Add a New Connection Pool (PostgreSQL)
Add a Database User
Add a New Database
Create a New Database Cluster
Create Topic for a Kafka Cluster
Create Logsink for a Database Cluster
Create a Read-only Replica
Delete a Connection Pool (PostgreSQL)
Delete Topic for a Kafka Cluster
Delete Logsink for a Database Cluster
Stop an Online Migration
Delete Index for OpenSearch Cluster
Remove a Database User
Delete a Database
Destroy a Database Cluster
Destroy a Read-only Replica
Retrieve the Public Certificate
Retrieve Database Clusters’ Metrics Endpoint Credentials
Retrieve an Existing Database Cluster
Retrieve an Existing Database Cluster Configuration
Retrieve Existing Connection Pool (PostgreSQL)
Retrieve the Eviction Policy for a Redis Cluster
Get Topic for a Kafka Cluster
Get Logsink for a Database Cluster
Retrieve the Status of an Online Migration
Retrieve an Existing Read-only Replica
Retrieve the SQL Modes for a MySQL Cluster
Retrieve an Existing Database User
Retrieve an Existing Database
Start Database Maintenance
List Backups for a Database Cluster
List All Database Clusters
List Connection Pools (PostgreSQL)
List all Events Logs
List Firewall Rules (Trusted Sources) for a Database Cluster
List Topics for a Kafka Cluster
List Logsinks for a Database Cluster
List Indexes for a OpenSearch Cluster
List Database Options
List All Read-only Replicas
List all Database Users
List All Databases
Update the Database Configuration for an Existing Database
Promote a Read-only Replica to become a Primary Cluster
Reset a Database User’s Password or Authentication Method
Update Database Clusters’ Metrics Endpoint Credentials
Resize a Database Cluster
Update Connection Pools (PostgreSQL)
Configure the Eviction Policy for a Redis Cluster
Update Firewall Rules (Trusted Sources) for a Database
Update Topic for a Kafka Cluster
Update Logsink for a Database Cluster
Configure a Database Cluster’s Maintenance Window
Upgrade Major Version for a Database
Start an Online Migration
Migrate a Database Cluster to a New Region
Update SQL Mode for a Cluster
Update a Database User