PXC - Next Generation HA for MySQL; advanced MySQL query tuning

Outside of MySQL itself, no single company has more expertise about using the MySQL database reliably, and in high performance situations, than the folks at Percona.

In May they're coming to PhillyDB to school us on some of the finer points!

Part 1 - "PXC - Next Generation HA for MySQL"

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 presentation, 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 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 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.