Dec 15, 2017
 Percona Technical Webinars
  Colin Charles

Capacity Planning for your Data Stores

In this webinar, Colin uses a ticket sales website that does “normal” events like an M2M concert, but also occasionally also sells tickets to the Harry Potter theatre show.
Selling tickets requires that you don’t sell more tickets than you actually have. You want to load balance your queries. You want to shard your data stores. You may want to split reads and writes. You need to determine where the system bottlenecks, so for that you need a baseline and know what regular traffic patterns are.

This is a perfect capacity planning example, because you don’t want buy servers that do nothing for much of the time. Examples like this are why the cloud is so popular today. While the focus of this talk is not to help plan for the application server loads and caches, the data layer is definitely a hard thing to tackle.

Beyond that, we will talk about storage capacity planning for OLTP and data warehousing uses.

From metrics collection, you can plan your requirements. Couple this with the elastic nature of clouds, and you should never have an “error establishing database connection”.

The tools covered in this talk include (but are not limited to): Box Anemometer, innotop, the slow query log, Percona Toolkit (pt-query-digest), vmstat, Facebook’s Prophet and Percona Monitoring and Management (PMM).



About the Author

Colin Charles

Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team of MariaDB Server in 2009, and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He’s well known within open source communities in APAC, and has spoken at many conferences. Experienced technologist, well known in the open source world for work that spans nearly two decades within the community. Pays attention to emerging technologies from an integration standpoint. Prolific speaker at many industry-wide conferences delivering talks and tutorials with ease. Interests: application development, systems administration, database development, migration, Web-based technologies. Considered expert in Linux and Mac OS X usage/administration/roll-out’s. Specialties: MariaDB, MySQL, Linux, Open Source, Community, speaking & writing to technical audiences as well as business stakeholders.