terraformでRDSのバージョンアップをする

ピン留めされたアイテム

インプレースアップグレードは対応していないため、設定はできますが、実行エラーになります。

In-place upgrade of the engine to the new target version 8.0.mysql_aurora.3.02.0 is not supported

merutin

最小限のリソース作成
いろんなところからコピペしているので、あんまりきれいじゃない。

provider "aws" {
  region = "ap-northeast-1"

  default_tags {
    tags = {
      HashiCorpLearnTutorial = "rds-upgrade"
    }
  }
}

data "aws_availability_zones" "available" {}

resource "aws_default_vpc" "default_vpc" {
}

data "aws_subnets" "default_subnets" {
  filter {
    name   = "vpc-id"
    values = [aws_default_vpc.default_vpc.id]
  }
}

resource "random_pet" "name" {
  length = 1
}

resource "aws_db_subnet_group" "example" {
  name       = "${random_pet.name.id}-example"
  subnet_ids = toset(data.aws_subnets.default_subnets.ids)

  tags = {
    Name = "example"
  }
}

resource "aws_security_group" "rds" {
  name   = "${random_pet.name.id}_example_rds"
  vpc_id = aws_default_vpc.default_vpc.id

  ingress {
    from_port   = 3306
    to_port     = 3306
    protocol    = "tcp"
    cidr_blocks = ["0.0.0.0/0"]
  }

  egress {
    from_port   = 3306
    to_port     = 3306
    protocol    = "tcp"
    cidr_blocks = ["0.0.0.0/0"]
  }

  tags = {
    Name = "example_rds"
  }
}

resource "aws_rds_cluster" "example" {
  cluster_identifier      = "${random_pet.name.id}-demo"
  engine                  = "aurora-mysql"
  engine_version          = "5.7.mysql_aurora.2.10.2"
  availability_zones      = data.aws_availability_zones.available.names
  database_name           = "mydb"
  master_username         = "foo"
  master_password         = "foobarhoge"
  db_subnet_group_name    = aws_db_subnet_group.example.name

  skip_final_snapshot = true
  apply_immediately   = true
}

resource "aws_rds_cluster_instance" "example" {
  count = 1

  cluster_identifier = aws_rds_cluster.example.id
  identifier         = "${random_pet.name.id}-instance-${count.index}"

  engine                  = aws_rds_cluster.example.engine
  engine_version          = aws_rds_cluster.example.engine_version
  instance_class          = "db.t3.small"
  db_subnet_group_name    = aws_db_subnet_group.example.name
  db_parameter_group_name = aws_db_parameter_group.example.name

  publicly_accessible = false
}

resource "aws_db_parameter_group" "example" {
  name   = "${random_pet.name.id}-parameter"
  family = "aurora-mysql5.7"
}

merutin

バージョンアップのために、とりあえずMySQLのバージョンを変えてみる

resource "aws_rds_cluster" "example" {
  cluster_identifier      = "${random_pet.name.id}-demo"
  engine                  = "aurora-mysql"
  engine_version          = "8.0.mysql_aurora.3.02.0"
  availability_zones      = data.aws_availability_zones.available.names
  database_name           = "mydb"
  master_username         = "foo"
  master_password         = "foobarhoge"
  db_subnet_group_name    = aws_db_subnet_group.example.name

  skip_final_snapshot = true
  apply_immediately   = true
}

resource "aws_db_parameter_group" "example" {
  name   = "${random_pet.name.id}-parameter"
  family = "aurora-mysql8.0"
}

merutin

エラーがでた

Failed to modify RDS Cluster (pig-demo): InvalidParameterCombination: The AllowMajorVersionUpgrade flag must be present when upgrading to a new major version.

merutin

エラーの通り、allow_major_version_upgradeを設定してみる

