Advanced Query Tuning for MySQL & Next Gen HA w/ Peter Zaitsev & Alexander Rubin

We're back! Tenable has been nice enough to offer us space to use in Columbia. Along with a location change, we're also changing the day we're doing it. Feedback on location, day, format, etc are always appreciated.

Agenda

6:30 - 7:00 - Food and socializing! 7:00 - 8:00 - Next Gen HA and Advanced Query Tuning for MySQL8:00 - 8:30 - Wrap-Up, Questions 8:30 - ???? - "After Meetup"

We normally head out to a local spot for drinks/food afterwards. It's a new area for us so suggestions on great local spots are welcome.

If you have any special food or drink requests/requirements, please feel to reach out to either Mark or myself and we'll try and accommodate you as best as we can. If you're coming from Baltimore and want to catch a ride out of the city, reach out to me and let me know!

Part 1 -"PXC - Next Generation HA for MySQL & Percona CEO Peter Zaitsev will talk about the Tokutek acquisition with audience Q&A"
Percona XtraDB Cluster (PXC) is a replacement for conventional MySQL master/slave architectures to eliminate replication lag and achieve a highly-available masterless cluster of MySQL servers. In this talk we'll examine:

• HA Solutions for MySQL
• What PXC Has to Offer
• Architecture Details
• When to PXC and when not to PXC

Part 2 - "Advanced MYSQL Query Tuning"
Tuning MySQL queries and indexes can significantly increase the performance of your application and decrease response times. In this webinar, Percona Principal Consultant Alexander Rubin will discuss advanced techniques for optimizing MySQL queries. Topics include:

1. GROUP BY and ORDER BY optimization
2. MySQL temporary tables and filesort
3. Using covered indexes to optimize your queries
4. Loose and tight index scans in MySQL

---

Peter Zaitsev, CEO of Percona

Peter Zaitsev co-founded Percona in 2006, assuming the role of CEO. Percona helps companies of all sizes maximize their success with MySQL. Percona was named to the Inc. 5000 in 2013. Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science.

---

Alexander Rubin, Percona Principal Consultant

Alexander Rubin has worked with MySQL since 2000 as a DBA and application developer. Before joining Percona as a principal consultant in 2013, he worked at MySQL AB, Sun Microsystems and Oracle. He has helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies. --
Percona Principal Consultant Alexander Rubin will talk on "Advanced Query Tuning