How to Add Read-Only Nodes to MySQL Database Clusters

To create a read-only node via the command-line, follow these steps:

1. Install doctl, the DigitalOcean command-line tool.

2. Create a personal access token, and save it for use with doctl.

3. Use the token to grant doctl access to your DigitalOcean account.

                 doctl auth init
               

4. Finally, create a read-only node with doctl databases replica create. The basic usage looks like this, but you'll want to read the usage docs for more details:

                 doctl databases replica create <database-id> <replica-name> [flags]
               

To create a read-only node using the DigitalOcean API, follow these steps:

1. Create a personal access token, and save it for use with the API.

2. Send a POST request to https://api.digitalocean.com/v2/databases/{database_cluster_uuid}/replicas

   cURL

   To create a read-only node with cURL, call:

   
                   curl -X POST \
     -H "Content-Type: application/json" \
     -H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
     -d '{"name":"read-nyc3-01", "region":"nyc3", "size": "db-s-2vcpu-4gb"}' \
     "https://api.digitalocean.com/v2/databases/9cc10173-e9ea-4176-9dbc-a4cee4c4ff30/replicas"

   Go

   Go developers can use Godo, the official DigitalOcean V2 API client for Go. To create a read-only node with Godo, use the following code:

   
                   import (
       "context"
       "os"
   
       "github.com/digitalocean/godo"
   )
   
   func main() {
       token := os.Getenv("DIGITALOCEAN_TOKEN")
   
       client := godo.NewFromToken(token)
       ctx := context.TODO()
   
       replicaRequest := &godo.DatabaseCreateReplicaRequest{
   
           Name:   "read-nyc3-01",
           Region: "nyc3",
           Size:   "db-s-2vcpu-4gb",
       }
   
       replica, _, err := client.Databases.CreateReplica(ctx, "9cc10173-e9ea-4176-9dbc-a4cee4c4ff30", replicaRequest)
   }

   Python

   
                   import os
   from pydo import Client
   
   client = Client(token=os.environ.get("DIGITALOCEAN_TOKEN"))
   
   create_req = {
     "name": "read-nyc3-01",
     "region": "nyc3",
     "size": "db-s-2vcpu-4gb"
   }
   
   create_resp = client.databases.create_replica(database_cluster_uuid="9cc10173", body=create_req)

To promote a read-only node via the command-line, follow these steps:

1. Install doctl, the DigitalOcean command-line tool.

2. Create a personal access token, and save it for use with doctl.

3. Use the token to grant doctl access to your DigitalOcean account.

                 doctl auth init
               

4. Finally, promote a read-only node with doctl databases replica promote. The basic usage looks like this, but you'll want to read the usage docs for more details:

                 doctl databases replica promote <database-id> <replica-name> [flags]
               

To promote a read-only node using the DigitalOcean API, follow these steps:

1. Create a personal access token, and save it for use with the API.

2. Send a PUT request to https://api.digitalocean.com/v2/databases/{database_cluster_uuid}/replicas/{replica_name}/promote

   cURL

   To promote a read-only node with cURL, call:

   
                   curl -X PUT \
     -H "Content-Type: application/json" \
     -H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
     "https://api.digitalocean.com/v2/databases/9cc10173-e9ea-4176-9dbc-a4cee4c4ff30/replicas/read-nyc3-01/promote"

   Go

   Go developers can use Godo, the official DigitalOcean V2 API client for Go. To promote a read-only node with Godo, use the following code:

   
                   import (
       "context"
       "os"
   
       "github.com/digitalocean/godo"
   )
   
   func main() {
       token := os.Getenv("DIGITALOCEAN_TOKEN")
   
       client := godo.NewFromToken(token)
       ctx := context.TODO()
   
       _, err := client.Databases.PromoteReplicaToPrimary(ctx, "9cc10173-e9ea-4176-9dbc-a4cee4c4ff30", "read-nyc3-01")
   }

   Python

   
                   import os
   from pydo import Client
   
   client = Client(token=os.environ.get("DIGITALOCEAN_TOKEN"))
   
   resp = client.databases.promote_replica(database_cluster_uuid="a7a8bas", replica_name="ba8ab22")