Scaling Applications with Caching, Sharding and Replication

Peter Zaitsev (Percona Inc)
Location: Ballroom G
Average rating: ****.
(4.50, 4 ratings)

As MySQL Driven Application growths, requiring to handle larger and larger load with increasing database size there are several Architectural methods to get the performance you need

  • Caching Buffering and Queueing – using supplemental systems to reduce the amount of reads or writes MySQL Server needs to handle or change them from being synchronous (users waiting for response) to background
  • Replication is a technique to scale the read load by being able to read from multiple copies of your data
  • Functional Partitioning and Sharing are techniques to split your database in the smaller portions which can be served by individual servers or group of Servers

In this tutorial we will go into details of how to understand what solutions are best for your application, how to design architecture to take the best advantage of these approaches as well as go into practical details/tips/tricks implementing them in production.

Photo of Peter Zaitsev

Peter Zaitsev

Percona Inc

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.

Comments on this page are now closed.


Siby Nidhiry
04/12/2011 4:02pm PDT

Could you please provide the presentation on this Thanks

  • 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

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

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