发布于 2016-10-04 21:59:51 | 89 次阅读 | 评论: 0 | 来源: 网友投递
Percona XtraDB Cluster 同步多主机复制插件
Percona XtraDB Cluster是针对MySQL用户的高可用性和扩展性解决方案，基于Percona Server 。其包括了Write Set REPlication补丁，使用Galera 2.0库，这是一个针对事务性应用程序的同步多主机复制插件。
Percona XtraDB Cluster 5.6.32-25.17 发布了，二进制包已经提供下载，也已经提供在软件库。
Percona XtraDB Cluster 5.6.32-25.17基于以下项目：
Percona Server 5.6.32-78.1
Galera Replication library 3.17
Codership wsrep API version 25
该版本的更新主要是bug修复。具体如下：
Bug修复：
Fixed DONOR node getting stuck in Joined state after successful SST. Bugs fixed #1608680 and #1611728.
Removed protection against repeated calls of wsrep->pause() on the same node to allow parallel RSU operation.
Fixed error when running SHOW STATUS during group state update.
Setting the wsrep_auto_increment_control to OFF didn’t restore the original user set value.
Corrected the return code of sst_flush_tables() function to return a non-negative error code and thus pass assertion.
Using Percona XtraBackup as the SST method now requires Percona XtraBackup 2.3.5 or later.
Fixed memory leak and stale pointer due to stats not freeing when toggling the wsrep_provider variable.
Fixed failure of ROLLBACK to register wsrep_handler.
Improved rollback process to ensure that when a transaction is rolled back, any statements open by the transaction are also rolled back.
Fixed failure of symmetric encryption during SST.
Performing an SST would display the encryption key in the logs. It’s recommended to use encrypt-key-file instead of encrypt-key option.
Node transitioning to non-primary state with active ALTER TABLE could result in a crash.
Fixed setting of seqno in grastate.dat to -1 on clean shutdown.
Fixed failure of asynchronous TOI actions (like DROP) for non-primary nodes.
Removed the unused sst_special_dirs variable.
Added support of defaults-group-suffix for SST scripts.
Other low-level fixes and improvements for better stability
更多内容请查看发行说明
Percona XtraDB Cluster提供了：
同步复制，事务可以在所有节点上提交。
多主机复制，你可以写到任何节点。
从（slave）服务器上的并行应用事件，真正的“并行复制”。
自动节点配置。
数据一致性，不再有未同步的从服务器。
Percona XtraDB Cluster完全兼容MySQL或Percona Server，包括：
数据兼容。Percona XtraDB Cluster可在由MySQL或Percona Server创建的数据库上使用。
应用程序兼容。如果要使用Percona XtraDB Cluster，你的应用程序基本不需要作任何更改。