Usecase Universe

A collective of use cases for DevOps teams

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

RDS

24 Times Used
22 MAY 2019
Reboot RDS DB instances if DB connections goes high ( Triggered by JIRA ).

Jira ticket with required summary will trigger this workflow. RDS DB Instances having the same tag that are mentioned in the description of jira ticket will get rebooted. This will reduce the CPUUtilization of the DB instance.

RDS DB instances MultiAZ alteration.

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

Enable deletion protection for RDS Aurora DB clusters

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

Enable IAM database authentication feature for AWS RDS DB instances.

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.

Report Idle RDS DB instances.

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.

Report DB Instance Generation (General Purpose)

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.

Report public RDS Instances weekly

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

Report RDS DB instances that does not have desired instance type.

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.

Report AWS reserved RDS instances pending purchases

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.

Report DB Instance Generation (Micro Instances)

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.

Report RDS instances with high CPU utilization.

Sends a report of RDS instances if there CPU utilization goes above than 90 %. Instances with high CPUUtilization should be rebooted this will improve the performance.

Report RDS database master username.

Sends a report if RDS databases are using "awsuser" as master username. "Awsuser" is the Amazon's example (default) for the RDS database master username, many AWS customers will use this username for their RDS databases in production which can lead to malicious activities.