Hello
we have some tf code to deploy global aurora database on aws environment . This global has a cluster in regions, and each cluster have an instance , 1 writer and 1 reader if we have 2 regions.
Ok… All the code works fine.
Now I would like to UPGRADE this.
From aws console, the way we upgrade is choosing the GLOBAL container, and MODIFY and then change engine version. This process keep the data intact and upgrade the binaries for all the clusters.
I try to change the parameter engine_version in our code but is’s related to the instance… or cluster not to global, so tf ask to destroy all and redo with the new version. That is not good because in this case we lost all the data.
Can you give me an example of code to make this upgrade ?
I search in the doc but I’m not able to find it.
I just find this, looks like it’s this, some one already use it ?
resource "aws_rds_global_cluster" "example" {
global_cluster_identifier = "global-test"
engine = "aurora"
engine_version = "5.6.mysql_aurora.1.22.2"
database_name = "example_db"
}
resource "aws_rds_cluster" "primary" {
provider = aws.primary
engine = aws_rds_global_cluster.example.engine
engine_version = aws_rds_global_cluster.example.engine_version
cluster_identifier = "test-primary-cluster"
master_username = "username"
master_password = "somepass123"
database_name = "example_db"
global_cluster_identifier = aws_rds_global_cluster.example.id
db_subnet_group_name = "default"
}
resource "aws_rds_cluster_instance" "primary" {
provider = aws.primary
engine = aws_rds_global_cluster.example.engine
engine_version = aws_rds_global_cluster.example.engine_version
identifier = "test-primary-cluster-instance"
cluster_identifier = aws_rds_cluster.primary.id
instance_class = "db.r4.large"
db_subnet_group_name = "default"
}
Let me know
many thanks