Module: `rds-cluster`

Terraform module to provision an RDS Aurora cluster for MySQL or Postgres.

Usage

For a complete example, see examples/complete.

For automated tests of the complete example using bats and Terratest (which tests and deploys the example on AWS), see test.

Basic example

module "rds_cluster_aurora_postgres" {
  source = "cloudposse/rds-cluster/aws"
  # Cloud Posse recommends pinning every module to a specific version
  # version     = "x.x.x"

  name            = "postgres"
  engine          = "aurora-postgresql"
  cluster_family  = "aurora-postgresql9.6"
  # 1 writer, 1 reader
  cluster_size    = 2
  # 1 writer, 3 reader
  # cluster_size    = 4
  # 1 writer, 5 reader
  # cluster_size    = 6
  namespace       = "eg"
  stage           = "dev"
  admin_user      = "admin1"
  admin_password  = "Test123456789"
  db_name         = "dbname"
  db_port         = 5432
  instance_type   = "db.r4.large"
  vpc_id          = "vpc-xxxxxxxx"
  security_groups = ["sg-xxxxxxxx"]
  subnets         = ["subnet-xxxxxxxx", "subnet-xxxxxxxx"]
  zone_id         = "Zxxxxxxxx"
}

Serverless Aurora MySQL 5.6

module "rds_cluster_aurora_mysql_serverless" {
  source = "cloudposse/rds-cluster/aws"
  # Cloud Posse recommends pinning every module to a specific version
  # version     = "x.x.x"
  namespace            = "eg"
  stage                = "dev"
  name                 = "db"
  engine               = "aurora"
  engine_mode          = "serverless"
  cluster_family       = "aurora5.6"
  cluster_size         = 0
  admin_user           = "admin1"
  admin_password       = "Test123456789"
  db_name              = "dbname"
  db_port              = 3306
  instance_type        = "db.t2.small"
  vpc_id               = "vpc-xxxxxxxx"
  security_groups      = ["sg-xxxxxxxx"]
  subnets              = ["subnet-xxxxxxxx", "subnet-xxxxxxxx"]
  zone_id              = "Zxxxxxxxx"
  enable_http_endpoint = true

  scaling_configuration = [
    {
      auto_pause               = true
      max_capacity             = 256
      min_capacity             = 2
      seconds_until_auto_pause = 300
    }
  ]
}

Serverless Aurora 2.07.1 MySQL 5.7

module "rds_cluster_aurora_mysql_serverless" {
  source = "cloudposse/rds-cluster/aws"
  # Cloud Posse recommends pinning every module to a specific version
  # version     = "x.x.x"
  namespace            = "eg"
  stage                = "dev"
  name                 = "db"
  engine               = "aurora-mysql"
  engine_mode          = "serverless"
  engine_version       = "5.7.mysql_aurora.2.07.1"
  cluster_family       = "aurora-mysql5.7"
  cluster_size         = 0
  admin_user           = "admin1"
  admin_password       = "Test123456789"
  db_name              = "dbname"
  db_port              = 3306
  vpc_id               = "vpc-xxxxxxxx"
  security_groups      = ["sg-xxxxxxxx"]
  subnets              = ["subnet-xxxxxxxx", "subnet-xxxxxxxx"]
  zone_id              = "Zxxxxxxxx"
  enable_http_endpoint = true

  scaling_configuration = [
    {
      auto_pause               = true
      max_capacity             = 16
      min_capacity             = 1
      seconds_until_auto_pause = 300
      timeout_action           = "ForceApplyCapacityChange"
    }
  ]
}

With cluster parameters

module "rds_cluster_aurora_mysql" {
  source = "cloudposse/rds-cluster/aws"
  # Cloud Posse recommends pinning every module to a specific version
  # version     = "x.x.x"
  engine          = "aurora"
  cluster_family  = "aurora-mysql5.7"
  cluster_size    = 2
  namespace       = "eg"
  stage           = "dev"
  name            = "db"
  admin_user      = "admin1"
  admin_password  = "Test123456789"
  db_name         = "dbname"
  instance_type   = "db.t2.small"
  vpc_id          = "vpc-xxxxxxx"
  security_groups = ["sg-xxxxxxxx"]
  subnets         = ["subnet-xxxxxxxx", "subnet-xxxxxxxx"]
  zone_id         = "Zxxxxxxxx"

