Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

ProxySQL Tutorial

ProxySQL Tutorial

 24 April - 1:30 PM - 4:30 PM @ Ballroom D
Experience level: 
Intermediate
Duration: 
3 hours tutorial
Tracks:
Operations
Topics:
MySQL
High Availability
Sharding

Description

Overview: There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL. In this tutorial we will not only explain how ProxySQL can make your databases(MariaDB, MySQL, Percona Server) process more transactions than without a proxy we will show you how you can leverage ProxySQL to pre-qualify upgrades, test the impact of schema changes, perform seamless failovers, rewrite offensive canned queries on the fly, and help you install and configure the proxy to manage queries. Format: The attendees will be provided lab instances to run the examples. Target audience: Intermediate level MySQL DBAs familiar with the general concepts of replication. Some familiarity with linux/unix is helpful as well. Agenda: Concepts - How ProxySQL fits into a replicated topology - How ProxySQL helps you achieve High Availability and help you scale - How ProxySQL can actually improve the performance of databases. Implementation - Seamless switchover and failover using ProxySQL in front of standard MySQL replication - Query rewrites - Query statistics - Validate upgrades using ProxySQL mirroring

Speakers

Derek Downey's picture

Derek Downey

OSDB Practice Advocate, Pythian

Biography:

Derek Downey is the Practice Advocate for the OpenSource Database practice at Pythian, helping to align technical and business objectives for the company and for our clients. Derek loves automating MySQL, implementing visualization strategies and creating repeatable training environments.

René Cannaò's picture

René Cannaò

MySQL SRE, Dropbox / ProxySQL

Biography:

René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.

David Turner's picture

David Turner

Storage SRE, Uber

Biography:

David Turner joined Uber in 2016. He has more than 10 years experience working with databases such as Oracle and MySQL. He was drawn to MySQL because of his interest in database internals and a deeper understanding of systems architecture. With MySQL he has found he has more freedom to explore. His experience in working at larger shops such as Dropbox, Facebook, Pinterest, Sprint, and Zendesk has given him a strong understanding of scaling issues and of managing massive amounts of data and databases.

Share this talk