Join Percona’s Chief Evangelist, Colin Charles as he presents Capacity Planning for Your Data Stores on Friday, December 15, 2017, at 7:00 am PST / 10:00 am EST (UTC-8).
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 theater show. Selling tickets requires that you don’t sell more tickets than you actually have. You want to load balance your queries, and shard your data stores. You may want to split reads and writes.
You need to determine where the system bottlenecks, but for that you need a baseline and to know what constitutes regular traffic patterns.
This is a perfect capacity planning example, because you don’t want to 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.”
This talk covers (but isn’t limited to) the following tools: Box Anemometer, innotop, the slow query log, Percona Toolkit (pt-query-digest), vmstat, Facebook’s Prophet and Percona Monitoring and Management (PMM).
Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team for MariaDB Server in 2009, worked in 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 many open source communities and speaks on the conference circuit.