PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Christophe Pettus |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2013-05-24 |
| Room | MRT 256 |
| Start time | 16:30 |
| Duration | 01:00 |
| Info | |
| ID | 535 |
| Event type | Lecture |
| Track | DBA |
| Language used for presentation | English |
Automated PostgreSQL Scaling on AWS
Managing Your Thundering Herd
Amazon Web Services provides tremendous tools and techniques for scaling services up and down in response to planned or experienced load. However, too many systems are configured to use AWS as an equipment-rental facility, which wastes money and does not take advantage of AWS' unique properties. We'll talk about how to build systems that flex-scale using AWS tools.
Among the topics we'll cover are:
-- Designing your application and database for sharding and scaling. -- Planning for load spikes. -- Detecting load fluctuations. -- Scripting your scale-up/scale-down functionality. -- Scaling the database vs scaling the application front-end. -- Monitoring and fault-recovery.
The demonstrations will be specifically about AWS, but the techniques can also be applied to other cloud environments.