Adding Failover Node to Postgres Database

Private deployments can add a failover node to the RDS cluster hosting the Postgres metadata database. This improves redundancy by allowing AWS to shift traffic to the read replica if the primary node becomes unavailable.

This failover node uses a reader DB instance. For more information, visit the AWS Advantages of Aurora Serverless v2 at https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.html#aurora-serverless-v2.advantages

Add the following variable to Terraform Cloud for the workspace:

Variable Name: read_replica_enabled

Variable Value: yes

After adding the variable, start a new Plan and Apply run of Terraform Cloud to update the DataForge workspace and infrastructure. The Apply will stand up a new reader DB instance in your cluster.