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 statusDetails

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

DxInstanceClassEngine + Version SupportedMemory (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: ["12.9", "13.9", "14.6"]

4

2

db_mem1_x2

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: [ "12.9", "13.9", "14.6"]

16

2

db_mem1_x4

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["12.9", "13.9", "14.6"]

32

4

db_mem1_x8

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["12.9", "13.9", "14.6"]

64

8

db_mem1_x16

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: [ "12.9", "13.9", "14.6"]

128

16

db_mem1_x32

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["12.9", "13.9", "14.6"]

244

32

db_mem1_x48

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["12.9", "13.9", "14.6"]

384

48

db_mem1_x64

aurora-mysql: ["8.0.mysql_aurora.3.04.1"], aurora-postgresql: ["12.9", "13.9", "14.6"]

488

64

db_mem1_x96

aurora-postgresql: ["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.

Restriction on Transfers of Projects Containing DBClusters

If a project contains a DBCluster, its ownership cannot be changed. A PermissionDenied error will be returned on attempting to change the billTo of such a project.

Last updated