A Database provisions relational SQL database instances with Amazon Relational Database Service (RDS). Amazon RDS is a database engine that makes it easier to set up, operate, and scale relational databases in the cloud.
Key Features of Amazon RDS include:
- AWS manages common database administration tasks like security, backups, and softwares updates
- Ability to choose on-demand or reserved database instances to fit billing requirements
- Use of familiar database engines like PostgreSQL, MariaDB, and MySQL
- Additional security and monitoring through multiple Amazon RDS interfaces
AWS will take care of most of the administration and setup but there are AWS resource settings that you get to determine, like the retention period of your database backups, the instance type to hold your database, and a root user password for the server. What's left for you to define are the database settings specific to your application like the choice of engine, the engine version, and storage size. Database s currently supports PostgreSQL, MariaDB, and MySQL database engines.
Once a Database has been provisioned its DNS name can be found in the Current Deployment info pane for the resource. Clients can connect to the Database at this address on the server's well-known port.
Service discovery wires (dashed line) provide compute resources (Function, Edge Function, Docker Task) with the permissions and environment variables required to perform actions using cloud resources within the stack. This resource is on the receiving end of a service discovery wire originating from compute resources.
The following compute resources can use a service discovery wire to access a Database resource:
- Docker Tasks
Human readable name for this resource that is displayed on the Stackery Dashboard and Stackery CLI output.
You can use following SQL database engines:
The version number of the database engine that the DB instance uses.
The amount of storage allocated to your database up to 16TB. Amazon RDS utilizes Amazon Elastic Block Store (EBS) volumes for database instance storage.
Backup Retention Period
The length of time in days to keep automatic daily storage snapshots. Snapshots older than this period are automatically deleted. To disable automatic database backups set this property to 0.
The AWS Instance Class Type of the DB instance.
The initial root user password for the server. It is recommended to reference a value in a Stackery environment configuration to avoid storing this value in your source code repository.
Automatically creates a standby replica of your database in a different availability zone. Your application with automatically failover to the standby database in the event of an instance failure. Read more about the benefits of enabling this feature and the failover process in the AWS docs.
When connected by a service discovery wire (dashed wire), a Function or Docker Task will add the following IAM statement/policy to its role and gain permission to access this resource.
No Permissions Added
Access to your database is managed through the database engine's native authentication and authorization system. No additional IAM permissions are required.
When connected by a service discovery wire (dashed wire), a Function or Docker Task will automatically populate and reference the following environment variables in order to interact with this resource.
The Logical ID of the Database instance resource.
The DNS name of the database instance.
The port of the primary instance of the cluster.
The Amazon Resource Name of the RDS Database Instance.
Metrics & Logs
Double clicking a resource while viewing your stack's current deployment gives you access to your pre-configured resource properties, and the following metrics and logs.
- CPU Utilization
- Available Memory
- Swap Usage
- Available Storage
- IO Operations
- IO Latency
- IO Throughput
- IO Queue Length
- Network Throughput
- Database Connections
Related AWS Documentation
AWS Documentation: AWS::RDS::DBInstance