发布于 2014-07-21 23:24:06 | 256 次阅读 | 评论: 0 | 来源: 网友投递
Percona XtraDB Cluster 同步多主机复制插件
Percona XtraDB Cluster是针对MySQL用户的高可用性和扩展性解决方案，基于Percona Server 。其包括了Write Set REPlication补丁，使用Galera 2.0库，这是一个针对事务性应用程序的同步多主机复制插件。
Percona XtraDB Cluster 5.6.19-25.6 发布，此版本的二进制包现已提供下载，Ubuntu 14.04 LTS 用户也可以下载，安装和升级 Percona XtraDB Cluster 5.6 。
此版本是基于 Percona Server 5.6.19-67.0，包括 bug 修复，现在已经是稳定版本。
新特性：
Percona XtraDB Cluster now supports storing the Primary Component state to disk by setting the pc.recovery variable to true.
When joining the cluster, the state message exchange provides us with gcache seqno limits.
An asynchronous replication slave thread was stopped when the node tried to apply the next replication event while the node was in non-primary state.
Handling install message and install state message processing has been improved
A new wsrep_evs_repl_latency status variable has been implemented
Node consistency issues with foreign key grammar have been fixed.
Bugs 修复：
Fixed the race condition in Foreign Key processing that could cause assertion. Bug fixed #1342959.
The restart sequence in scripts/mysql.server would fail to capture and return if the start call failed to start the server. As a result, a restart could occur that failed upon start-up, and the script would still return 0 as if it worked without any issues. Bug fixed #1339894.
Updating a unique key value could cause the server to hang if a slave node had enabled parallel slaves. Bug fixed #1280896.
Percona XtraDB Cluster has implemented threadpool scheduling fixes. Bug fixed #1333348.
garbd was returning an incorrect return code, ie. when garbd was already started, return code was 0. Bug fixed #1308103.
rsync SST would silently fail on joiner when the rsync server port was already taken. Bug fixed #1099783.
When gmcast.listen_addr was configured to a certain address, the local connection point for outgoing connections was not bound to the listen address. This would happen if the OS has multiple interfaces with IP addresses in the same subnet. The OS would pick the wrong IP for a local connection point and other nodes would see connections originating from an IP address which was not listened to. Bug fixed #1240964.
An issue with re-setting galera provider (in wsrep_provider_options) has been fixed. Bug fixed #1260283.
Variable wsrep_provider_options couldn’t be set in runtime if no provider was loaded. Bug fixed #1260290.
Percona XtraDB Cluster couldn’t be built with Bison 3.0. Bug fixed #1262439.
MySQL wasn’t handling exceeding the max writeset size wsrep error correctly. Bug fixed #1270920.
Fixed the issue which caused a node to hang/fail when SELECTs/SHOW STATUS was run after FLUSH TABLES WITH READ LOCK was used on a node with wsrep_causal_reads set to 1 while there was a DML on other nodes. Bug fixed #1271177.
Lowest group communication layer (evs) would fail to handle the situation properly when a large number of nodes would suddenly start recognizing each other. Bugs fixed #1271918 and #1249805.
Percona XtraBackup SST would fail if the progress option was used with a large number of files. Bug fixed #1294431.
此版本包括 50 个 bug 修复，列表请看发行说明。
Percona XtraDB Cluster是针对MySQL用户的高可用性和扩展性解决方案，基于Percona Server 。其包括了Write Set REPlication补丁，使用Galera 2.0库，这是一个针对事务性应用程序的同步多主机复制插件。
Percona Server是MySQL的改进版本，使用 XtraDB 存储引擎，在功能和性能上较 MySQL 有着很显著的提升，如提升了在高负载情况下的 InnoDB 的性能，为 DBA 提供了一些非常有用的性能诊断工具，另外有更多的参数和命令来控制服务器行为。
Percona XtraDB Cluster提供了：
同步复制，事务可以在所有节点上提交。
多主机复制，你可以写到任何节点。
从（slave）服务器上的并行应用事件，真正的“并行复制”。
自动节点配置。
数据一致性，不再有未同步的从服务器。
Percona XtraDB Cluster完全兼容MySQL或Percona Server，包括：
数据兼容。Percona XtraDB Cluster可在由MySQL或Percona Server创建的数据库上使用。
应用程序兼容。如果要使用Percona XtraDB Cluster，你的应用程序基本不需要作任何更改。
此次发布的Percona XtraDB Cluster为alpha版本，不建议在实际工作中使用，开发者可据此了解Percona XtraDB Cluster的特性和功能。