PGCon2012 - Slide release #12

PGCon 2012
The PostgreSQL Conference

Ashutosh Bapat
Koichi Suzuki
Michael Paquier
Day Tutorials - 2 - Wednesday - 2012-05-16
Room MRT 212
Start time 13:00
Duration 03:00
ID 424
Event type Other
Track Scaling Out
Language used for presentation English

Tutorial - Configuring write-scalable PostgreSQL cluster

Postgres-XC primer and more

Postgres-XC (simply XC) is write-scalable PostgreSQL cluster, which will be generally available by early May, 2012. So far, XC is only one write-scalable, symetric database cluster solution available as open source.

This tutorial covers almost all the topics needed to use Postgres-XC, listed as follows: 1) Postgres-XC, what it is and what it is not 2) Postgres-XC elements -- Global Transaction Manager, Coordinator and Datanode 3) How to design a Postgres-XC cluster --- cluster configuration and table design 4) Build and installation 5) How to configure Postgres-XC 6) How to test Postgres-XC 7) Cluster-wide backup and restore 8) High availability and component failure 9) Postgres-XC as a community, be a developer!