Aiven for PostgreSQLĀ® read-only replicas
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