Members Login

Donate $50 or more and get the official SydPUG t-shirt!


Achieving Unmatched Scalability with PostgreSQL

Presenter: Richard Sayad

In this presentation, I will share with you Silicon Valleys most valuable secrets!

You will learn how to implement and configure an actual PostgreSQL cluster containing a thousand nodes using Amazon EC2 that can achieve >100,000tps. We will see a real live demonstration of the near linear scale capabilities of PostgreSQL. PostgreSQL is so powerful, that you rarely need to resort to using other NoSQL solutions. This is because PostgreSQL 9.2 now comes with a built-in, high performant key-value store complete with JSON support.

This is a 4 hour, jam packed presentation that you do not want to miss! We will learn how to configure the technology stack from end-to-end using CentOS, cfEngine, Kafka, Zookeeper, Ganglia, Memcached, JEE (jboss), Infinispan, Kryo, Hadoop/HDFS, Hibernate, PgBouncer, P/L proxy, and PostgreSQL. I will also talk about the various sharding techniques, hashing and key generation methods that you can implement for better control of load balancing across large clusters.

Using free open-source solutions and PostgreSQL clusters means that your licensing costs are cut by 100%, with no compromise on quality and performance! The methods and tools shown in this demonstration are used by the worlds largest web sites including Twitter, Youtube, Digg, LinkedIn, Craiglist, Groupon, Wikipedia, Instagram, eBay, Flikr, Netflix and Skype.

Although this is an advanced technical presentation, managers/CEOs/CTOs will see the true benefits of PostgreSQL in real-time (no smoke and mirrors) using practical examples that actually work. If you are non-technical, you may wish to skip the first two presentations.

The presentation will be broken into four parts:

  1. Introduction and Architecture
  2. Implementation (step-by-step)
  3. Monitoring and Management
  4. 1000 Node PostgreSQL Cluster Demo

Next Event...

Achieving Unmatched Scalability with PostgreSQL

This is an event not to be missed. Learn how to scale PostgreSQL to beyond 1000 nodes in the cloud.

Silicon Valley secrets revealed!