Links
Comment on page

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.
The Relational Database Service is currently available via the application program interface (API) in AWS regions only. See DBClusters API page for details.
A license is required to access the Relational Database Service. Contact DNAnexus Sales 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.10]
2
2
db_std1_x2
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
4
2
db_mem1_x2
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
16
2
db_mem1_x4
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
32
4
db_mem1_x8
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
64
8
db_mem1_x16
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
128
16
db_mem1_x32
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
244
32
db_mem1_x48
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
384
48
db_mem1_x64
aurora-mysql: [5.7.mysql_aurora.2.07.10] aurora-postgresql: [11.16, 12.9]
488
64
db_mem1_x96
aurora-postgresql: [11.16, 12.9]
768
96