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. See DBCluster API page for details.
This page provides an overview of the DNAnexus Relational Database Service
NOTE: A license is required to access the relational database service. Please contact [email protected] 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.11, 10.12, 10.13, 10.14]
4
2
db_mem1_x2
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]
16
2
db_mem1_x4
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]
32
4
db_mem1_x8
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]
64
8
db_mem1_x16
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]
128
16
db_mem1_x32
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [9.6.16, 9.6.17, 9.6.18, 9.6.19, 10.11, 10.12, 10.13, 10.14]
244
16
db_mem1_x48
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]
384
48
db_mem1_x64
aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [9.6.16, 9.6.17, 9.6.18, 9.6.19, 10.11, 10.12, 10.13, 10.14]
488
64
db_mem1_x96
aurora-postgresql: [10.11, 10.12, 10.13, 10.14]
768
96

Archiving Files

Uploading and Downloading Files

Last updated 6 months ago

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.

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.11, 10.12, 10.13, 10.14]	4	2
db_mem1_x2	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]	16	2
db_mem1_x4	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]	32	4
db_mem1_x8	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]	64	8
db_mem1_x16	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]	128	16
db_mem1_x32	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [9.6.16, 9.6.17, 9.6.18, 9.6.19, 10.11, 10.12, 10.13, 10.14]	244	16
db_mem1_x48	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [10.11, 10.12, 10.13, 10.14]	384	48
db_mem1_x64	aurora: [5.6.10a] aurora-mysql: [5.7.12] aurora-postgresql: [9.6.16, 9.6.17, 9.6.18, 9.6.19, 10.11, 10.12, 10.13, 10.14]	488	64
db_mem1_x96	aurora-postgresql: [10.11, 10.12, 10.13, 10.14]	768	96