PostsgreSQL中的一些cluster方案功能列表

Posted on 2011-04-05 11:25:55 by osdba

Program License Maturity Replication Method Sync Connection Pooling Load Balancing Query Partitioning
PGCluster BSD See version details on site Master-Master Synchronous No Yes No
pgpool-I BSD Stable Statement-Based Middleware Synchronous Yes Yes No
pgpool-II BSD Recent release Statement-Based Middleware Synchronous Yes Yes Yes
slony-I BSD Stable Master-Slave Asynchronous No No No
Bucardo BSD Stable Master-Master, Master-Slave Asynchronous No No No
Londiste BSD Stable Master-Slave Asynchronous No No No
Mammoth BSD Stable Master-Slave Asynchronous No No No
rubyrep MIT Recent Release Master-Master, Master-Slave Asynchronous No No

No


slony-I:

 

Scalability Single origin (master), up to 20 subscribers.
Read scaling yes
Write scaling no/slight inverse
Triggers/procedures Yes
Parallel query No
Failover/High Availability Yes
Online provisioning Yes
PostgreSQL upgrades Yes
Detached node/WAN Yes, but can be clumsy
PostgreSQL core modifications required No
Programming languages SQL, pl/pgsql, C/SPI, C
Licensing OSS License ???? (cannot find on web site)
Complete clustering solution No. (load balancer, pooler required)
PostgreSQL versions  

 

Bucardo:

Scalability Master-slave: high with cascading slaves. Multi-master: two masters only
Read scaling yes
Write scaling yes (with multimaster); no/slight inverse (master/slave only)
Triggers/procedures Yes
Parallel query No
Failover/High Availability Not automatic
Online provisioning No
PostgreSQL upgrades Yes
Detached node/WAN Yes
PostgreSQL core modifications required No
Programming languages Perl, Pl/PgSQL, Pl/PerlU
Licensing BSD
Complete clustering solution Yes
PostgreSQL versions 8.1 to 9.0

Postgres-XC

Scalability Evaluated with ten servers. Potentially twenty to thirty servers.
Read scaling Yes
Write scaling Yes
Triggers/procedures Procedure: Yes Trigger will be supported by the end of March, 2011.
Parallel query Now some of the queries can be executed in parallel in multiple data nodes.  
Failover/High Availability No Will be available by the end of March, 2011
Online provisioning No  
PostgreSQL upgrades No All the node should be upgraded at the same time.
Detached node/WAN No Postgres-XC depends upon high speed communication.
PostgreSQL core modifications required Yes  
Programming languages C, flex, bison, bash and ruby (just for utilities)  
Licensing LGPL v.2  
Complete clustering solution Targetted Hi-availability feature will be added.
PostgreSQL versions 8.4.3 Planning to move to 9.0.1 or later

 

pgcluster

  • Scalability: 3-6
  • Read Scaling: some
  • Write Scaling: negative scaling
  • Triggers/procedures: Yes
  • Parallel Query: No
  • Failover/HA: Yes
  • Online Provisioning: with issues
  • PostgreSQL Upgrades: No
  • Detached Node/WAN: No
  • PostgreSQL Core Modifications Required: Yes
  • Programming Languages: C
  • Licensing: OSS, BSD license
  • Complete Cluster: Yes


pgpool-II

  • Scalability: Yes (up to 128 DB nodes)
  • Read Scaling: Yes
  • Write Scaling: No (possible to have up to 128 DB nodes, but performance is 60-70% of plain PostgreSQL)
  • Synchronous replication: Yes
  • Triggers/procedures: Yes
  • Parallel Query: Yes
  • Failover/HA: Yes
  • Online Provisioning: Yes
  • PostgreSQL Upgrades: No
  • Detached Node/WAN: No
  • PostgreSQL Core Modifications Required: No
  • Programming Languages: C