Multi-DC PostgreSQL: Setting Up a Standby Node at a Different Geo-Location Over a VPN
Previously, we wrote about Setting Up a Geo-Distributed Database Cluster Using MySQL Replication. This time, it's about PostgreSQL. Setting up a geo-distributed cluster for PostgreSQL is not a new concept and the topology is quite...
An Overview of Cluster-to-Cluster Replication
Nowadays, it’s pretty common to have a database replicated in another server/datacenter, and it’s also a must in some cases. There are different reasons to replicate your databases to a totally separate environment. Migrate to...
Failover & Failback on Amazon RDS
Previously we posted a blog discussing Achieving MySQL Failover & Failback on Google Cloud Platform (GCP) and in this blog we'll look at how it’s rival, Amazon Relational Database Service (RDS), handles failover. We will...
Backup Management Tips for TimescaleDB
Information is one of the most valuable assets in a company, and it goes without saying that you should have a Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident...
Configuring PostgreSQL for Business Continuity
Business Continuity for Databases Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even...
How to Minimize RPO for Your PostgreSQL Databases Using Point in Time Recovery
In a disaster recovery plan, your Recovery Point Objective (RPO) is a key recovery parameter that dictates how much data you can afford to lose. RPO is listed in time, from seconds to days. Effectively,...