Pipeline: Correct one SQL DB instance with low cpu utilization

Correct one SQL DB instance with low CPU utilization

SQL instances can be costly to run, especially if they're rarely used, instances with low average CPU utilization should be reviewed to determine if they're still required.

This pipeline allows you to specify a single instance and then either send a notification or attempt to perform a predefined corrective action.

Whilst it is possible to utilise this pipeline standalone, it is usually called from the correct_sql_db_instances_with_low_cpu_utilization pipeline.

Run the pipeline

To run this pipeline from your terminal:

flowpipe pipeline run gcp_thrifty.pipeline.correct_one_sql_db_instance_with_low_cpu_utilization \
  --arg 'instance_name=<string>' \
  --arg 'title=<string>' \
  --arg 'project=<string>' \
  --arg 'conn=<connection.gcp>'

Use this pipeline

To call this pipeline from your pipeline, use a step:

step "pipeline" "step_name" {
  pipeline = gcp_thrifty.pipeline.correct_one_sql_db_instance_with_low_cpu_utilization  
  args = {
    instance_name = <string>
    title = <string>
    project = <string>
    conn = <connection.gcp>
  }
}

Params

Name	Type	Required	Description	Default
instance_name	string	Yes	The name of the SQL DB instance.	-
title	string	Yes	Title of the resource, to be used as a display name.	-
project	string	Yes	GCP Project ID of the resource(s).	-
conn	connection.gcp	Yes	Name of the GCP connection to be used for any authenticated actions.	-
notifier	notifier	Yes	The name of the notifier to use for sending notification messages.	`notifier.default`
notification_level	string `info`, `verbose`, `error`	Yes	The verbosity level of notification messages to send.	`info`
approvers	list(notifier)	Yes	List of notifiers to be used for obtaining action/approval decisions.	`notifier.default`
default_action	string `notify`, `skip`, `stop_sql_instance`, `delete_instance`	Yes	The default action to use for the detected item, used if no input is provided.	`notify`
enabled_actions	list(string) `skip`, `stop_sql_instance`, `delete_instance`	Yes	The list of enabled actions to provide to approvers for selection.	`[ "skip", "stop_sql_instance", "delete_instance" ]`

Outputs