/plushcap/analysis/aiven/aiven-postgresql-read-only-replicas

Aiven for PostgreSQLĀ® read-only replicas

What's this blog post about?

PostgreSQL read-only replicas increase read throughput and take some load off of your master node. These replicas, also known as standby nodes, maintain an up-to-date copy of the same database files that exist on the master. They are useful for multiple reasons such as having another physical copy of the data in case of failures, reducing the data loss window during disasters, and restoring the database back to operation quickly after a failure. Aiven offers PostgreSQL plans with different number of standby server nodes, which can be used for read-only queries to reduce the load on the master server. The replica nodes can be accessed by using the separate "Read-only replica URL" visible in the Aiven web console.

Company
Aiven

Date published
Dec. 28, 2016

Author(s)
Hannu Valtonen

Word count
1421

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.