Dgraph Administration

Each Dgraph Alpha exposes various administrative (admin) endpoints both over HTTP and GraphQL, for example endpoints to export data and to perform a clean shutdown. All such admin endpoints are protected by three layers of authentication:

1. IP White-listing (use --whitelist flag in alpha to whitelist IPs other than localhost).
2. Poor-man’s auth, if alpha is started with the --auth_token flag (means you will need to pass the auth_token as X-Dgraph-AuthToken header while making the HTTP request).
3. Guardian-only access, if ACL is enabled (means you need to pass the ACL-JWT of a Guardian user using the X-Dgraph-AccessToken header while making the HTTP request).

An admin endpoint is any HTTP endpoint which provides admin functionality. Admin endpoints usually start with the /admin path. The current list of admin endpoints includes the following:

• /admin
• /admin/backup
• /admin/config/lru_mb
• /admin/draining
• /admin/export
• /admin/shutdown
• /admin/schema
• /alter
• /login

There are a few exceptions to the general rule described above:

• /login: This endpoint logs-in an ACL user, and provides them with a JWT. Only IP Whitelisting and Poor-man’s auth checks are performed for this endpoint.
• /admin: This endpoint provides GraphQL queries/mutations corresponding to the HTTP admin endpoints. All of the queries/mutations on /admin have all three layers of authentication, except for login (mutation), which has the same behavior as the above HTTP /login endpoint.

Whitelisting Admin Operations

By default, admin operations can only be initiated from the machine on which the Dgraph Alpha runs.

You can use the --whitelist option to specify a comma-separated whitelist of IP addresses, IP ranges, CIDR ranges, or hostnames for hosts from which admin operations can be initiated.

IP Address

dgraph alpha --whitelist 127.0.0.1 ...

This would allow admin operations from hosts with IP 127.0.0.1 (i.e., localhost only).

IP Range

dgraph alpha --whitelist 172.17.0.0:172.20.0.0,192.168.1.1 ...

This would allow admin operations from hosts with IP between 172.17.0.0 and 172.20.0.0 along with the server which has IP address as 192.168.1.1.

CIDR Range

dgraph alpha --whitelist 172.17.0.0/16,172.18.0.0/15,172.20.0.0/32,192.168.1.1/32 ...

This would allow admin operations from hosts that matches the CIDR range 172.17.0.0/16, 172.18.0.0/15, 172.20.0.0/32, or 192.168.1.1/32 (the same range as the IP Range example).

You can set whitelist IP to 0.0.0.0/0 to whitelist all IPs.

Hostname

dgraph alpha --whitelist admin-bastion,host.docker.internal ...

This would allow admin operations from hosts with hostnames admin-bastion and host.docker.internal.

Restricting Mutation Operations

By default, you can perform mutation operations for any predicate. If the predicate in mutation doesn’t exist in the schema, the predicate gets added to the schema with an appropriate Dgraph Type.

You can use --mutations disallow to disable all mutations, which is set to allow by default.

dgraph alpha --mutations disallow

Enforce a strict schema by setting --mutations strict. This mode allows mutations only on predicates already in the schema. Before performing a mutation on a predicate that doesn’t exist in the schema, you need to perform an alter operation with that predicate and its schema type.

dgraph alpha --mutations strict

Securing Alter Operations

Clients can use alter operations to apply schema updates and drop particular or all predicates from the database. By default, all clients are allowed to perform alter operations. You can configure Dgraph to only allow alter operations when the client provides a specific token. You can use this “Simple ACL” token to prevent clients from making unintended or accidental schema updates or predicate drops.

You can specify the auth token with the --auth_token option for each Dgraph Alpha in the cluster. Clients must include the same auth token to make alter requests.

$ dgraph alpha --auth_token=<authtokenstring>

$ curl -s localhost:8080/alter -d '{ "drop_all": true }'
# Permission denied. No token provided.

$ curl -s -H 'X-Dgraph-AuthToken: <wrongsecret>' localhost:8180/alter -d '{ "drop_all": true }'
# Permission denied. Incorrect token.

$ curl -H 'X-Dgraph-AuthToken: <authtokenstring>' localhost:8180/alter -d '{ "drop_all": true }'
# Success. Token matches.

Exporting Database

An export of all nodes is started by locally executing the following GraphQL mutation on the /admin endpoint of an Alpha node (e.g. localhost:8080/admin) using any compatible client like Insomnia, GraphQL Playground or GraphiQL.

mutation {
  export(input: {}) {
    response {
      message
      code
    }
  }
}

This triggers an export for all Alpha groups of the cluster. The data is exported from the following Dgraph instances:

1. For the Alpha instance that receives the GET request, the group’s export data is stored with this Alpha.
2. For every other group, its group’s export data is stored with the Alpha leader of that group.

It is up to the user to retrieve the right export files from the Alphas in the cluster. Dgraph does not copy all files to the Alpha that initiated the export. The user must also ensure that there is sufficient space on disk to store the export.

Configuring Dgraph Alpha server nodes

Each Dgraph Alpha leader for a group writes output as a gzipped file to the export directory specified via the --export flag (defaults to a directory called "export"). If any of the groups fail, the entire export process is considered failed and an error is returned.

