Percona XtraDB Cluster: Failure Scenarios and their Recovery

Tuesday 12:20 PM - 1:10 PM

@ Jones

MySQL/MariaDBOpen Source Databases

50 minutes conference

Intermediate

Tracks:
Case Studies/Use cases, Operations

Percona XtraDB Cluster (a.k.a PXC) is multi-master high-availability clustering solution. Given the multi-master aspect, there are multi-guards to protect cluster from entering an inconsistent state. Most of these guards are configurable based on user environment but if they are not configured properly it could cause the cluster to stall, fail, error-out.

In this session, we would go over some of these failure scenarios like cluster entering non-primary due to network partitioning, cluster stall due to flow control, data inconsistency causing shutdown of node, common problem during initial catch up (a.k.a State Snapshot transfer (SST)), delay in purging of transaction, blocking DDL causing complete cluster to staff, misconfigured cluster, etc…

We would also discuss how to solve some of these problems or have to safely recover from these failures.


Speakers

Krunal Bauskar

Krunal Bauskar (Percona)

Software Engineer

Biography:

Krunal is PXC lead at Percona. He is responsible for day-to-day PXC development, what goes into PXC, bug fixes, releases, etc.. Before joining Percona he use to work as part of InnoDB team at MySQL/Oracle. He authored most of the temporary table revamp work, undo log truncate, atomic truncate and a lot of other features. In past he was associated with Yahoo! Labs researching on big data 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.


Alkin Tezuysal

Alkin Tezuysal (Percona)

Sr. Technical Manager

Biography:

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 eight 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.



Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA