PostgreSQL-XL, PostgreSQL集群项目

非原创,转自: http://www.postgres-xl.org/overview/

 

Overview

Postgres-XL is a horizontally scalable open source SQL database cluster, flexible enough to handle varying database workloads:


OLTP write-intensive workloads
Business Intelligence requiring MPP parallelism
Operational data store
Key-value store
GIS Geospatial
Mixed-workload environments
Multi-tenant provider hosted environments

xl_cluster


Scalable

Postgres-XL (eXtensible Lattice) allows you to either partition tables across multiple nodes, or replicate them. Partitioning (or distributing) tables allows for write scalability across multiple nodes as well as massively parallel processing (MPP) for Big Data type of workloads.

Replicated tables are typically static data that does not change very often. Replicating them allows for read scalability.


Fully ACID

Postgres-XL is a fully ACID compliant, transactional database that not only provides you with a fully consistent view of your data at all times, it also uses cluster-wide Multi-Version Concurrency Control (MVCC). When you start a transaction or query in Postgres-XL, you’ll see a consistent version of your data across the entire cluster. While you are reading your data on one connection, you could be updating the same table or even row in another connection without any locking. Both connections are working with their own versions of the rows, thanks to global transaction identifiers and snapshots.  Readers do not block writers and writers do not block readers.


Components

Global Transaction Monitor (GTM)

The Global Transaction Monitor ensures cluster-wide transaction consistency. GTM is responsible for issuing transaction ids and snapshots as part of its Multi-version Concurrency Control.

The cluster may also optionally be configured with a GTM Standby, for improved availability.

In addition, one may configure a GTM Proxy at the Coordinators for improved scalability to reduce the amount of communication with GTM.


Coordinator

The Coordinator manages the user sessions and interacts with GTM and the data nodes. The Coordinator parses and plans queries, and sends down a serialized global plan to each of the components involved in a statement.


Data Node

The Data Node is where the actual data is stored. The distribution of the data can be configured by the DBA. For improved availability, one can configure warm standbys of the data nodes to be failover-ready.

Want to get started?  See downloads.


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值