As you can see in the demo:
-
The instance with Hot Standby completes the failover in approximately 15 seconds. Crucially, its transaction per second (TPS) rate returns to the pre-failover levels almost immediately.
-
The instance with Legacy HA takes noticeably longer to complete the failover. Even when it comes back online, the TPS is significantly lower and takes several minutes to ramp back up to the original performance levels as its caches warm up.
This side-by-side comparison clearly shows the benefits of Hot Standby in minimizing downtime and eliminating the post-failover performance impact.
Get Started with Enhanced HA
Hot Standby is being rolled out to newly created AlloyDB instances in PostgreSQL 18, providing an upgraded HA experience automatically, and will be rolling out to the earlier major versions in the coming months. You can continue to rely on AlloyDB’s 99.99% SLA, now backed by even faster failovers and more predictable post-failover performance.
This enhancement underscores our commitment to providing a best-in-class, enterprise-grade managed PostgreSQL experience.
To learn more about AlloyDB’s High Availability features, please refer to the official documentation. New to AlloyDB? Try it out today!
Source Credit: https://cloud.google.com/blog/products/databases/alloydb-hot-standby-faster-failovers-and-consistent-performance/
