Posted On: May 30, 2023
Amazon Relational Database Service (Amazon RDS) for PostgreSQL and for MySQL now supports a new Multi-AZ deployment option with one primary and two readable standby database (DB) instances across three Availability Zones (AZs). This deployment option is optimized for write transactions and is ideal when your workloads require lower write latency, automated failovers, and more read capacity.
Amazon RDS Multi-AZ deployments provide enhanced availability and durability for Amazon RDS DB instances, making them a natural fit for production database workloads. Although continuing to use network storage for durability, this new deployment option optimizes transaction commit performance using local instance storage. This configuration supports up to 2x faster transaction commits than a Multi-AZ DB instance deployment with one standby, without compromising data durability. Automated failovers in this configuration typically take under 35 seconds. In addition, the standby DB instances can also serve read traffic without needing to attach additional read replica DB instances. You can connect to your readable standby DB instances by using a managed read-only endpoint or the individual endpoints of each reader instance. This deployment option also supports Amazon RDS Optimized Writes on RDS for MySQL and Amazon RDS Optimized Reads on both RDS for PostgreSQL and MySQL database instances.
This new Amazon RDS Multi-AZ deployment option with one primary and two readable standby (DB) instances is now available in the Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD. For a list of supported RDS for PostgreSQL and MySQL engine versions refer Amazon RDS User Guide. See Amazon RDS pricing page for pricing details.