postgresql集群方案选型
浏览数：53 /
时间：2015年06月12日
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 | ? | ? | ? | ? | ? |
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
