Not the answer you need?
Register and ask your own question!

Percona XtraDB Cluster Analysis

abarotabarot ContributorCurrent User Role Novice
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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.