Relational Database Clusters

The DNAnexus Relational Database Service provides users with a way to create and manage cloud database clusters (referred to as dbcluster objects on the platform). These databases can then be securely accessed from within DNAnexus jobs/workers.

DNAnexus Relational Database Service is currently available via the application program interface (API) in AWS regions only. Dbcluster API

This page provides an overview of the DNAnexus Relational Database Service

NOTE: A license is required to access the relational database service. Please contact sales@dnanexus.com for more information.

Overview of the Relational Database Service

DNAnexus Relational DB Cluster States

When describing a DNAnexus dbclusters, the status field can be any of the following:

DBCluster status

Details

creating

The database cluster is being created, but not yet available for reading/writing.

available

The database cluster is created and all replicas are available for reading/writing.

stopping

The database cluster is currently being stopped.

stopped

The database cluster is stopped.

starting

The database cluster is restarting from a stopped state, it will be transitioned to available when ready.

terminating

The database cluster is being terminated.

terminated

The database cluster has been terminated and all data deleted.

Connecting to a DB Cluster

DB Clusters are not accessible from outside of the DNAnexus platform. Any access to these databases must occur from within a DNAnexus job. Refer to cloud workstations for one possible way to access a DB Cluster from within a job. Executions, such as app/applet can access a DB Cluster as well.

The parameters needed for connecting to the database are:

  • host Use endpoint as returned from dbcluster-xxxx/describe

  • port 3306 for MySQL Engines or 5432 for Postgresql Engines

  • user root

  • password Use the adminPassword specified when creating the database dbcluster/new

  • ssl-mode required

DBCluster Instance Types

The table below provides all the valid configurations of dxInstanceClass, database engine and versions

DxInstanceClass

Engine + Version Supported

Memory (GB)

# Cores

db_std1_x1

aurora: [5.6.10a] aurora-mysql: [5.7.12]

2

2

db_std1_x2

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.7]

4

2

db_mem1_x2

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.6, 10.7]

16

2

db_mem1_x4

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.6, 10.7]

32

4

db_mem1_x8

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.6, 10.7]

64

8

db_mem1_x16

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.6, 10.7]

128

16

db_mem1_x32

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [9.6.8, 9.6.9, 9.6.11, 9.6.12, 10.4, 10.5, 10.6, 10.7]

244

16

db_mem1_x48

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.6, 10.7]

384

48

db_mem1_x64

aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [9.6.8, 9.6.9, 9.6.11, 9.6.12, 10.4, 10.5, 10.6, 10.7]

488

64

db_mem1_x96

aurora-postgresql: [10.6, 10.7]

768

96