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: ["8.0.mysql_aurora.3.04.1"],	2	2
db_std1_x2 (*)	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	4	2
db_mem1_x2	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	16	2
db_mem1_x4	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	32	4
db_mem1_x8	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	64	8
db_mem1_x16	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	128	16
db_mem1_x32	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	244	32
db_mem1_x48	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	384	48
db_mem1_x64	aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	488	64
db_mem1_x96	aurora-postgresql: ["11.9", "12.9", "13.9", "14.6"]	768	96

* - db_std1 instances may incur CPU Burst charges similar to AWS T3 Db instances described in this AWS documentation. db_std1_x1 has 2 cores. Regular hourly charges for this instance type are based on 1 core, CPU Burst charges are based on 2 cores.