War Stories and Solutions: Operational Fun with PostgreSQL and PostGIS in the Cloud

Andy Parsons (Obikosh.com)

As CTO of a successful high-growth startup, and in my new stealth company, I’ve seen my share of challenging scenarios keeping a very busy PostgreSQL-based business online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Others can probably learn from my battle scars!

Running multiple PostgreSQL instances on the EC2 cloud opens up many possibilities for scaling infrastructure, but also introduces a number challenges. From unpredictable disk i/o, to RAM constraints, vanishing instances and replication challenges, this talk aims to share real-world experiences and solutions with Postgres 8.* and 9.*

It covers the topic via a series of anecdotes from tiny team of developers supporting one of the biggest sites in the world (CNN.com); these stories range from humorous to horrifying, and there are valuable lessons for attendees running or contemplating a similar architecture with PostgreSQL.

Photo of Andy Parsons

Andy Parsons

Obikosh.com

Glutton for punishment! I’ve been leading development teams and technology-based businesses in NYC-based startups for the past 15 years, and working on the next one right now.

http://www.linkedin.com/in/andyparsons

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts