Am migrating an RDS instance to a RDS cluster.
Set up a read replica rds cluster to replicate from RDS instance by setting the replication_source_identifier = “arn of the rds instance”. All good here.
Now I am ready to promote the read replica rds cluster to standalone rds cluster, so set the replication_source_identifier = null.
The terraform plan shows that it would replace the replication_source_identifier.
The apply run to completion ,but the promotion does not happen.
Any idea how to fix this ? Any help is much appreciated