Using Amazon Web Services for MySQL at Scale Presentation

PalominoDB CEO Laine Campbell presented this class at the O'Reilly Velocity Conference, NYC Oct 2013. The class is broken into two videos and is a total of 85 minutes.

Click here for Part 1 - Click here for Part 2

Laine will explain the options for running MySQL at high volumes at Amazon Web Services, exploring options around database as a service, hosted instances/storages and all appropriate availability, performance and provisioning considerations using real-world examples from Call of Duty, Obama for America and many more.

Laine will show how to build highly available, manageable and performant MySQL environments that scale in AWS—how to maintain then, grow them and deal with failure. Some of the specific topics covered are:

  • Overview of RDS and EC2 -- pros, cons and usage patterns/antipatterns.
  • Implementation choices in both offerings: instance sizing, ephemeral SSDs, EBS, provisioned IOPS and advanced techniques (RAID, mixed storage environments, etc...)
  • Leveraging regions and availability zones for availability, business continuity and disaster recovery.
  • Scaling patterns including read/write splitting, read distribution, functional dataset -partitioning and horizontal dataset partitioning (aka sharding)
  • Palomino cluster tool (OSS) and Jetpants for building and managing large sharded MySQL in EC2
  • Configuration management, backup/recovery, monitoring and trending considerations.
  • Common failure modes -- AZ and Region failures, EBS corruption, EBS performance inconsistencies and more.
  • Cost structures, estimating and tracking cost.
  • Managing and mitigating cost with various instance and storage options.

Click here for Part 1
Click here for Part 2


The slides should be the same or almost the same as from Santa Clara. Find them here:

Mon, 11/04/2013 - 17:43

This was a really great presentation for someone like myself working in a small company using RDS to get up and rolling. I have run into most of the hurdles you mentioned and have managed to find ways around some of them.Will there be access to the slides from the presentation?

K. Wells
Fri, 11/01/2013 - 13:51


The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.
Website by Digital Loom