Usecase Universe

A collective of use cases for DevOps teams

Browse a variety of 200+ predefined templates to automate all your AWS actions

Create Template
Solutions
All Categories

RDS

24 Times Used
22 MAY 2019
Stop RDS DB Instance - Create And Close Jira Ticket
Remediation
Automation
RDS

Create a Jira ticket with DB Instance Identifiers of all Instances that will be stopped, stop the DB Instance, and then close the Jira ticket

RDS DB Instances
Reporting
RDS

Sends report of RDS DB instances CPU Utilization.

RDS Performance Insights
RDS
Operational Excellence
Operational Excellence

To determine if your Amazon RDS database instances are using Performance Insights feature, AWS Relational Database Service (RDS) Performance Insights feature provides you instant visibility into the nature of the workloads on your Amazon RDS databases and helps you find the cause of any performance issue found on those databases.

Aurora Database Instance Accessibility
AWS Best Practices
RDS
AWS Best Practices

Ensure that all the database instances within your Amazon Aurora clusters have the same accessibility (either public or private)

RDS Multi-AZ
Operational Excellence
RDS
Operational Excellence

To determine if your RDS clusters are using Multi-AZ configuration for high availability.

RDS Automated Backups Enabled
RDS
Operational Excellence
Operational Excellence

Ensure that your RDS database instances have automated backups enabled for point-in-time recovery. To back up your database instances, AWS RDS take automatically a full daily snapshot of your data.

Unrestricted DB Security Group
Security
RDS
Security

To determine if your existing RDS DB security groups allow unrestricted access, AWS RDS DB security groups do not allow access from 0.0.0.0/0 in order to reduce the risk of unauthorized access.

RDS Copy Tags to Snapshots
Cost Saving
RDS
Cost Saving

To determine if your RDS instances have Copy Tags to Snapshots feature enabled, Copying your AWS RDS database instance tags to any automated or manual snapshots taken from your instances, allows you to easily set metadata (including access policies) on your snapshots in order to match the parent instances.

Enable deletion protection for RDS Aurora DB clusters
RDS
Security

This workflow enables the deletion protection feature for Aurora DB clusters. Deletion protection prevents any existing or new Aurora database cluster, regardless of its type - provisioned or serverless, from being terminated by a root or IAM user using the AWS Management Console, AWS CLI or AWS API calls, unless the feature is explicitly disabled

IAM Database Authentication for RDS
RDS
Security

This workflow enables IAM database authentication for RDS DB instances in order to use AWS Identity and Access Management (IAM) service to manage database access to your Amazon RDS MySQL and PostgreSQL instances. It provides multiple benefits such as in-transit encryption, centralized.

Idle RDS DB instances
RDS
Cost Saving
Cost Saving

Sends a report if any of the RDS DB instances present in your AWS account is appeared to be idle. Identifying and removing idle resources from your AWS account is best practice to reduce AWS costs.

RDS DB Instance CPUUtilization Report
RDS
Other

Template provides you with the CPUUtilization of RDS DB instance.

DB Instance Generation
RDS
Cost Saving
Cost Saving

Sends a report if RDS databases instances provisioned within your AWS account are using the previous generation of instance classes. Using the latest generation of RDS database instances instead of the previous generation instances has tangible benefits such as better hardware performance.

RDS Reserved DB Instance Lease Expiration In The Next 7 Days
Cost Saving
RDS
Cost Saving

Ensure that your AWS RDS Reserved Instances (RIs) are renewed before expiration date.

RDS Sufficient Backup Retention Period
Reliability
RDS
Reliability

Having a minimum retention period set for RDS database instances will enforce your backup strategy to follow the best practices as specified in the compliance regulations. Retaining point-in-time RDS snapshots for a longer period of time will allow you to handle more efficiently your data restoration process in the event of failure.