Percona XtraDB Cluster Analysis

Hi,

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?

Thanks

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

There are a couple of webinars: https://www.percona.com/resources/mysql-webinars/performance-monitoring-and-troubleshooting-percona-xtradb-cluster
https://www.percona.com/resources/webinars/percona-xtradb-cluster-reference-architecture

And a recent post from our Principal Support Engineer https://www.percona.com/blog/2018/05/30/mysql-test-framework-percona-xtradb-cluster/