Now that Percona XtraDB Cluster 5.6 is out in beta, I wanted to start a series talking about new features in Galera 3 and PXC 5.6. On the surface, Galera 3 doesn’t reveal a lot of new features yet, but there has been a lot of refactoring of the system in preparation for great new features in the future.
Galera vs MySQL options
wsrep_provider_options is a semi-colon separated list of key => value configurations that set low-level Galera library configuration. These tweak the actual cluster communication and replication in the group communication system. By contrast, other PXC global variables (like ‘wsrep%’) are set like other mysqld options and generally have more to do with MySQL/Galera …
[Read more]