Control: RDS DB clusters should be configured for multiple Availability Zones

Description

This control checks whether high availability is enabled for your RDS DB clusters. RDS DB clusters should be configured for multiple Availability Zones to ensure availability of the data that is stored.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.rds_db_cluster_multiple_az_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_aws_compliance.control.rds_db_cluster_multiple_az_enabled --share

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std -> 'multi_az') is null then 'alarm'
    when (attributes_std -> 'multi_az')::boolean then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std -> 'multi_az') is null then ' ''multi_az'' disabled'
    when (attributes_std -> 'multi_az')::boolean then ' ''multi_az'' enabled'
    else ' ''multi_az'' disabled'
  end || '.' as reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'aws_rds_cluster';

Control: RDS DB clusters should be configured for multiple Availability Zones

Description

Usage

SQL

Tags