If you are interested in sharing and learning about PostgreSQL in Sydney, then this is the place to be. This group is primarily for users who wish to go beyond the basics and implement PostgreSQL to solve real world problems. Learn topics relating to development, database administration, and designing solutions around the worlds most advanced open source database, PostgreSQL!
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 9.3.
PostgreSQL is so powerful, that you rarely need to resort to using other NoSQL solutions since PostgreSQL comes with a built-in, high performant key-value store complete with JSON support introduced in version 9.2 and further improved with new functionality in version 9.3.
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, Puppet, Kafka, Zookeeper, Ganglia, Nagios, Memcached, JEE (jboss), Infinispan, Kryo, Hadoop/HDFS, Hibernate, PgBouncer, P/L proxy, PostgreSQL and Postgres-XC. 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 last two presentations will show how a single person can manage a large cluster remotely and scale the cluster to tens of thousands of nodes using a single command.
The presentation will be broken into four parts:
Introduction and Architecture Implementation (step-by-step) Monitoring and Management 1000 Node PostgreSQL Cluster Demo