Very poor read performance after moving to Galera cluster

Hi,

We have recently moved to a Galera Cluster and have noticed that query performance has dropped rather radically. I have to admit that I am extremely new to Galera and hence I have not grokked all nuances of the parameters one can pass to it. My setup is a rather basic one and I have, for instance, read that perhaps I should look into gcache size.

So, have read this I realise that there must be more of which I am embarrassingly aware and I would very much appreciate any tips as to how to improve my performance.

Cheers,

K

check the new performance optimized pxc-5.7

[url]https://www.percona.com/blog/2017/04/19/performance-improvements-percona-xtradb-cluster-5-7-17/[/url]