Relational Database Clusters
Last updated
Was this helpful?
Last updated
Was this helpful?
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 for details.
When describing a DNAnexus dbclusters, the status field can be any of the following:
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.
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 for one possible way to access a DB Cluster from within a job. Executions such as can access a DB Cluster as well.
The parameters needed for connecting to the database are:
port
3306
for MySQL Engines or 5432
for Postgresql Engines
user
root
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)
The table below provides all the valid configurations of dxInstanceClass, database engine and versions
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
host
Use endpoint
as returned from
password
Use the adminPassword
specified when creating the database
* - db_std1 instances may incur CPU Burst charges similar to AWS T3 Db instances described in . Regular hourly charges for this instance type are based on 1 core, CPU Burst charges are based on 2 cores.
If a project contains a , its ownership cannot be changed. on attempting to change the billTo
of such a project.