MySQL High Availability with Percona XtraDB Cluster 5.7
Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible Galera-based high availability (HA) solution. Whether you’re new to MySQL clustering technology, or experienced with Galera-based replication, this tutorial provides great insights into working with the software, including: • New and unique Features XtraDB Cluster 5.7, including Cluster Safe Mode, instrumentation with Performance Schema and extended support for encrypted tablespace in multi-master topology • Seamless integration with ProxySQL for better HA and read/write splitting • Improved security with native data at rest encryption and secure networking • Native integration with Docker, optimized for Container World • Monitoring with Percona Monitoring and Management (PMM) • Improved stability with many critical bug fixes and improved error messaging This tutorial will demonstrate how to set up XtraDB Cluster, complete with High Availability Proxy and Monitoring, as well as perform the most important management operations.
Peter 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. As CEO of Percona, Peter enjoys mixing business leadership with hands on technical expertise. Peter is co-author of High Performance MySQL published by O’Reilly, one of the most popular books on MySQL performance. Peter blogs regularly on Percona Database Performance Blog and speaks frequently at conferences. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.
Alok is a consultant at Percona, He joined the team in May of 2014. Alok previously worked as MySQL DBA for various product and service based companies in India. His career interests include High availability of databases, Innodb, server tuning, query optimization and automating DBA tasks using shell scripts.
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.