Percona XtraDB Cluster Tutorial
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.
MySQL Architect, Percona
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.
Software Engineer (PXC Lead), Percona
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.