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
RDS DB Instances
Reporting
RDS

Sends report of RDS DB instances CPU Utilization.

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.

RDS Performance Insights
Performance-efficiency
RDS
Reliability

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.

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.

Public RDS Instances Weekly
RDS
Security
Security

This template generates a weekly report of public RDS Instances, establishing AWS security of your sensitive data.

RDS Desired Instance Type
RDS
Security
Cost Saving
Security
Cost Saving

Send report of RDS instances provisioned in your AWS account, which does not have the desired instance type established by your organization. Restricting the type of Amazon RDS instances will help you address internal compliance requirements and also helps to save some extra cost.

RDS DB Instances Multi AZ Alteration
Operational Excellence
AWS Best Practices
Operational Excellence
RDS

This workflow enables the MultiAZ for RDS DB instances and then after a delay of 1 hour it forces it to fail over. Again after 1 hour of delay it disables the MultiAZ feature for the RDS DB instances and then sends a report

RDS instances Pending Purchases
RDS
Cost Saving
Cost Saving

Indentify any pending Reserved RDS instances and a send a report of it. Using RDS Reserved Instances over On-Demand Instances can save up to 70% when used in steady state (i.e. heavy utilization), therefore in order to receive this discount benefit you need to make sure that all your RDS database reservation purchases have been successfully completed.