postgresql集群方案选型

发布时间：2020-12-13 17:24:00 所属栏目：百科来源：网络整理

导读：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 M

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!