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 | • | • | • | • | • |
