Talk Description

Evolution of Replication covers the early history of replication, what worked and what didn’t. Then we move on to discuss the dangers of statement based replication and how the early row based trigger replication evolved. We then compare the features and benefits of various kinds of replication. Later features of Slony will also be discussed.

Talk Description

Petabytes of data are sitting in MySQL databases where they are hard to reach for PostgreSQL users. Learn how to migrate out or integrate MySQL with PostgreSQL with Tungsten Replicator, which can move data from MySQL to PostgreSQL, and in real time, too. In this talk we’ll describe how to design cross-database replication, then set it up using Tungsten Replicator. We will cover some of the pitfalls and corner cases like SQL dialect differences, data types, character sets, and MySQL bugs that make implementation both exciting and fun. We’ll conclude with a demo of database updates moving in real time between databases.

Talk Description

repmgr is free software to make building read scalable clusters of PostgreSQL nodes using this feature simpler to get started with, and then manage in production. This talk will introduce how to setup a cluster with repmgr and what sort of tasks you can expect it to help automate. If you’re concerned you’ll find yourself in a difficult situation where you need to make decisions like “which node has the most recent copy of my data now that the master has failed?” and then shuffle around the configuration of every remaining node, you’ll have just the right tool needed for that type of problem.

Talk Description

PostgreSQL 9.1 includes server changes to allow standalone tools to request and respond according to the replication protocol. From these, two new tools, pg_basebackup and pg_xlogstream allow a number of new possibilities.

Talk Description

The latest version of repmgr also provides automatic failover capability. This talk explains the technical details of repmgr with details from a recent production implementation.

Talk Description

Covers the latest changes in streaming and synchronous replication, plus looks forward to changes available in later versions of PostgreSQL.

Talk Description

This talk will present the current status of Middle-R a middleware for scalable database replication. Middle-R was the pioneer in providing database replication at the middleware level and also to do so with a performance close to the in-kernel implementations. The talk will focus on how the different bottlenecks for scalability have been overcome in Middle-R. In particular, it will be explained how isolation and full database replication bottlenecks have been successfully addressed. The talk will also pay special attention to the autonomic capabilities of Middle-R for self-provisioning and self-healing and the current plans to deploy on cloud environments.

Talk Description

Practical demonstration of scalability with PostgreSQL, PL/Proxy and other components, including future visions.

Talk Description

MGRID is a parallel database for Electronic Health Records, based on PostgreSQL, providing high availability and parallel query execution. Talk covers the objectives of the project, technical features of MGRID and implementation details from the first implementation.

Talk Description

This talk will focus on latest development and roadmap of Postgres-XC cluster system.

Now Postgres-XC, as reported in CHAR, started with simple statment and aggregations and now it can handle much more, including cross node operations and cross-node aggregates. For this purpose, PostgreSQL planner was extended to generate multiple statements for target PostgreSQL databases. Extended planner has several optimization such as where clause and column pushdown, join pushdonw, and GROUP BY pushdown.

Postgres-XC’s high-availability feature will also be presented including non-stop backup of global transaction manager (GTM), cluster-wide status management and feilure detection and related operation.

Many of its feature can be brought back to PostgreSQL itself. Presentation will cover this possibility, as well as the roadmap to make Postgres-XC ready for production.

Talk Description

Data warehouses and data marts mange workloads that change over time. Tuning is fruitless in this case… Today’s tuning will not speed up the query that comes in tomorrow. What is required is fast scanning with few or no indexes, materialized views, or cache dependencies. Clustering options and shared-nothing implementations of Postgres provide extremely fast scan rates… Rates capable of supporting BI workloads against Big Data without tuning. This paper will model various fast scan techniques and show how this is accomplished.

Talk Description

Having run a PostgreSQL based data warehouse for many years, ContextWorld recently converted their main internal systems to use Greenplum technology, with interesting results.

Talk Description

Skytools 3.0 has been recently released. Talk will cover What is Skytools?Why would you want to upgrade? Plus deployment experience, direct from the packager of this software project.

Talk Description

Horizontal scalability is one of the key aspects that need to be considered when designing a database architecture. Backup is a key concern for very large databases. This talk discusses a project to perform parallel and distributed backups of every table in the cluster, supporting multiple backup servers, file compression and incremental backups.

Talk Description

Discussing how to make streaming work with 8.4 and earlier servers

Talk Description

Technical experiences from a lengthy migration from Slony to Streaming Replication. Why we moved, how we moved and the opportunities we found along the way.

Talk Description

Technical details about the implementation of various aspect s of the Heroku infrastructure, using PostgreSQL databases.