Percona XtraDB Cluster in a nutshell : Hands on tutorial!

High Availability
3 November 9:00am - 12:00pm @ Orchard 1

6 hours tutorial
-- This is a full day tutorial -- Percona XtraDB Cluster is a high availability and high scalability solution for MySQL clustering. Percona XtraDB Cluster integrates Percona Server with the Galera synchronous replication library in a single product package which enables you to create a cost-effective MySQL cluster. This tutorial will cover the following topics: - Migration from standard MySQL Master-Slave Architecture to PXC - Configuration differences between standard MySQLl and Xtradb Cluster - How to add a node and what does SST, IST mean ? How to use them ? - How to backup the cluster - How to monitor the cluster - 2 nodes servers- Why this isn't ideal but reasons and steps to setting it up anyway. - Galera Arbitrator: Defining what it is. - How to maintain the cluster - Setting up load balancing for Xtradb cluster - How to handle the cluster in the cloud - Tips and tricks - ... and if available cover PXC 5.6 with Galera 3 !! Attendees will be guided during the session and will perform all changes and tests in a VirtualBox environment. Attendees should bring a reasonably powerfull laptop able to handle at least 3 linux VM and have Virtualbox installed.


Senior Architect, Percona
Frédéric is an experienced Open Source consultant with expertise in infrastructure projects as well in development tracks and database administration. Frédéric is a believer of devops culture.
MySQL Practice Manager, Percona
Kenny is currently MySQL Practice Manager at Percona.
Head of Technical Account Management, Percona
Liz joined Percona after spending 5 years as a performance consultant for a University research lab in Belgium. During this time, she spent most of her days measuring and trying to reduce the impact of virtualized environments all across the software stack. Optimizing software became something of an obsession, and MySQL found its special place in her heart soon after. Liz has spoken and led tutorials on DBA best practices multiple times at past Percona Live events.