  cluster_parameters = [
    {
      name  = "character_set_client"
      value = "utf8"
    },
    {
      name  = "character_set_connection"
      value = "utf8"
    },
    {
      name  = "character_set_database"
      value = "utf8"
    },
    {
      name  = "character_set_results"
      value = "utf8"
    },
    {
      name  = "character_set_server"
      value = "utf8"
    },
    {
      name  = "collation_connection"
      value = "utf8_bin"
    },
    {
      name  = "collation_server"
      value = "utf8_bin"
    },
    {
      name         = "lower_case_table_names"
      value        = "1"
      apply_method = "pending-reboot"
    },
    {
      name         = "skip-character-set-client-handshake"
      value        = "1"
      apply_method = "pending-reboot"
    }
  ]
}

With enhanced monitoring

# create IAM role for monitoring
resource "aws_iam_role" "enhanced_monitoring" {
  name               = "rds-cluster-example-1"
  assume_role_policy = data.aws_iam_policy_document.enhanced_monitoring.json
}

# Attach Amazon's managed policy for RDS enhanced monitoring
resource "aws_iam_role_policy_attachment" "enhanced_monitoring" {
  role       = aws_iam_role.enhanced_monitoring.name
  policy_arn = "arn:aws:iam::aws:policy/service-role/AmazonRDSEnhancedMonitoringRole"
}

# allow rds to assume this role
data "aws_iam_policy_document" "enhanced_monitoring" {
  statement {
      actions = [
      "sts:AssumeRole",
    ]

    effect = "Allow"

    principals {
      type        = "Service"
      identifiers = ["monitoring.rds.amazonaws.com"]
    }
  }
}

module "rds_cluster_aurora_postgres" {
  source = "cloudposse/rds-cluster/aws"
  # Cloud Posse recommends pinning every module to a specific version
  # version     = "x.x.x"
  engine          = "aurora-postgresql"
  cluster_family  = "aurora-postgresql9.6"
  cluster_size    = 2
  namespace       = "eg"
  stage           = "dev"
  name            = "db"
  admin_user      = "admin1"
  admin_password  = "Test123456789"
  db_name         = "dbname"
  db_port         = 5432
  instance_type   = "db.r4.large"
  vpc_id          = "vpc-xxxxxxx"
  security_groups = ["sg-xxxxxxxx"]
  subnets         = ["subnet-xxxxxxxx", "subnet-xxxxxxxx"]
  zone_id         = "Zxxxxxxxx"

  # enable monitoring every 30 seconds
  rds_monitoring_interval = 30

  # reference iam role created above
  rds_monitoring_role_arn = aws_iam_role.enhanced_monitoring.arn
}

Examples

Review the complete example to see how to use this module.

Requirements

Name	Version
terraform	>= 1.0.0
aws	>= 4.23.0
null	>= 2.0

Providers

Name	Version
aws	>= 4.23.0

Modules

Name	Source	Version
dns_master	cloudposse/route53-cluster-hostname/aws	0.12.2
dns_replicas	cloudposse/route53-cluster-hostname/aws	0.12.2
enhanced_monitoring_label	cloudposse/label/null	0.25.0
this	cloudposse/label/null	0.25.0

Resources

Name	Type
aws_appautoscaling_policy.replicas	resource
aws_appautoscaling_target.replicas	resource
aws_db_parameter_group.default	resource
aws_db_subnet_group.default	resource
aws_iam_role.enhanced_monitoring	resource
aws_iam_role_policy_attachment.enhanced_monitoring	resource
aws_rds_cluster.primary	resource
aws_rds_cluster.secondary	resource
aws_rds_cluster_activity_stream.primary	resource
aws_rds_cluster_instance.default	resource
aws_rds_cluster_parameter_group.default	resource
aws_security_group.default	resource
aws_security_group_rule.egress	resource
aws_security_group_rule.ingress_cidr_blocks	resource
aws_security_group_rule.ingress_security_groups	resource
aws_security_group_rule.traffic_inside_security_group	resource
aws_iam_policy_document.enhanced_monitoring	data source
aws_partition.current	data source

