Percona XtraDB Cluster 5.5.39-25.11 发布

发布于 2014-09-05 23:54:17 | 218 次阅读 | 评论: 0 | 来源: 网友投递

Percona XtraDB Cluster 同步多主机复制插件

Percona XtraDB Cluster是针对MySQL用户的高可用性和扩展性解决方案，基于Percona Server 。其包括了Write Set REPlication补丁，使用Galera 2.0库，这是一个针对事务性应用程序的同步多主机复制插件。

Percona XtraDB Cluster 5.5.39-25.11 发布，此版本的二进制文件现已提供下载。

此版本是基于 Percona Server 5.5.39-36.0，包括其所有 bug 修复。此版本还基于 Galera Replicator 2.11 和 Codership wsrep API 25.11。Percona XtraDB Cluster 5.5.39-25.11 是当前 5.5 系列的稳定版本。

新特性：

New session variable wsrep_sync_wait has been implemented to control causality check. The old session variable wsrep_causal_reads is deprecated but is kept for backward compatibility (#1277053).
systemd integration with RHEL/CentOS 7 is now available for Percona XtraDB Cluster from our testing repository (#1342223).

Bugs 修复：

Percona XtraDB Cluster has implemented threadpool scheduling fixes. Bug fixed #1333348.
When gmcast.listen_addr was configured to a certain address, local connection point for outgoing connections was not bound to listen address. This would happen if OS has multiple interfaces with IP addresses in the same subnet, it may happen that OS would pick wrong IP for local connection point and other nodes would see connections originating from IP address which was not listened to. Bug fixed #1240964.
Client connections were closed unconditionally before generating SST request. Fixed by avoiding closing connections when wsrep is initialized before storage engines. Bug fixed #1258658.
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.
Node consistency issues with foreign keys have been fixed. This fix introduces two new variables: wsrep_slave_FK_checks and wsrep_slave_UK_checks. These variables are set to TRUE and FALSE respectively by default. They control whether Foreign Key and Unique Key checking is done for applier threads. Bug fixed #1260713.
When 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 then, subsequent SELECTs/SHOW STATUS didn’t hang earlier providing non-causal output, that has been fixed here. Bug fixed #1271177.
Lowest group communication layer (evs) would fail to handle the situation properly when big number of nodes would suddenly start to see each other. Bugs fixed #1271918 and #1249805.
Updating a unique key value could cause server hang if slave node has enabled parallel slaves. Bug fixed #1280896.
Fixed the events replication inconsistencies. Bug fixed #1312618.
Truncating the sorted version of multi-byte character conversion could lead to wsrep certification failures. Bug fixed #1314854.
wsrep_slave_threads was counted towards max_connections which could cause ERROR 1040 (HY000): Too many connections error. Bug fixed #1315588.
Leaving node was not set nonoperational if processed leave message originated from different view than the current one, which could cause other nodes to crash. Bug fixed #1323412 (#41).
garbd couldn’t be started with init script on RHEL 6.5. Bug fixed #1323652.
SST would fail when binlogs were in dedicated directory that’s located inside datadir. This bug was a regression introduced by bug fix for #1273368. Bug fixed #1326012.
GTID of TOI operations is now also synced to InnoDB tablespace in order to get consistent backups. Bug fixed #1329055.
mysql-debug (UNIV_DEBUG) is now distributed with binary tar.gz along with RPM and DEB packages. Bug fixed #1332073.
The restart sequence in scripts/mysql.server would fail to capture and return if the start call failed to start the server, so 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.
wsrep consistency check is now enabled for REPLACE ... SELECT as well. This was implemented because pt-table-checksum uses REPLACE .. SELECT during checksumming. Bug fixed #1343209.
A memory leak in wsrep_mysql_parse function has been fixed. Bug fixed #1345023.
SHOW STATUS was generating debug output in the error log. Bug fixed #1347818.
percona-xtradb-cluster-garbd-3.x package was installed incorrectly on Debian/Ubuntu. Bugs fixed #1360633 and #1334530.

更多内容请看在线文档。

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的特性和功能。

Percona XtraDB Cluster 5.5.39-25.11 发布

Percona XtraDB Cluster 同步多主机复制插件

后端技术

前端技术

数据库

热门框架

常用IDE

其他