patrnoi祥解

所需积分/C币:4 2018-07-31 19:08:21 3.05MB PDF

patroni + zookeeper/etcd 不需要root用户,实现 PostgreSQL数据库HA。
PostgresQL High Availability Shared storage solutions O DRDB+L∨M Trigger-based and logical replication o pglogical, bucardo, sony, londiste, built-in logical replication in PostgreSQL 10 o Built-in physical single master replication o Starting from PostgreSQL 9.0 Multi-master replication o bdr bucardo alando Physical single-master replication Cons rimary No partial replication Major versions much match wal Missing automatic failover Pros Standby Standby Built-in since Postgres 9.0 a wal Minimal overhead Replicates everything Cascading replication Cascade Synchronous replication Takes advantage of streaming and wal WAL shipping alando Automatic failover done wrong Running just two nodes Run the health check from the standby and promote that standby when the health check indicates the primary failure health check Primary Standby wal stream wal wal alando Automatic failover done wrong running just two nodes Split-brain rimary Primary wal wal alando Automatic failover done wrong Single witness node What can possibly go wrong? rimary Standby wal stream wal Wa h ea/t/ ch eck health check witness alando Automatic failover done wrong Single witness node Witness node dies rimary Standby wal stream wal Wa h ea/t/ Check health check vmess 8 alando Automatic failover done wrong Single witness node Or gets partitioned rimary Standby wal stream wal Wa h ea?∥ ch eck health check witness alando Automatic failover done wrong Single witness node Existing primary is running rimary Primary wal wal health check witness 10 alando

...展开详情
img
TJIN

关注 私信 TA的资源

上传资源赚积分,得勋章
相关内容推荐