All pages
Powered by GitBook
1 of 16

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

MySQL-wsrep 5.5 Release Notes

MySQL-wsrep 5.5.45-25.12 Release Notes

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.45 and Galera 3.12, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.45.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.42):

  • The SST password is no longer passed via the command line or visble in the error log or 'ps' output (codership/mysql-wsrep#141)

  • The xtrabackup SST script has been updated from the upstream source (codership/mysql-wsrep#143)

Notable bug fixes in MySQL-wsrep:

  • In mysqldump SST, the path to my.cnf file is passed to mysqldump, so that mysqldump-related options are read even if the my.cnf file is not in a default location (codership/mysql-wsrep#153)

New features and notable changes in MySQL 5.5.43 - 5.5.45:

  • Security: The key length for creating Diffie-Hellman keys has been increased from 512 to 2,048 bits

  • MySQL can now compile with OpenSSL 0.9.8e.

  • Miscelaneous fixes in InnoDB

Known issues with this release:

  • There is a package conflict on CentOS 6/7 which requires manual removal of postfix, mysql and mariadb libraries before installing mysql-wsrep

MySQL-wsrep 5.5.50-25.17 Release Notes

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.50 and Galera 3.17, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.50.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.49):

  • An experimental package for Ubuntu 16.04 Xenial is now available. Please see below for more information.

Notable bug fixes in MySQL-wsrep:

  • The server returned stale values from the NOW() function if transaction replay has happened on the connection.

Notable fixes in Oracle MySQL Community Edition 5.5.50:

  • Several potential buffer overflow issues have been fixed.

Known issues with this release:

  • If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

MySQL-wsrep 5.5.53-25.19 Release Notes

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.53 and Galera 3.19, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.53.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable fixes in Oracle MySQL Community Edition 5.5.53:

  • Incompatible change: The behavior of the --secure_file_priv option has changed and additional checks are performed on the value at server startup. The default value on most platforms has been changed to /var/lib/mysql-files. That directory is created at package installation time.

  • The yaSSL library has been upgraded to 2.4.2.

Known issues with this release:

  • If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

MySQL-wsrep 5.5.61-25.24 Release Notes

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.61 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.61.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

  • New configuration option wsrep_certification_rules to enable more relaxed certification rules for foreign key references on child table inserts. This option is effective only with Galera version 3.24 or higher (galera#491).

Resource leak in case of ROLLBACK TO SAVEPOINT followed by COMMIT has been fixed (mysql-wsrep#318).

  • FK constraint violation in applier after ALTER TABLE ADD FK was fixed by adding both parent and child table keys into ALTER TOI write set (mysql-wsrep#332).

  • Reminder: Changes to Repositories Structure

    With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

    How To Install

    Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

    Quirks for Ubuntu Xenial and 5.6

    Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

    One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

    MySQL-wsrep 5.5.62-25.25 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.62 and wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.62.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

    Note that Galera Cluster for MySQL 5.5.62 will be the last release of 5.5 series.

    Notable bug fixes in MySQL-wsrep:

    • Maximum variable length was increased to 4096 in order to work around wsrep_provider_options truncation if the provider options string contains long variable values (mysql-wsrep#348).

    Reminder: Changes to Repositories Structure

    With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

    How To Install

    Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

    Quirks for Ubuntu Xenial and 5.6

    Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

    One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

    MySQL-wsrep 5.5.47-25.14 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.47 and Galera 3.14, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.47.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

    Notable bug fixes in MySQL-wsrep 5.5.47:

    • Limit binlog recovery so that the wsrep position found from storage engines is not exceeded. This is required to have consistent position between wsrep position stored in innodb header and recovered binlog (codership/mysql-wsrep#226)

    MySQL-wsrep 5.5.46-25.13 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.46 and Galera 3.13, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.46.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

    New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.45):

    • A "compat" package is now provided to allow MySQL-wsrep to be installed without removing packages such as Postfix which depend on older MySQL versions

    Notable bug fixes in MySQL-wsrep:

    • IB atomic builtins are no longer used when compiling as they may cause the server to hang (codership/mysql-wsrep#221)

    • query cache is now compatible with wsrep_sync_wait (codership/mysql-wsrep#201)

    New features and notable changes in MySQL 5.5.46:

    • yaSSL was upgraded to version 2.3.8

    • Miscellaneous fixes in InnoDB

    MySQL-wsrep 5.5.49-25.16 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.49 and Galera 3.16, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.49.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

    Notable fixes in MySQL 5.5.49:

    • mysql client programs now support the --ssl-mode option that can be used to force encryption to be used

    MySQL-wsrep 5.5.42-25.11 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.42 and Galera 3.10, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.42.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

    New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.37):

    • The wsrep_causal_reads variable has been deprecated. A new variable, wsrep_sync_wait, has been introduced to allow causal checks to be specified separately for selects, updates and inserts (lp:1277053)

    • improved support for distributions based on the .deb package format, such as Ubuntu

    Notable bug fixes in MySQL-wsrep:

    • getifaddr() rather than ifconfig is used to detect the IP of the node, resulting in better compatibility with newer Linux distributions (codership/mysql-wsrep#45) .

    • Table administration commands such as CHECK TABLE are now replicated (lp:1046726)

    • Improvements in the replication of events (lp:1312618)

    • SST could fail with thousands of tables (lp:1294431)

    New features and notable changes in MySQL 5.5.38 - 5.5.42:

    • Support for SSL 2.0 and 3.0 has been disabled as they provide weak encryption;

    • Security issue with ALTER TABLE ... ADD FOREIGN KEY has been fixed (Bug #19471516, Bug #73650)

    • yaSSL was upgraded to version 2.3.7;

    • TRUNCATE TABLE is logged only when it executes successfully, in order to prevent inconsistencies. (Bug #17942050, Bug #71070)

    Known issues with this release:

    • There is a package conflict on CentOS 6/7 which requires manual removal of postfix, mysql and mariadb libraries before installing mysql-wsrep

    Character unique keys could cause false certification failures (lp:1314854)

  • Node aborts if it first joins a non-primary component (lp:1334606)

  • Rsync SST could fail if the rsync port is already taken (lp:1099783)

  • Various fixes in InnoDB and native MySQL replication;

    MySQL-wsrep 5.5.59-25.23 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.59 and wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.59.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

    Notable bug fixes in MySQL-wsrep:

    Reminder: Changes to Repositories Structure

    With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

    How To Install

    Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

    Quirks for Ubuntu Xenial and 5.6

    Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

    One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

    MySQL-wsrep 5.5.55-25.21 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.55 and Galera 3.21, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.55.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE, SLES and FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

    Notable bug fixes in MySQL-wsrep:

    • CREATE TABLE AS SELECT fixes (MW-322)

    • Fixes for certfication key generation in the presence of foreign key constraints (MW-369)

    Changes to Repositories Structure

    With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

    How To Install

    Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

    Quirks for Ubuntu Xenial and 5.6

    Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

    One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

    MySQL-wsrep 5.5.58-25.22 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.58 and Galera 3.22, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.58.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

    Notable bug fixes in MySQL-wsrep:

    • Avoid returning outdated values for wsrep_ready status variable (MW-384)

    • Crash during LOAD DATA for partition engine was fixed (MW-394)

    • Fixes to processing of foreign key cascades. (MW-402)

    • ACL checks are now enforced before replication for all DDL operations (MW-416)

    Reminder: Changes to Repositories Structure

    With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

    How To Install

    Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

    Quirks for Ubuntu Xenial and 5.6

    Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

    One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

    MySQL-wsrep 5.5.48-25.15 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.48 and Galera 3.15, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.48.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

    Notable fixes in MySQL 5.5.48:

    • yaSSL has been upgraded to version 2.3.9

    • DROP TABLE statements that contain non-regular characters may cause replication to break (MySQL Bug #77249)

    MySQL-wsrep 5.5.52-25.18 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.52 and Galera 3.18, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.52, including the fix for CVE-2016-6662.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

    Notable fixes in Oracle MySQL Community Edition 5.5.51, 5.5.52:

    • CVE-2016-6662. An authenticated remote user could leverage the mysqld_safe script to obtain elevated local privileges;

    • It was possible to write log files ending with .ini or .cnf that later could be parsed as option files. The general query log and slow query log can no longer be written to a file ending with .ini or .cnf. (Bug #24388753)

    • Privilege escalation was possible by exploiting the way REPAIR TABLE used temporary files. (Bug #24388746)

    • Multiple buffer overflows were fixed

    Known issues with this release:

    • If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

    MySQL-wsrep 5.5.54-25.20 Release Notes

    Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.54 and Galera 3.20, wsrep API version 25.

    This release incorporates all changes up to MySQL 5.5.54.

    Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE, SLES and FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

    This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

    Notable bug fixes in MySQL-wsrep:

    • Compilation with GCC 6 has been fixed (MW-332)

    Notable fixes in Oracle MySQL Community Edition 5.5.54:

    • Incompatible Change: The mysqld_safe script has been fortified against various security vulnerabilities

    Known issues with this release:

    • If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.