Percona XtraDB Cluster Analysis


I have been hired as a consultant for a week in order to investigate a MySQL system which has been having performance issues. I arrived on the site to find out it’s a 5 node Percona XtraDB Cluster.

This has left me a bit miffed as to how to identify and diagnose issues with a Percona DB cluster.

What is the complete health checklist to identify and resolve issues on a cluster setup like this?

I can see candidates for indexing, am I correct in thinking i can create/analyse an index on any of the 5 nodes and the operation will be copied across to all 5 nodes?


Hello there, as per emails, here are some links:

There are a couple of webinars:

And a recent post from our Principal Support Engineer