🚽 👻 🧑🏿 Using ClusterControl for PostgreSQL Disaster Recovery in a Hybrid Cloud 👷🏼 🌬️ 👘

For future students of the "PostgreSQL" course , we have prepared a translation of a useful article.

We also invite everyone to an open demo lesson "Data Migration Problems" . At the webinar, we:

- Let's talk about the types of migration and how to implement them;

- Let's analyze the main problems associated with data migration and ways to eliminate them;

- Consider several real practical cases and speculate on the effectiveness of their solution;

- Let's recall the software tools that automate the data migration process.

(Hybrid Cloud) , — . , DRP- (disaster recovery plan, ). . DRP- , . .

(Business Continuity), , DRP- . RTO RPO. : . SLA . .

, . , :

Failover Switchover
(High Availability)
(Load Balancing)
(Highly Distributed Environment)

Failover Switchover

Failover — . (hot standby) (warm standby) (promote) (primary) / (master). , . , failover . , , . heartbeat (): . . , . failover. . failover.

/ . , — , , , .

failover , . failover , PostgreSQL, ClusterControl, pg_auto_failover CitusData ( Microsoft), Pgpool-II, Bucardo . (node fencing), STONITH (Shoot The Other Node In The Head). , . split-brain.