Perform replication of data for HMIS/CES schemas by creating another postgres RDS and replicating the data there.

[logicsandeep]

Perform replication of data for HMIS/CES schemas by creating another postgres RDS and replicating the data there.

[eric-jahn]

Wouldn't it be better to just use Postgres' multi-node feature, if we are going for stability and scalability?

[logicsandeep]

Yes, that's what we would like to use. I'm also looking in terms of having 100% replication so that if one node is down we can use another node to get data. And possibly add a load balancer to get the postgres data from the postgres nodes.

[eric-jahn]

perfect

[suryayadavalli]

Proposed cloud architecture addresses this availability and replication issue. With this set up , the physical replication of the database is handled on a different zone , automatically handled by AWS, and failover happens automatically to the secondary instance during all the failover scenarios

• Loss of availability of the master instance
• Loss of network connectivity to the master instance
• Compute unit failure on primary
• Storage failure on primary

More on Multi availability zone here from AWS
https://aws.amazon.com/rds/details/multi-az/