Using Amazon Web Services for MySQL at Scale

Operations, Sutton South
Tutorial Please note: to attend, your registration must include Tutorials on Monday.
Average rating: ****.
(4.00, 5 ratings)

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:

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

Laine Campbell

Fastly

Laine Campbell is the senior director of production engineering at Fastly. An operations and database reliability veteran with 19 years of production experience under her belt, Laine has established her experience and knowledge while working with such systems and organizations as Travelocity, Obama for America, Activision, Apple, LiveJournal, Chegg, Adobe, Disney Mobile, Zendesk, and Okta. She has a passion for technical leadership and has served as leadership and strategy support for high-performing SRE, operations, and database organizations. Laine is the lead coauthor for Database Reliability Engineering from O’Reilly.

Sponsors

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Gloria Lombardo at (203) 381-9245 or glombardo@oreilly.com

Media Partner Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press and Media

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

Contact Us

View a complete list of Velocity contacts