首页 > 代码库 > postgresql集群方案选型
postgresql集群方案选型
High Availability, Load Balancing, and Replication Feature Matrix
| Feature | Shared Disk Failover | File System Replication | Hot/Warm Standby Using PITR | Trigger-Based Master-Standby Replication | Statement-Based Replication Middleware | Asynchronous Multimaster Replication | Synchronous Multimaster Replication |
|---|---|---|---|---|---|---|---|
| Most Common Implementation | NAS | DRBD | PITR | Slony | pgpool-II | Bucardo | |
| Communication Method | shared disk | disk blocks | WAL | table rows | SQL | table rows | table rows and row locks |
| No special hardware required | ? | ? | ? | ? | ? | ? | |
| Allows multiple master servers | ? | ? | ? | ||||
| No master server overhead | ? | ? | ? | ||||
| No waiting for multiple servers | ? | ? | ? | ? | |||
| Master failure will never lose data | ? | ? | ? | ? | |||
| Standby accept read-only queries | Hot only | ? | ? | ? | ? | ||
| Per-table granularity | ? | ? | ? | ||||
| No conflict resolution necessary | ? | ? | ? | ? | ? |
postgresql集群方案选型
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。