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?