High availability (HA) for Amazon RDS PostgreSQL can be achieved using a variety of methods, including:
Multi-AZ deployments are the most common way to achieve high availability for Amazon RDS PostgreSQL. Multi-AZ deployments are easy to set up and manage, and they provide a high level of availability.
Read replicas can also be used to improve the availability of Amazon RDS PostgreSQL databases. Read replicas can be used to offload read traffic from the primary database, which can improve the performance and scalability of the database. Read replicas can also be used to create a disaster recovery plan in case the primary database fails.
Database clusters are the most advanced option for achieving high availability and scalability for Amazon RDS PostgreSQL. Database clusters are more complex to set up and manage than multi-AZ deployments, but they can provide a higher level of availability and scalability.
In this lab, you will setup the high-availability Multi-AZ configuration for your RDS PostgreSQL database instance. Then you will simulate a failover event to see how it performs. Finally, you scale-up your RDS instance for additional write capacity.