La lecture à portée de main
Découvre YouScribe en t'inscrivant gratuitement
Je m'inscrisDécouvre YouScribe en t'inscrivant gratuitement
Je m'inscrisDescription
Sujets
Informations
Publié par | kyann |
Publié le | 13 février 2013 |
Nombre de lectures | 234 |
Extrait
PGCon2012 Tutorial
Configuring WriteScalable PostgreSQL
Cluster
PostgresXC Primer and More
by
Koichi Suzuki
Michael Paquier
Ashutosh Bapat
May 16th, 2012Agenda
● A – PostgresXC introduction
● B Cluster design, navigation and configuration
● C Distributing data effectively
● D Backup and restore, high availability
● E PostgresXC as a community
May 16th, 2012 PostgresXC 2Chapter A
PostgresXC Introduction
May 16th, 2012 PostgresXC 3A1
What PostgresXC is and
what it is not
May 16th, 2012 PostgresXC 4Summary (1)
● PostgreSQLbased database cluster
● Binary compatible applications
– Many core extension
● Catches up latest PostgreSQL version
– At present based upon PG 9.1. Soon will be upgraded to PG 9.2.
● Symmetric Cluster
● No master, no slave
– Not just PostgreSQL replication.
– Application can read/write to any server
● Consistent database view to all the transactions
– Complete ACID property to all the transactions in the cluster
● Scales both for Write and Read
May 16th, 2012 PostgresXC 5Summary (2)
● Not just a replication
● Configured to provide parallel transaction/statement handling.
● HA configuration needs separate setups (explained later)
May 16th, 2012 PostgresXC 6Symmetric Cluster (1)
PostgreSQL replication
May 16th, 2012 PostgresXC 7Symmetric Cluster (2)
PostgresXC Cluster
May 16th, 2012 PostgresXC 8Read/Write Scalability
DBT1 throughput scalability
May 16th, 2012 PostgresXC 9Present Status
● Project/Developer site
● http://postgres-xc.sourceforge.net/
● http://sourceforge.net/projects/postgres-xc/
● Now Version 1.0 available
● Base PostgreSQL version: 9.1
– Promptly merged with PostgreSQL 9.2 when available
● 64bit Linux on Intel X86_64 architecture
– Tested on CentOS 5.8 and ubuntu 10.4
May 16th, 2012 PostgresXC 10