Relational Database Clusters

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.
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 this page on cloud workstations for one possible way to access a DB Cluster from within a job. Executions such as app/applets 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​
For MySQL: ssl-mode 'required'
For Postgresql: sslmode 'require' Note: For connecting and verifying certs: (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html)
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-mysql: [5.7.mysql_aurora.2.07.8]
2
2
db_std1_x2
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
4
2
db_mem1_x2
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
16
2
db_mem1_x4
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
32
4
db_mem1_x8
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
64
8
db_mem1_x16
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
128
16
db_mem1_x32
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
244
16
db_mem1_x48
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
384
48
db_mem1_x64
aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]
488
64
db_mem1_x96
aurora-postgresql: [11.16, 12.9]
768
96

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-mysql: [5.7.mysql_aurora.2.07.8]	2	2
db_std1_x2	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	4	2
db_mem1_x2	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	16	2
db_mem1_x4	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	32	4
db_mem1_x8	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	64	8
db_mem1_x16	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	128	16
db_mem1_x32	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	244	16
db_mem1_x48	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	384	48
db_mem1_x64	aurora-mysql: [5.7.mysql_aurora.2.07.8] aurora-postgresql: [11.16, 12.9]	488	64
db_mem1_x96	aurora-postgresql: [11.16, 12.9]	768	96

Archiving Files

Uploading and Downloading Files

Last modified 4mo ago