MySQL patches by Codership

Xtradb cluster

Asked by Sebastian

Hi,

I've installed XtraDB Cluster however I didn't enable galera features for now - I'm just running without galera.

Could you please advise if there is any performance hit in comparison to plain Percona Server?

Regards

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL patches by Codership Edit question
Assignee:
No assignee Edit question
Solved by:
Seppo Jaakola
Solved:
Last query:
Last reply:
Revision history for this message
Best Seppo Jaakola (seppo-jaakola) said : 		#1

When Galera is not enabled (wsrep_provider is not specified), the server should behave as native Percona Server, and performance should be on same level. Technically there are a few 'if' statements in the code base to check if Galera should be used or not.

When Galera is enabled, you can couple several Percona Servers to form a synchronous multi-master cluster (Percona XtraDB Cluster). The cluster looks like a single Percona Server to the clients, but it accepts much more connections and has much higher transaction throughput than single Percona Server.

Performance gain depends largely on the profile of the SQL load and configuration. You should evaluate the Percona XtraDB Cluster with your application to see how it scales specifically in your use case.

You can use also Galera related mailing list: https://groups.google.com/group/codership-team or Percona XtraDB forum: in http://forum.percona.com to discuss about performance experiments with the community.

Revision history for this message
Sebastian (sebastian-seo) said : 		#2

Thanks Seppo Jaakola, that solved my question.