postgresql叢集方案選型

標籤：io   ar   os   sp   for   on   div   bs   ad   

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叢集方案選型