Webinar on Scaling PostgreSQL on Amazon Web Services

Written by Marco Slot
October 9, 2015

Join us on October 14th at 10 am Pacific Time when I will present our latest webinar entitled "Scaling PostgreSQL on Amazon Web Services." PostgreSQL is often used in Amazon Web Services (AWS) deployments as a versatile data store. However, PostgreSQL on AWS does not naturally scale out like many cloud services. Fortunately, the pg_shard extension and CitusDB solutions from Citus Data provide a versatile toolkit for scaling out PostgreSQL on AWS. In this webinar, we will go through a number of different architectures for scaling out PostgreSQL on Amazon Web Services and demonstrate two different solutions:

  • A CitusDB cluster that uses EC2 instances for big data analytics
  • An experimental multi-master pg_shard cluster that stores data in multiple RDS instances

Both of these solution can be deployed with minimal effort using CloudFormation templates. We will also discuss various design options such as auto-scaling, the pros and cons of using EC2 versus RDS data nodes, and various kinds of storage. By the end of the webinar, you will have insight into how pg_shard and CitusDB can be integrated with different Amazon Web Services and be able to set up your own scalable PostgreSQL cluster.

Marco Slot

Written by Marco Slot

Former lead engineer for the Citus database engine at Microsoft. Speaker at Postgres Conf EU, PostgresOpen, pgDay Paris, Hello World, SIGMOD, & lots of meetups. Talk selection team member for Citus Con: An Event for Postgres. PhD in distributed systems. Loves mountain hiking.

@marcoslot marcocitus