Hey all y’all,
Working on my first adventure with terraform - love the idea of it, but have been bashing my head against the wall on configuring an rds cluster using aurora-mysql version 5.7.x . Here the snippet:
resource "aws_rds_cluster" "mysql" {
cluster_identifier = "d30-${var.environment}-mysql"
availability_zones = ["us-east-1a", "us-east-1b", "us-east-1c"]
database_name = "xxx"
master_username = "yyyy"
master_password = "zzzz"
engine = "aurora-mysql"
engine_version = "5.7.mysql_aurora.2.03.2"
skip_final_snapshot = true
}
When running with TRACE enabled, I see that the config that goes to AWS always specifies “Engine: aurora” - which, I think, leads to the error of:
Error: error creating RDS cluster: InvalidParameterValue: The engine mode provisioned you requested is currently unavailable.
Looking in the TRACE, I see this block:
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: 2019/10/17 19:14:29 [DEBUG] RDS Cluster create options: {
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: AvailabilityZones: [“us-east-1b”,“us-east-1a”,“us-east-1c”],
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: BackupRetentionPeriod: 1,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: CopyTagsToSnapshot: false,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: DBClusterIdentifier: “d30-stage-mysql”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: DBSubnetGroupName: “d30-stage-dbsubnetgroup”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: DatabaseName: “xxx”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: DeletionProtection: false,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: Engine: “aurora”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: EngineMode: “provisioned”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: EngineVersion: “5.7.mysql_aurora.2.03.2”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: MasterUserPassword: “zzzz”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: MasterUsername: “yyyy”,
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: Tags:
2019-10-17T19:14:29.543-0400 [DEBUG] plugin.terraform-provider-aws_v2.33.0_x4: }
Any thoughts on how to get this to go? Is nobody creating Aurora clusters of the 5.7 mysql version of Aurora?
Best,
pete