As an example of configuring export, you can run this:

docker run --detach --rm --name dgraph-standalone \
  --publish 8080:8080 \
  --publish 8000:8000 \
  --volume ~/exports:/dgraph/myexports \
  --env "DGRAPH_ALPHA_EXPORT=/dgraph/myexports" \
  dgraph/standalone:master

Export data format

By default, Dgraph exports data in RDF format. You can explicitly set the output format with the format field. For example:

mutation {
  export(input: { format: "rdf" }) {
    response {
      message
      code
    }
  }
}

You can specify a different output format using the format field. For example:

mutation {
  export(input: { format: "json" }) {
    response {
      message
      code
    }
  }
}

Currently, rdf and json are the only formats supported.

Exporting to NFS or a file path

You can override the default folder path by adding the destination input field to the directory where you want to export data in the GraphQL mutation request, as follows:

mutation {
  export(input: {
    format: "rdf"
    destination: "<absolute-path-to-your-export-dir>"
  }) {
    response {
      message
      code
    }
  }
}

Exporting to an object store

You can export to an S3 or MinIO object store by specifying a URL in the destination input field.

Exporting to S3

mutation {
  export(input: {
    destination: "s3://s3.<region>.amazonaws.com/<bucket-name>"
    accessKey: "<aws-access-key-id>"
    secretKey: "<aws-secret-access-key>"
  }) {
    response {
      message
      code
    }
  }
}

Exporting to MinIO

mutation {
  export(input: {
    destination: "minio://<address>:9000/<bucket-name>"
    accessKey: "<minio-access-key>"
    secretKey: "<minio-secret-key>"
  }) {
    response {
      message
      code
    }
  }
}

Exporting to a MinIO Gateway

You can use MinIO as a gateway to other object stores, such as Azure Blob Storage or Google Cloud Storage. You can use the above MinIO GraphQL mutation with MinIO configured as a gateway.

Azure Blob Storage

You can use Azure Blob Storage through the MinIO Azure Gateway. You need to configure a storage account and a Blob container to organize the blobs. The name of the blob container is what you use for <bucket-name> when specifying the destination in the GraphQL mutation.

For MinIO configuration, you will need to retrieve storage accounts keys. The MinIO Azure Gateway will use MINIO_ACCESS_KEY and MINIO_SECRET_KEY to correspond to Azure Storage Account AccountName and AccountKey.

Once you have the AccountName and AccountKey, you can access Azure Blob Storage locally using one of these methods:

• Using MinIO Azure Gateway with the MinIO Binary

  export MINIO_ACCESS_KEY="<AccountName>"
  export MINIO_SECRET_KEY="<AccountKey>"
  minio gateway azure
  

• Using MinIO Azure Gateway with Docker

  docker run --detach --rm --name gateway \
   --publish 9000:9000 \
   --env MINIO_ACCESS_KEY="<AccountName>" \
   --env MINIO_SECRET_KEY="<AccountKey>" \
   minio/minio gateway azure
  

• Using MinIO Azure Gateway with the MinIO Helm chart for Kubernetes:

  helm repo add minio https://helm.min.io/
  helm install my-gateway minio/minio \
    --set accessKey="<AccountName>",secretKey="<AccountKey>" \
    --set azuregateway.enabled=true
  

Google Cloud Storage

You can use Google Cloud Storage through the MinIO GCS Gateway. You will need to create storage buckets, create a Service Account key for GCS and get a credentials file. See Create a Service Account key for further information.

Once you have a credentials.json, you can access GCS locally using one of these methods:

• Using MinIO GCS Gateway with the MinIO Binary

  export GOOGLE_APPLICATION_CREDENTIALS="/path/to/credentials.json"
  export MINIO_ACCESS_KEY="<minio-access-key>"
  export MINIO_SECRET_KEY="<minio-secret-key>"
  minio gateway gcs "<project-id>"
  

• Using MinIO GCS Gateway with Docker

  docker run --detach --rm --name gateway \
    --publish 9000:9000  \
    --volume "</path/to/credentials.json>":/credentials.json \
    --env GOOGLE_APPLICATION_CREDENTIALS=/credentials.json \
    --env MINIO_ACCESS_KEY="<minio-access-key>" \
    --env MINIO_SECRET_KEY="<minio-secret-key>" \
    minio/minio gateway gcs "<project-id>"
  

• Using MinIO GCS Gateway with the MinIO Helm chart for Kubernetes:

  ## create MinIO Helm config
  cat <<-EOF > myvalues.yaml
  accessKey: <minio-access-key>
  secretKey: <minio-secret-key>
  
  gcsgateway:
    enabled: true
    projectId: <project-id>
    gcsKeyJson: |
  $(IFS='\n'; while read -r LINE; do printf '    %s\n' "$LINE"; done < "</path/to/credentials.json>")
  EOF
  
  ## deploy MinIO GCS Gateway
  helm repo add minio https://helm.min.io/
  helm install my-gateway minio/minio \
    --values myvalues.yaml
  

Disabling HTTPS for exports to S3 and Minio

