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
About the Authors
Alkin has extensive experience in enterprise relational databases working in various sectors for large corporations. With more then 20 years of industry experience he has acquired skills for managing large projects from ground up to production. For the past six 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 on 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 support for MySQL customers. Recently joined Percona's expert technical management team.