Pipeline: Correct SQL DB instances with low cpu utilization

Correct SQL DB instances with low CPU utilization

Overview

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 either:

Run the pipeline

To run this pipeline from your terminal:

flowpipe pipeline run gcp_thrifty.pipeline.correct_sql_db_instances_with_low_cpu_utilization \
  --arg 'items=<list(object({
      title         = string
      instance_name = string
      project       = string
      conn          = string
    }))>'

Use this pipeline

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

step "pipeline" "step_name" {
  pipeline = gcp_thrifty.pipeline.correct_sql_db_instances_with_low_cpu_utilization  
  args = {
    items = <list(object({
      title         = string
      instance_name = string
      project       = string
      conn          = string
    }))>
  }
}

Triggers

Detect & correct SQL DB instances with low cpu utilization

Params

Name	Type	Required	Description	Default
items	list(object({ title = string instance_name = string project = string conn = string }))	Yes		-
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

This pipeline has no outputs.