Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Percona XtraDB Cluster Tutorial

Percona XtraDB Cluster Tutorial

 24 April - 9:30 AM - 12:30 PM @ Ballroom B
Experience level: 
Beginner
Duration: 
6 hours tutorial
Tracks:
Operations
Developer
Topics:
MySQL
Fundamentals
High Availability

Description

Never used Percona XtraDB Cluster before? Are you a seasoned veteran, wanting to see the current hot stuff?Come join this full-day tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster. The first half of the tutorial will cover the basics of installation, bootstrap, IST, SST, Replication, Certification, DONOR selection, common-failure situations, and the garbd. The second half will cover more advanced topics like Cluster-Safe Mode, PFS (PXC-5.7 features), ProxySQL, PMM, setting up secure Galera Cluster, etc. We will also learn how to monitor Percona XtraDB Cluster instrumentation (mutexes, cond-variables, files, threads, etc) using PERFOMANCE_SCHEMA. Single click/step solutions to configuring PXC nodes in ProxySQL, configuration/monitoring in PMM, and how to setup SSL to secure cluster communications. This entire tutorial is extremely hands on. We will supply instances for you to work with on your own laptop. You will be executing all the commands along with your instructors to gain first-hand experience.

Speakers

Krunal Bauskar's picture

Krunal Bauskar

Software Engineer (PXC Lead), Percona

Biography:

Krunal joined Percona in September 2015. Before joining Percona he use to work as part of InnoDB team at MySQL/Oracle. He authored most of the temporary table revamp work besides lot of other features. In past he was associated with Yahoo! Labs researching on bigdata problems and database startup which is now part of Teradata. His interest mainly includes data-management at any scale and has been practicing it for more than decade now.

Matthew Boehm's picture

Matthew Boehm

MySQL Architect, Percona

Biography:

Matthew joined Percona in the fall of 2012 as a MySQL consultant. He quickly rose to Architect and became one of Percona's training instructors. His areas of knowledge include the traditional Linux/Apache/MySQL/PHP stack, memcached, MySQL Cluster (NDB), massive sharding topologies, PHP development and a bit of MySQL-C-API development.

Share this talk