Comment on page
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.
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. |
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:
port
3306
for MySQL Engines or5432
for Postgresql Enginesuser
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
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 |
Last modified 2mo ago