resource "aws_rds_cluster" "example" {
  cluster_identifier   = "${random_pet.name.id}-demo"
  engine               = "aurora-mysql"
  engine_version       = "8.0.mysql_aurora.3.02.0"
  availability_zones   = data.aws_availability_zones.available.names
  database_name        = "mydb"
  master_username      = "foo"
  master_password      = "foobarhoge"
  db_subnet_group_name = aws_db_subnet_group.example.name

  skip_final_snapshot         = true
  apply_immediately           = true
  allow_major_version_upgrade = true
}```

merutin

またエラーになった。

Failed to modify RDS Cluster (pig-demo): InvalidParameterCombination: In-place upgrade of the engine to the new target version 8.0.mysql_aurora.3.02.0 is not supported.

merutin

最終的にやりたかったのはこれ

merutin

なので、このへんのやり方を試してみる必要がある

merutin

いったん5.7でインスタンスを作成する
そのあとに5.7にかかわる部分をstateから削除する

terraform state rm 'aws_rds_cluster.example'
terraform state rm 'aws_rds_cluster_instance.example'
terraform state rm  'aws_db_parameter_group.example'

merutin

コンソールからスナップショットを取得する。停止した状態で取得したいけど、、無理なのでしょうがない

merutin

terraformの値を変更してapplyする
snapshot_identifierをセットして、スナップショットから起動するようにする

resource "aws_rds_cluster" "example" {
  cluster_identifier          = "${random_pet.name.id}-demo"
  engine                      = "aurora-mysql"
  engine_version              = "8.0.mysql_aurora.3.02.0"
  # engine_version              = "5.7.mysql_aurora.2.10.2"
  availability_zones          = data.aws_availability_zones.available.names
  database_name               = "mydb"
  master_username             = "foo"
  master_password             = "foobarhoge"
  db_subnet_group_name        = aws_db_subnet_group.example.name
  skip_final_snapshot         = true
  allow_major_version_upgrade = true
  apply_immediately           = true
  snapshot_identifier         = "arn:aws:rds:ap-northeast-1:xxx:cluster-snapshot:pheasant-demo"
}

resource "aws_rds_cluster_instance" "example" {
  count                   = 1
  cluster_identifier      = aws_rds_cluster.example.id
  identifier              = "${random_pet.name.id}-instance-${count.index}"
  engine                  = aws_rds_cluster.example.engine
  engine_version          = aws_rds_cluster.example.engine_version
  instance_class          = "db.t3.medium"
  db_subnet_group_name    = aws_db_subnet_group.example.name
  db_parameter_group_name = aws_db_parameter_group.example.name
  publicly_accessible     = false
  apply_immediately       = true
}

resource "aws_db_parameter_group" "example" {
  name   = "${random_pet.name.id}-parameter"
  # family = "aurora-mysql5.7"
  family = "aurora-mysql8.0"
}

merutin

で、terrafom applyする。エラーだった。。

merutin

cluster_identifierの値を変更してapplyすると作成できる

merutin

aws_db_parameter_groupのnameも一意らしいので修正する

merutin

aws_rds_cluster_instanceのidentifierも一意にしたほうがよさそう

merutin

clusterの情報も変更が必要だった。最終的にこんな感じ

resource "aws_rds_cluster" "example" {
  cluster_identifier          = "${random_pet.name.id}-demo-sls"
  engine                      = "aurora-mysql"
  engine_mode                 = "provisioned"
  engine_version              = "8.0.mysql_aurora.3.02.0"
  # engine_version              = "5.7.mysql_aurora.2.10.2"
  availability_zones          = data.aws_availability_zones.available.names
  database_name               = "mydb"
  master_username             = "foo"
  master_password             = "foobarhoge"
  db_subnet_group_name        = aws_db_subnet_group.example.name
  skip_final_snapshot         = true
  allow_major_version_upgrade = true
  apply_immediately           = true
  snapshot_identifier         = "arn:aws:rds:ap-northeast-1:xxx:cluster-snapshot:pheasant-demo"
  serverlessv2_scaling_configuration {
    min_capacity = 0.5
    max_capacity = 1
  }
}

resource "aws_rds_cluster_instance" "example" {
  count                   = 1
  cluster_identifier      = aws_rds_cluster.example.id
  identifier              = "${random_pet.name.id}-80-instance-${count.index}"
  engine                  = aws_rds_cluster.example.engine
  engine_version          = aws_rds_cluster.example.engine_version
  instance_class          = "db.t3.medium"
  db_subnet_group_name    = aws_db_subnet_group.example.name
  db_parameter_group_name = aws_db_parameter_group.example.name
  publicly_accessible     = false
  apply_immediately       = true
}

resource "aws_rds_cluster_instance" "serverless" {
  count                   = 1
  cluster_identifier      = aws_rds_cluster.example.id
  identifier              = "${random_pet.name.id}-80-sls-instance-${count.index}"
  engine                  = aws_rds_cluster.example.engine
  engine_version          = aws_rds_cluster.example.engine_version
  instance_class          = "db.serverless"
  db_subnet_group_name    = aws_db_subnet_group.example.name
  db_parameter_group_name = aws_db_parameter_group.example.name
  publicly_accessible     = false
  apply_immediately       = true
}

resource "aws_db_parameter_group" "example" {
  name   = "${random_pet.name.id}-80-parameter"
  # family = "aurora-mysql5.7"
  family = "aurora-mysql8.0"
}

このスクラップは2022/07/11にクローズされました