Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Recovery

Failure Domain

等级故障域(Failure Domain)典型场景RTORPO
L1数据对象级故障(Object-Level Failure)DROP TABLE、误 DELETE、误 UPDATE分钟级0~秒级
L2实例级故障(Instance Failure)PostgreSQL 进程崩溃、OS Crash秒级~分钟级0
L3节点级故障(Node Failure)主机损坏、磁盘损坏、电源故障秒级~分钟级0~秒级
L4集群级故障(Cluster Failure)主库与备库同时损坏、存储阵列损坏小时级分钟级~小时级
L5站点级灾难(Site Disaster)机房断电、火灾、洪水、网络隔离小时级~天级分钟级~小时级
L6区域级灾难(Regional Disaster)城市级停电、区域网络瘫痪天级小时级~天级

Recovery Mechanism

层级故障域 (Failure Domain)能力类别 (Capability)恢复机制 (Recovery Mechanism)典型场景
L1ObjectLogical RecoveryPITR / FlashbackDROP TABLE、误 DELETE、误 UPDATE
L2InstanceCrash RecoveryWAL ReplayPostgreSQL 进程崩溃、OS Crash
L3NodeHigh AvailabilityFailover / Switchover主机损坏、磁盘损坏、电源故障
L4ClusterBackup RecoveryRestore + PITRWAL归档系统损坏、脑裂
L5SiteMetro Disaster RecoveryMetro DR Failover机房断电、火灾、洪水、网络隔离
L6RegionGeo Disaster RecoveryGeo DR Failover城市级停电、区域网络瘫痪