Benchmark: RDS Checks
Thrifty RDS Benchmark
Thrifty developers check long running RDS database instances have the correct billing type and have recent connections.
Variables
| Variable | Description | Default |
|---|---|---|
| rds_db_instance_age_max_days | The maximum number of days DB instances are allowed to run. | 90 days |
| rds_db_instance_age_warning_days | The number of days DB instances can be running before sending a warning. | 30 days |
| rds_db_instance_avg_connections | The minimum number of average connections per day required for DB instances to be considered in-use. | 2 connections/day |
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-alicloud-thriftyStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select RDS Checks.
Run this benchmark in your terminal:
powerpipe benchmark run alicloud_thrifty.benchmark.rdsSnapshot and share results via Turbot Pipes:
powerpipe benchmark run alicloud_thrifty.benchmark.rds --shareControls
- Long running RDS DB instances should have billing type as 'Subscription' instead of 'Pay-as-you-go'.
- RDS DB instances with a low number connections per day should be reviewed