In this tutorial, we'll walk through over ten scenarios where things can get complex with your Percona XtraDB Cluster (PXC)/Galera installation. We will break things in these scenarios and then you'll have a chance to diagnose and fix them. Learn some of the most complex troubleshooting techniques.
- New node fails to join cluster
- Data sharing (Node catch up): SST, IST
- Cluster restart failures
- Data inconsistency
- Delayed purging of the gcache
- Network latency problems
- Blocking transactions
Alkin has extensive experience in enterprise relational databases working in various sectors for large corporations. With more than 20 years of industry experience, he has acquired skills for managing large projects from the ground up to production. For the past 10 years, he's been focusing on e-commerce, SaaS and MySQL technologies. He managed and architected database topologies for high volume site at eBay Intl. He has several years of experience in 24X7 support and operational tasks as well as improving database systems for major companies. He has led MySQL global operations team on Tier 1/2/3 support for MySQL customers. In 2016 he has joined Percona's expert technical management team.
? Open Source Database Evangelist
? Global Database Operations Expert
? Cloud InfrastructureArchitect AWS
? Inspiring Technical and Strategic Leader
? Creative Team Builder
? Speaker, Mentor, and Coach
? Outdoor Enthusiast
Daniel studied Electronic Engineering, but quickly becomes interested in all data things. He has worked as a DBA since 2007 for several companies and Working for Percona since 2014, he is the MySQL Tech Lead for the Managed Services department.
Tate joined Percona in June 2017 as a Remote MySQL DBA. He holds a Bachelors degree in Information Systems and Decision Strategies from LSU. He has 10+ years of experience working with MySQL and operations management.