Database

Database nodes provision relational SQL databases. The following engines are supported:

Databases are fully-managed, including automatic backups, multi-availability-zone failover, and automatic minor version updates.

Once a Database has been provisioned its DNS name can be found in the deployment status info pane for the node. Clients can connect to the Database at this address on the server’s well-known port.

Settings

Name

A label used for the node in the canvas.

Engine

The type of database: PostgreSQL, MariaDB, or MySQL.

Version

The version of the database. The database may undergo minor upgrades automatically in response to security or bug fixes that are backwards compatible.

Databases may also be upgraded by modifying this property. When an upgrade is performed the underlying data is migrated, but there may be backwards incompatible changes. Be sure to test migrations before deploying version upgrades to production data.

Storage Size

The size of the disk volume for the Database server, including operating system usage.

Backup Retention Period

Databases can be automatically backed up daily. This property specifies the length of time to keep backup snapshots. Snapshots older than this period are automatically deleted.

To disable automatic backups, set this property to 0.

Warning: Deleting a Database node will delete all automatically generated snapshots. To retain a snapshot of the Database contents after deletion create a manual snapshot.

Instance Type

The AWS Instance Type of the Database server.

Initial Root Password

The initial root user password for the server. Be sure to change this to a new, secure password as soon as possible. The password set here is not stored securely.

Failover Instance

Whether to provision a second, backup instance in a separate availability zone. If the primary Database instance fails, the failover instance will be promoted to primary and the DNS record for the database server will be updated.

Stackery Port Data

When connecting a wire between the output of a Function node to the input of a Database node, the STACKERY_PORTS environment variable for the Function node will contain the following information in JSON form:

Property Type Description
type string The type of the connected resource. Always set to database.
id string The Stackery Database node’s ID. Example: abcd1234.
name string The Stackery Database node’s name. Example: Users.
databaseArn string The AWS ARN of the RDS Database Instance. Example: arn:aws:rds:us-east-1:0123456789:db:stackery-9834723-4830492838-df8fs87.
address string The DNS name of the database instance. Example: stackery-9834723-4830492838-df8fs87.cd78f9d8s.us-east-1.rds.amazonaws.com.
port number The port of the primary node of the cluster. Example: 3306.


See Function Output Port Connections for more details on the STACKERY_PORTS environment variable.

Referenceable Properties

The following properties may be referenced by Function, Docker Service, and Docker Task nodes:

Property Value Example
id Cloud Service Identifier arn:aws:rds:us-east-1:0123456789012:db:pd82hdj3m429
address Address pd82hdj3m429.sdf87f6sdf76.us-east-1.rds.amazonaws.com
port Port 3306

Try Stackery For Free

Gain control and visibility of your serverless operations from architecture design to application deployment and infrastructure monitoring.