Percona XtraDB Cluster Analysis

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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

2

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

There are a couple of webinars: [URL]Percona Webinars: Open Source Database Learning
[URL]Upcoming Webinars

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