Very poor read performance after moving to Galera cluster


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.



check the new performance optimized pxc-5.7