Inputs

Name	Description	Type	Default	Required
activity_stream_enabled	Whether to enable Activity Streams	`bool`	`false`	no
activity_stream_kms_key_id	The ARN for the KMS key to encrypt Activity Stream Data data. When specifying `activity_stream_kms_key_id`, `activity_stream_enabled` needs to be set to true	`string`	`""`	no
activity_stream_mode	The mode for the Activity Streams. `async` and `sync` are supported. Defaults to `async`	`string`	`"async"`	no
additional_tag_map	Additional key-value pairs to add to each map in `tags_as_list_of_maps`. Not added to `tags` or `id`. This is for some rare cases where resources want additional configuration of tags and therefore take a list of maps with tag key, value, and additional configuration.	`map(string)`	`{}`	no
admin_password	Password for the master DB user. Ignored if snapshot_identifier or replication_source_identifier is provided	`string`	`""`	no
admin_user	Username for the master DB user. Ignored if snapshot_identifier or replication_source_identifier is provided	`string`	`"admin"`	no
allocated_storage	The allocated storage in GBs	`number`	`null`	no
allow_major_version_upgrade	Enable to allow major engine version upgrades when changing engine versions. Defaults to false.	`bool`	`false`	no
allowed_cidr_blocks	List of CIDR blocks allowed to access the cluster	`list(string)`	`[]`	no
apply_immediately	Specifies whether any cluster modifications are applied immediately, or during the next maintenance window	`bool`	`true`	no
attributes	ID element. Additional attributes (e.g. `workers` or `cluster`) to add to `id`, in the order they appear in the list. New attributes are appended to the end of the list. The elements of the list are joined by the `delimiter` and treated as a single ID element.	`list(string)`	`[]`	no
auto_minor_version_upgrade	Indicates that minor engine upgrades will be applied automatically to the DB instance during the maintenance window	`bool`	`true`	no
autoscaling_enabled	Whether to enable cluster autoscaling	`bool`	`false`	no
autoscaling_max_capacity	Maximum number of instances to be maintained by the autoscaler	`number`	`5`	no
autoscaling_min_capacity	Minimum number of instances to be maintained by the autoscaler	`number`	`1`	no
autoscaling_policy_type	Autoscaling policy type. `TargetTrackingScaling` and `StepScaling` are supported	`string`	`"TargetTrackingScaling"`	no
autoscaling_scale_in_cooldown	The amount of time, in seconds, after a scaling activity completes and before the next scaling down activity can start. Default is 300s	`number`	`300`	no
autoscaling_scale_out_cooldown	The amount of time, in seconds, after a scaling activity completes and before the next scaling up activity can start. Default is 300s	`number`	`300`	no
autoscaling_target_metrics	The metrics type to use. If this value isn't provided the default is CPU utilization	`string`	`"RDSReaderAverageCPUUtilization"`	no
autoscaling_target_value	The target value to scale with respect to target metrics	`number`	`75`	no
backtrack_window	The target backtrack window, in seconds. Only available for aurora engine currently. Must be between 0 and 259200 (72 hours)	`number`	`0`	no
backup_window	Daily time range during which the backups happen	`string`	`"07:00-09:00"`	no
ca_cert_identifier	The identifier of the CA certificate for the DB instance	`string`	`null`	no
cluster_dns_name	Name of the cluster CNAME record to create in the parent DNS zone specified by `zone_id`. If left empty, the name will be auto-asigned using the format `master.var.name`	`string`	`""`	no
cluster_family	The family of the DB cluster parameter group	`string`	`"aurora5.6"`	no
cluster_identifier	The RDS Cluster Identifier. Will use generated label ID if not supplied	`string`	`""`	no
cluster_parameters	List of DB cluster parameters to apply	`list(object({ apply_method = string name = string value = string }))`	`[]`	no
cluster_size	Number of DB instances to create in the cluster	`number`	`2`	no
cluster_type	Either `regional` or `global`. If `regional` will be created as a normal, standalone DB. If `global`, will be made part of a Global cluster (requires `global_cluster_identifier`).	`string`	`"regional"`	no
context	Single object for setting entire context at once. See description of individual variables for details. Leave string and numeric variables as `null` to use default value. Individual variable settings (non-null) override settings in context object, except for attributes, tags, and additional_tag_map, which are merged.	`any`	`{ "additional_tag_map": {}, "attributes": [], "delimiter": null, "descriptor_formats": {}, "enabled": true, "environment": null, "id_length_limit": null, "label_key_case": null, "label_order": [], "label_value_case": null, "labels_as_tags": [ "unset" ], "name": null, "namespace": null, "regex_replace_chars": null, "stage": null, "tags": {}, "tenant": null }`	no
copy_tags_to_snapshot	Copy tags to backup snapshots	`bool`	`false`	no
db_cluster_instance_class	This setting is required to create a provisioned Multi-AZ DB cluster	`string`	`null`	no
db_name	Database name (default is not to create a database)	`string`	`""`	no
db_port	Database port	`number`	`3306`	no
deletion_protection	If the DB instance should have deletion protection enabled	`bool`	`false`	no
delimiter	Delimiter to be used between ID elements. Defaults to `-` (hyphen). Set to `""` to use no delimiter at all.	`string`	`null`	no
descriptor_formats	Describe additional descriptors to be output in the `descriptors` output map. Map of maps. Keys are names of descriptors. Values are maps of the form `{<br/> format = string<br/> labels = list(string)<br/>}` (Type is `any` so the map values can later be enhanced to provide additional options.) `format` is a Terraform format string to be passed to the `format()` function. `labels` is a list of labels, in order, to pass to `format()` function. Label values will be normalized before being passed to `format()` so they will be identical to how they appear in `id`. Default is `{}` (`descriptors` output will be empty).	`any`	`{}`	no
egress_enabled	Whether or not to apply the egress security group rule to default security group, defaults to `true`	`bool`	`true`	no
enable_global_write_forwarding	Set to `true`, to forward writes to an associated global cluster.	`bool`	`false`	no
enable_http_endpoint	Enable HTTP endpoint (data API). Only valid when engine_mode is set to serverless	`bool`	`false`	no
enabled	Set to false to prevent the module from creating any resources	`bool`	`null`	no
enabled_cloudwatch_logs_exports	List of log types to export to cloudwatch. The following log types are supported: audit, error, general, slowquery	`list(string)`	`[]`	no
engine	The name of the database engine to be used for this DB cluster. Valid values: `aurora`, `aurora-mysql`, `aurora-postgresql`	`string`	`"aurora"`	no
engine_mode	The database engine mode. Valid values: `parallelquery`, `provisioned`, `serverless`	`string`	`"provisioned"`	no
engine_version	The version of the database engine to use. See `aws rds describe-db-engine-versions`	`string`	`""`	no
enhanced_monitoring_attributes	The attributes for the enhanced monitoring IAM role	`list(string)`	`[ "enhanced-monitoring" ]`	no
enhanced_monitoring_role_enabled	A boolean flag to enable/disable the creation of the enhanced monitoring IAM role. If set to `false`, the module will not create a new role and will use `rds_monitoring_role_arn` for enhanced monitoring	`bool`	`false`	no
environment	ID element. Usually used for region e.g. 'uw2', 'us-west-2', OR role 'prod', 'staging', 'dev', 'UAT'	`string`	`null`	no
global_cluster_identifier	ID of the Aurora global cluster	`string`	`""`	no
iam_database_authentication_enabled	Specifies whether or mappings of AWS Identity and Access Management (IAM) accounts to database accounts is enabled	`bool`	`false`	no
iam_roles	Iam roles for the Aurora cluster	`list(string)`	`[]`	no
id_length_limit	Limit `id` to this many characters (minimum 6). Set to `0` for unlimited length. Set to `null` for keep the existing setting, which defaults to `0`. Does not affect `id_full`.	`number`	`null`	no
instance_availability_zone	Optional parameter to place cluster instances in a specific availability zone. If left empty, will place randomly	`string`	`""`	no
instance_parameters	List of DB instance parameters to apply	`list(object({ apply_method = string name = string value = string }))`	`[]`	no
instance_type	Instance type to use	`string`	`"db.t2.small"`	no
intra_security_group_traffic_enabled	Whether to allow traffic between resources inside the database's security group.	`bool`	`false`	no
iops	The amount of provisioned IOPS. Setting this implies a storage_type of 'io1'. This setting is required to create a Multi-AZ DB cluster. Check TF docs for values based on db engine	`number`	`null`	no
kms_key_arn	The ARN for the KMS encryption key. When specifying `kms_key_arn`, `storage_encrypted` needs to be set to `true`	`string`	`""`	no
label_key_case	Controls the letter case of the `tags` keys (label names) for tags generated by this module. Does not affect keys of tags passed in via the `tags` input. Possible values: `lower`, `title`, `upper`. Default value: `title`.	`string`	`null`	no
label_order	The order in which the labels (ID elements) appear in the `id`. Defaults to ["namespace", "environment", "stage", "name", "attributes"]. You can omit any of the 6 labels ("tenant" is the 6th), but at least one must be present.	`list(string)`	`null`	no
label_value_case	Controls the letter case of ID elements (labels) as included in `id`, set as tag values, and output by this module individually. Does not affect values of tags passed in via the `tags` input. Possible values: `lower`, `title`, `upper` and `none` (no transformation). Set this to `title` and set `delimiter` to `""` to yield Pascal Case IDs. Default value: `lower`.	`string`	`null`	no
labels_as_tags	Set of labels (ID elements) to include as tags in the `tags` output. Default is to include all labels. Tags with empty values will not be included in the `tags` output. Set to `[]` to suppress all generated tags. Notes: The value of the `name` tag, if included, will be the `id`, not the `name`. Unlike other `null-label` inputs, the initial setting of `labels_as_tags` cannot be changed in later chained modules. Attempts to change it will be silently ignored.	`set(string)`	`[ "default" ]`	no
maintenance_window	Weekly time range during which system maintenance can occur, in UTC	`string`	`"wed:03:00-wed:04:00"`	no
name	ID element. Usually the component or solution name, e.g. 'app' or 'jenkins'. This is the only ID element not also included as a `tag`. The "name" tag is set to the full `id` string. There is no tag with the value of the `name` input.	`string`	`null`	no
namespace	ID element. Usually an abbreviation of your organization name, e.g. 'eg' or 'cp', to help ensure generated IDs are globally unique	`string`	`null`	no
parameter_group_name_prefix_enabled	Set to `true` to use `name_prefix` to name the cluster and database parameter groups. Set to `false` to use `name` instead	`bool`	`true`	no
performance_insights_enabled	Whether to enable Performance Insights	`bool`	`false`	no
performance_insights_kms_key_id	The ARN for the KMS key to encrypt Performance Insights data. When specifying `performance_insights_kms_key_id`, `performance_insights_enabled` needs to be set to true	`string`	`""`	no
performance_insights_retention_period	Amount of time in days to retain Performance Insights data. Either 7 (7 days) or 731 (2 years)	`number`	`null`	no
publicly_accessible	Set to true if you want your cluster to be publicly accessible (such as via QuickSight)	`bool`	`false`	no
rds_monitoring_interval	The interval, in seconds, between points when enhanced monitoring metrics are collected for the DB instance. To disable collecting Enhanced Monitoring metrics, specify 0. The default is 0. Valid Values: 0, 1, 5, 10, 15, 30, 60	`number`	`0`	no
rds_monitoring_role_arn	The ARN for the IAM role that permits RDS to send enhanced monitoring metrics to CloudWatch Logs	`string`	`null`	no
reader_dns_name	Name of the reader endpoint CNAME record to create in the parent DNS zone specified by `zone_id`. If left empty, the name will be auto-asigned using the format `replicas.var.name`	`string`	`""`	no
regex_replace_chars	Terraform regular expression (regex) string. Characters matching the regex will be removed from the ID elements. If not set, `"/[^a-zA-Z0-9-]/"` is used to remove all characters other than hyphens, letters and digits.	`string`	`null`	no
replication_source_identifier	ARN of a source DB cluster or DB instance if this DB cluster is to be created as a Read Replica	`string`	`""`	no
restore_to_point_in_time	List point-in-time recovery options. Only valid actions are `source_cluster_identifier`, `restore_type` and `use_latest_restorable_time`	`list(object({ source_cluster_identifier = string restore_type = string use_latest_restorable_time = bool }))`	`[]`	no
retention_period	Number of days to retain backups for	`number`	`5`	no
s3_import	Restore from a Percona Xtrabackup in S3. The `bucket_name` is required to be in the same region as the resource.	`object({ bucket_name = string bucket_prefix = string ingestion_role = string source_engine = string source_engine_version = string })`	`null`	no
scaling_configuration	List of nested attributes with scaling properties. Only valid when `engine_mode` is set to `serverless`	`list(object({ auto_pause = bool max_capacity = number min_capacity = number seconds_until_auto_pause = number timeout_action = string }))`	`[]`	no
security_groups	List of security groups to be allowed to connect to the DB instance	`list(string)`	`[]`	no
serverlessv2_scaling_configuration	serverlessv2 scaling properties	`object({ min_capacity = number max_capacity = number })`	`null`	no
skip_final_snapshot	Determines whether a final DB snapshot is created before the DB cluster is deleted	`bool`	`true`	no
snapshot_identifier	Specifies whether or not to create this cluster from a snapshot	`string`	`null`	no
source_region	Source Region of primary cluster, needed when using encrypted storage and region replicas	`string`	`""`	no
stage	ID element. Usually used to indicate role, e.g. 'prod', 'staging', 'source', 'build', 'test', 'deploy', 'release'	`string`	`null`	no
storage_encrypted	Specifies whether the DB cluster is encrypted. The default is `false` for `provisioned` `engine_mode` and `true` for `serverless` `engine_mode`	`bool`	`false`	no
storage_type	One of 'standard' (magnetic), 'gp2' (general purpose SSD), 'io1' (provisioned IOPS SSD), 'aurora', or 'aurora-iopt1'	`string`	`null`	no
subnet_group_name	Database subnet group name. Will use generated label ID if not supplied.	`string`	`""`	no
subnets	List of VPC subnet IDs	`list(string)`	n/a	yes
tags	Additional tags (e.g. `{'BusinessUnit': 'XYZ'}`). Neither the tag keys nor the tag values will be modified by this module.	`map(string)`	`{}`	no
tenant	ID element _(Rarely used, not included by default)_. A customer identifier, indicating who this instance of a resource is for	`string`	`null`	no
timeouts_configuration	List of timeout values per action. Only valid actions are `create`, `update` and `delete`	`list(object({ create = string update = string delete = string }))`	`[]`	no
vpc_id	VPC ID to create the cluster in (e.g. `vpc-a22222ee`)	`string`	n/a	yes
vpc_security_group_ids	Additional security group IDs to apply to the cluster, in addition to the provisioned default security group with ingress traffic from existing CIDR blocks and existing security groups	`list(string)`	`[]`	no
zone_id	Route53 DNS Zone ID as list of string (0 or 1 items). If empty, no custom DNS name will be published. If the list contains a single Zone ID, a custom DNS name will be pulished in that zone. Can also be a plain string, but that use is DEPRECATED because of Terraform issues.	`any`	`[]`	no

Outputs

Name	Description
activity_stream_arn	Activity Stream ARN
activity_stream_name	Activity Stream Name
arn	Amazon Resource Name (ARN) of the cluster
cluster_identifier	Cluster Identifier
cluster_resource_id	The region-unique, immutable identifie of the cluster
cluster_security_groups	Default RDS cluster security groups
database_name	Database name
dbi_resource_ids	List of the region-unique, immutable identifiers for the DB instances in the cluster
endpoint	The DNS address of the RDS instance
master_host	DB Master hostname
master_username	Username for the master DB user
reader_endpoint	A read-only endpoint for the Aurora cluster, automatically load-balanced across replicas
replicas_host	Replicas hostname
security_group_arn	Security Group ARN
security_group_id	Security Group ID
security_group_name	Security Group name

Module: rds-cluster

Usage​

Examples​

Requirements​

Providers​

Modules​

Resources​

Inputs​

Outputs​