By default, Dgraph assumes the destination bucket is using HTTPS. If that is not the case, the export will fail. To export to a bucket using HTTP (insecure), set the query parameter secure=false with the destination endpoint in the destination field:

mutation {
  export(input: {
    destination: "minio://<address>:9000/<bucket-name>?secure=false"
    accessKey: "<minio-access-key>"
    secretKey: "<minio-secret-key>"
  }) {
    response {
      message
      code
    }
  }
}

Using anonymous credentials

If exporting to S3 or MinIO where credentials are not required, you can set anonymous to true.

mutation {
  export(input: {
    destination: "s3://s3.<region>.amazonaws.com/<bucket-name>"
    anonymous: true
  }) {
    response {
      message
      code
    }
  }
}

Encrypting exports

Export is available wherever an Alpha is running. To encrypt an export, the Alpha must be configured with the encryption_key_file.

Using curl to trigger an export

This is an example of how you can use curl to trigger an export.

1. Create GraphQL file for the desired mutation:

   cat <<-EOF > export.graphql
   mutation {
     export(input: {
       destination: "s3://s3.<region>.amazonaws.com/<bucket-name>"
       accessKey: "<aws-access-key-id>"
       secretKey: "<aws-secret-access-key>"
     }) {
       response {
         message
         code
       }
     }
   }
   EOF
   

2. Trigger an export with curl

   curl http://localhost:8080/admin --silent --request POST \
     --header "Content-Type: application/graphql" \
     --upload-file export.graphql
   

Shutting Down Database

A clean exit of a single Dgraph node is initiated by running the following GraphQL mutation on /admin endpoint.

mutation {
  shutdown {
    response {
      message
      code
    }
  }
}

This stops the Alpha on which the command is executed and not the entire cluster.

Deleting database

Individual triples, patterns of triples and predicates can be deleted as described in the DQL docs.

To drop all data, you could send a DropAll request via /alter endpoint.

Alternatively, you could:

• Shutdown Dgraph and wait for all writes to complete,
• Delete (maybe do an export first) the p and w directories, then
• Restart Dgraph.

Upgrading Database

Doing periodic exports is always a good idea. This is particularly useful if you wish to upgrade Dgraph or reconfigure the sharding of a cluster. The following are the right steps to safely export and restart.

1. Start an export
2. Ensure it is successful
3. Shutdown Dgraph and wait for all writes to complete
4. Start a new Dgraph cluster using new data directories (this can be done by passing empty directories to the options -p and -w for Alphas and -w for Zeros)
5. Reload the data via bulk loader
6. Verify the correctness of the new Dgraph cluster. If all looks good, you can delete the old directories (export serves as an insurance)

These steps are necessary because Dgraph’s underlying data format could have changed, and reloading the export avoids encoding incompatibilities.

Blue-green deployment is a common approach to minimize downtime during the upgrade process. This approach involves switching your application to read-only mode. To make sure that no mutations are executed during the maintenance window you can do a rolling restart of all your Alpha using the option --mutations disallow when you restart the Alphas. This will ensure the cluster is in read-only mode.

At this point your application can still read from the old cluster and you can perform the steps 4. and 5. described above. When the new cluster (that uses the upgraded version of Dgraph) is up and running, you can point your application to it, and shutdown the old cluster.

Upgrading from v1.2.2 to v20.03.0 for Enterprise Customers

1. Use binary backup to export data from old cluster
2. Ensure it is successful
3. Shutdown Dgraph and wait for all writes to complete
4. Upgrade dgraph binary to v20.03.0
5. Restore from the backups using upgraded dgraph binary
6. Start a new Dgraph cluster using the restored data directories
7. Upgrade ACL data using the following command:

dgraph upgrade --acl -a localhost:9080 -u groot -p password

Upgrading from v20.03.0 to v20.07.0 for Enterprise Customers

1. Use binary backup to export data from old cluster

2. Ensure it is successful

3. Shutdown Dgraph and wait for all writes to complete

4. Upgrade dgraph binary to v20.07.0

5. Restore from the backups using upgraded dgraph binary

6. Start a new Dgraph cluster using the restored data directories

7. Upgrade ACL data using the following command:

   dgraph upgrade --acl -a localhost:9080 -u groot -p password -f v20.03.0 -t v20.07.0
   

   This is required because previously the type-names User, Group and Rule were used by ACL. They have now been renamed as dgraph.type.User, dgraph.type.Group and dgraph.type.Rule, to keep them in dgraph’s internal namespace. This upgrade just changes the type-names for the ACL nodes to the new type-names.

   You can use --dry-run option in dgraph upgrade command to see a dry run of what the upgrade command will do.

8. If you have types or predicates in your schema whose names start with dgraph., then you would need to manually alter schema to change their names to something else which isn’t prefixed with dgraph., and also do mutations to change the value of dgraph.type edge to the new type name and copy data from old predicate name to new predicate name for all the nodes which are affected. Then, you can drop the old types and predicates from DB.

Post Installation

Now that Dgraph is up and running, to understand how to add and query data to Dgraph, follow Query Language Spec. Also, have a look at Frequently asked questions.