首页 > 数据库技术 > 详细

postgresql集群方案选型

时间:2014-12-13 12:26:17      阅读:505      评论:0      收藏:0      [点我收藏+]

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集群方案选型

原文:http://my.oschina.net/mye/blog/355708

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!