Oct
07
2014
--

Percona Server 5.6.21-69.0 is now available

href="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server.jpeg"> class="alignright size-thumbnail wp-image-22759" src="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server-150x150.jpeg" alt="Percona Server" width="150" height="150" />Percona is glad to announce the release of href="http://www.percona.com/software/percona-server">Percona Server 5.6.21-69.0 on October 7, 2014. Download the latest version from the title="Percona Server 5.6" href="http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.21-69.0/" >Percona web site or from the Percona href="http://www.percona.com/doc/percona-server/5.6/installation.html#using-percona-software-repositories">Software Repositories.

Based on MySQL rel="nofollow" href="http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-21.html" rel="nofollow">5.6.21, including all the bug fixes in it, Percona Server 5.6.21-69.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free. Complete details of this release can be found in the rel="nofollow" href="https://launchpad.net/percona-server/+milestone/5.6.21-69.0" rel="nofollow">5.6.21-69.0 milestone on Launchpad.

New Features:

  • href="http://www.percona.com/doc/percona-server/5.6/diagnostics/response_time_distribution.html#response-time-distribution">Response Time Distribution feature has been from Percona Server 5.5 as a plugin.
  • TokuDB storage engine package has been updated to version rel="nofollow" href="http://docs.tokutek.com/tokudb/tokudb-release-notes.html#tokudb-7-5-0" rel="nofollow">7.5.1.

Bugs Fixed:

  • href="http://www.percona.com/doc/percona-server/5.6/management/backup_locks.html#backup-locks">Backup Locks did not guarantee consistent SHOW SLAVE STATUS information with binary log disabled. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1358836" rel="nofollow">#1358836.
  • href="http://www.percona.com/doc/percona-server/5.6/management/audit_log_plugin.html#audit-log-plugin">Audit Log Plugin would rotate the audit log in middle of an audit message. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1363370" rel="nofollow">#1363370.
  • When the binary log is enabled on a replication slave, SHOW SLAVE STATUS performed under an active BINLOG lock could lead to a deadlock. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1372806" rel="nofollow">#1372806.
  • Fixed a memory leak in href="http://www.percona.com/doc/percona-server/5.6/diagnostics/scalability_metrics_plugin.html#scalability-metrics-plugin">Metrics for scalability measurement. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334570" rel="nofollow">#1334570.
  • Fixed a memory leak if href="http://www.percona.com/doc/percona-server/5.6/management/secure_file_priv_extended.html#secure-file-priv-extended">secure-file-priv option was used with no argument. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334719" rel="nofollow">#1334719.
  • LOCK TABLES FOR BACKUP is now incompatible with LOCK TABLES, FLUSH TABLES WITH READ LOCK, and FLUSH TABLES FOR EXPORT in the same connection. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1360064" rel="nofollow">#1360064.

Other bugs fixed: rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1361568" rel="nofollow">#1361568.

NOTE: Automatic upgrade for Percona Server with TokuDB on Debian/Ubuntu distribution will cause an error. In order to upgrade you’ll need to force the upgrade with “apt-get install -f” or remove the percona-server-tokudb-5.6 before upgrading and install it after the server package upgrade is done.

Release notes for Percona Server 5.6.21-69.0 are available in the  href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.21-69.0.html">online documentation. Please report any bugs on the rel="nofollow" href="https://bugs.launchpad.net/percona-server/+filebug" rel="nofollow">launchpad bug tracker

The post rel="nofollow" href="http://www.percona.com/blog/2014/10/07/percona-server-5-6-21-69-0-now-available/">Percona Server 5.6.21-69.0 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Oct
07
2014
--

Percona Server 5.5.40-36.1 is now available

href="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server.jpeg"> class="alignright size-thumbnail wp-image-22759" src="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server-150x150.jpeg" alt="Percona Server" width="150" height="150" /> /> Percona is glad to announce the release of href="http://www.percona.com/software/percona-server">Percona Server 5.5.40-36.1 on October 7, 2014. Based on rel="nofollow" href="http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-40.html" rel="nofollow">MySQL 5.5.40 href="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server.jpeg">, including all the bug fixes in it, Percona Server 5.5.40-36.1 is now the current stable release in the 5.5 series.

Percona Server is open-source and free. Details of the release can be found in the rel="nofollow" href="https://launchpad.net/percona-server/+milestone/5.5.40-36.1" rel="nofollow">5.5.34-36.1 milestone on Launchpad. Downloads are available href="http://www.percona.com/downloads/">here and from the href="http://www.percona.com/doc/percona-server/5.5/installation.html">Percona Software Repositories.

Bugs Fixed:

  • href="http://www.percona.com/doc/percona-server/5.5/management/audit_log_plugin.html#audit-log-plugin">Audit Log Plugin would rotate the audit log in middle of an audit message. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1363370" rel="nofollow">#1363370.
  • Fixed a memory leak in href="http://www.percona.com/doc/percona-server/5.5/diagnostics/scalability_metrics_plugin.html#scalability-metrics-plugin">Metrics for scalability measurement. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334570" rel="nofollow">#1334570.
  • Fixed a memory leak if href="http://www.percona.com/doc/percona-server/5.5/management/secure_file_priv_extended.html#secure-file-priv-extended">secure-file-priv option was used with no argument. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334719" rel="nofollow">#1334719.

Release notes for Percona Server 5.5.40-36.1 are available in our href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.40-36.1.html">online documentation. Bugs can be reported on the rel="nofollow" href="https://bugs.launchpad.net/percona-server/+filebug" rel="nofollow">launchpad bug tracker.

(Please also note that Percona Server 5.6 series is the latest General Availability series and current GA release is href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.21-69.0.html">5.6.21-69.0.)

The post rel="nofollow" href="http://www.percona.com/blog/2014/10/07/percona-server-5-5-40-36-1-now-available/">Percona Server 5.5.40-36.1 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Oct
06
2014
--

Percona XtraBackup 2.2.5 now available (free MySQL hot backup software)

href="http://www.percona.com/blog/wp-content/uploads/2013/01/Percona_XtraBackup.jpg"> class="alignright size-full wp-image-12668" src="http://www.percona.com/blog/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" alt="Percona XtraBackup for MySQL" width="229" height="87" /> Percona is glad to announce the release of Percona XtraBackup 2.2.5 on October 2, 2014. Downloads are available from our download site href="http://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.2.5/">here and href="http://www.percona.com/doc/percona-xtrabackup/2.2/installation.html">Percona Software Repositories.

href="http://www.percona.com/software/percona-xtrabackup">Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

New Features:

  • Percona XtraBackup has been rebased on MySQL 5.6.21.

Bugs Fixed:

  • The fix for bug rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1079700" rel="nofollow">#1079700 introduced a problem for users with huge numbers of InnoDB tablespaces, and the workaround of raising the open files limits didn’t work in all cases due to a limitation in the Linux kernel. A new innobackupex href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--close-files">--close-files option has been implemented to close the file handles once they are no longer accessed. NOTE: Using this option may result in a broken backup if DDL is performed on InnoDB tables during the backup procedure. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1222062" rel="nofollow">#1222062.
  • Fix for bug rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1206309" rel="nofollow">#1206309 introduced a regression in Percona XtraBackup 2.2.0 which caused Percona XtraBackup to fail to copy redo logs in random cases. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1365835" rel="nofollow">#1365835.
  • innobackupex href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--galera-info">--galera-info didn’t copy the last binlog file when it was taking a backup from server where href="http://www.percona.com/doc/percona-server/5.6/management/backup_locks.html">backup locks are supported. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1368577" rel="nofollow">#1368577.
  • xtrabackup binary would accept arguments that were not options, which could lead to unexpected results. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1367377" rel="nofollow">#1367377.
  • If innobackupex is run against MySQL 5.1 with built-in InnoDB, it will now suggest using Percona XtraBackup 2.0 or upgrading to InnoDB plugin, rather than just failing with the generic unsupported server version message. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1335101" rel="nofollow">#1335101.
  • Using the (deprecated) log parameter in mysqld section would cause backups to fail. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1347698" rel="nofollow">#1347698.
  • Percona XtraBackup now uses MySQL code to get the stack trace in case Percona XtraBackup crashes with a segmentation fault or an assertion failure. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/766305" rel="nofollow">#766305.
  • Attempt to use any of the following options without the href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--incremental">--incremental option now fails with an error message rather than creates a full backup: href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--incremental-lsn">--incremental-lsn, href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--incremental-basedir">--incremental-basedir, href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--incremental-history-name">--incremental-history-name, href="http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--incremental-history-uuid">--incremental-history-uuid. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1213778" rel="nofollow">#1213778.

Other bugs fixed: rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1367613" rel="nofollow">#1367613, rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1368574" rel="nofollow">#1368574, rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1370462" rel="nofollow">#1370462, rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1371441" rel="nofollow">#1371441, rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1373429" rel="nofollow">#1373429, rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1373984" rel="nofollow">#1373984, and rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1265070" rel="nofollow">#1265070.

Release notes with all the bugfixes for Percona XtraBackup 2.2.5 are available in our href="http://www.percona.com/doc/percona-xtrabackup/2.2/release-notes/2.2/2.2.5.html">online documentation. Bugs can be reported on the rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+filebug" rel="nofollow">launchpad bug tracker. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.

The post rel="nofollow" href="http://www.percona.com/blog/2014/10/06/percona-xtrabackup-2-2-5-now-available/">Percona XtraBackup 2.2.5 now available (free MySQL hot backup software) appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Sep
30
2014
--

Percona Toolkit 2.2.11 for MySQL is now available

href="http://www.percona.com/blog/wp-content/uploads/2013/03/Percona_ToolkitLogoVert_RGB.png"> class="alignright wp-image-13951" style="margin: 7px;" src="http://www.percona.com/blog/wp-content/uploads/2013/03/Percona_ToolkitLogoVert_RGB-300x249.png" alt="Percona Toolkit" width="180" height="149" />Percona is pleased to announce the availability of  href="http://www.percona.com/software/percona-toolkit">Percona Toolkit 2.2.11.  Released on Sept. 25, Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.

This release contains bug fixes for pt-query-digest, pt-mysql-summary, pt-stalk, as well as other tools and is the current GA (Generally Available) stable release in the 2.2 series. Downloads are available  href="http://www.percona.com/downloads/percona-toolkit/2.2.11/">here and from the  href="http://www.percona.com/doc/percona-server/5.5/installation.html">Percona Software Repositories.

Bugs Fixed:

  • Fixed bug rel="nofollow" href="https://bugs.launchpad.net/bugs/1262456" rel="nofollow">#1262456: href="http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html">pt-query-digest didn’t report host details when host was using skip-name-resolve option. Fixed by using the IP of the host instead of its name, when the hostname is missing.
  • Fixed bug rel="nofollow" href="https://bugs.launchpad.net/bugs/1264580" rel="nofollow">#1264580: href="http://www.percona.com/doc/percona-toolkit/2.2/pt-mysql-summary.html">pt-mysql-summary was incorrectly parsing key/value pairs in the href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-provider-index.html">wsrep_provider_options option, which resulted in incomplete my.cnf information.
  • Fixed bug rel="nofollow" href="https://bugs.launchpad.net/bugs/1318985" rel="nofollow">#1318985: href="http://www.percona.com/doc/percona-toolkit/2.2/pt-stalk.html">pt-stalk is now using SQL_NO_CACHE when executing queries for locks and transactions. Previously this could lead to situations where most of the queries that were waiting on query cache mutex were the pt-stalk queries (INNODB_TRX).
  • Fixed bug rel="nofollow" href="https://bugs.launchpad.net/bugs/1348679" rel="nofollow">#1348679: When using -- -p option to enter the password for href="http://www.percona.com/doc/percona-toolkit/2.2/pt-stalk.html">pt-stalk it would ask user to re-enter the password every time tool connects to the server to retrieve the information. New option href="http://www.percona.com/doc/percona-toolkit/2.2/pt-stalk.html#cmdoption-pt-stalk--ask-pass">--ask-pass has been introduced that can be used to specify the password only once.
  • Fixed bug rel="nofollow" href="https://bugs.launchpad.net/bugs/1368379" rel="nofollow">#1368379: A parsing error caused href="http://www.percona.com/doc/percona-toolkit/2.2/pt-summary.html">pt-summary ( specifically the report_system_info module) to choke on the “Memory Device” parameter named “Configured Clock Speed” when using dmidecode to report memory slot information.

Details of the release can be found in the  href="http://www.percona.com/doc/percona-toolkit/2.2/release_notes.html#v2-2-11-released-2014-09-25">release notes and the  rel="nofollow" href="https://launchpad.net/percona-toolkit/+milestone/2.2.11" rel="nofollow">2.2.11 milestone at Launchpad. Bugs can be reported on the Percona Toolkit rel="nofollow" href="https://bugs.launchpad.net/percona-toolkit/+filebug" rel="nofollow">launchpad bug tracker.

The post rel="nofollow" href="http://www.percona.com/blog/2014/09/30/percona-toolkit-2-2-11-for-mysql-is-now-available/">Percona Toolkit 2.2.11 for MySQL is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">Percona Performance Blog.

Sep
12
2014
--

Percona XtraBackup 2.2.4 is now available

href="http://www.percona.com/blog/wp-content/uploads/2013/01/Percona_XtraBackup.jpg"> class="alignright size-full wp-image-12668" src="http://www.percona.com/blog/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" alt="Percona XtraBackup for MySQL" width="229" height="87" /> Percona is glad to announce the release of Percona XtraBackup 2.2.4 on September 12th 2014. Downloads are available from our download site href="http://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.2.4/">here and href="http://www.percona.com/doc/percona-xtrabackup/2.2/installation.html">Percona Software Repositories.

href="http://www.percona.com/software/percona-xtrabackup">Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backup.

New Features:

  • Percona XtraBackup has implemented support for Galera GTID auto-recovery. Percona XtraBackup retrieves the GTID information, after backing up a server with href="http://www.percona.com/doc/percona-server/5.6/management/backup_locks.html">backup locks support, from the InnoDB trx header on recovery and creates the xtrabackup_galera_info during that stage.

Bugs Fixed:

  • Percona XtraBackup is now built with system zlib library instead of the older bundled one. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1108016" rel="nofollow">#1108016.
  • apt-get source was downloading older version of Percona XtraBackup. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1363259" rel="nofollow">#1363259.
  • innobackupex would ignore the innobackupex --databases without innobackupex --stream option and back up all the databases. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/569387" rel="nofollow">#569387.
  • rsync package wasn’t a dependency although it is required for the innobackupex --rsync option. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1259436" rel="nofollow">#1259436.
  • innobackupex --galera-info was checking only for non-capitalized wsrep_* status variables which was incompatible with MariaDB Galera Cluster 10.0. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1306875" rel="nofollow">#1306875.
  • Percona XtraBackup would crash trying to remove absent table from InnoDB data dictionary while preparing a partial backup. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1340717" rel="nofollow">#1340717.
  • Percona XtraBackup now supports MariaDB GTID. Bugs fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1329539" rel="nofollow">#1329539 and rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1326967" rel="nofollow">#1326967 (Nirbhay Choubey).
  • MariaDB 10.1 is now added to the list of supported servers. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1364398" rel="nofollow">#1364398.
  • Percona XtraBackup would fail to restore (copy-back) tables that have partitions with their own tablespace location. Bug fixed rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1322658" rel="nofollow">#1322658.

Other bugs fixed: rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1333570" rel="nofollow">#1333570, rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1326224" rel="nofollow">#1326224, and rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+bug/1181171" rel="nofollow">#1181171.

Release notes with all the bugfixes for Percona XtraBackup 2.2.4 are available in our href="http://www.percona.com/doc/percona-xtrabackup/2.2/release-notes/2.2/2.2.4.html">online documentation. Bugs can be reported on the rel="nofollow" href="https://bugs.launchpad.net/percona-xtrabackup/+filebug" rel="nofollow">launchpad bug tracker

The post rel="nofollow" href="http://www.percona.com/blog/2014/09/12/percona-xtrabackup-2-2-4-now-available/">Percona XtraBackup 2.2.4 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Sep
08
2014
--

How to calculate the correct size of Percona XtraDB Cluster’s gcache

href="http://www.percona.com/blog/wp-content/uploads/2014/09/XtraDB-Cluster1.jpg"> class="alignright size-full wp-image-25599" src="http://www.percona.com/blog/wp-content/uploads/2014/09/XtraDB-Cluster1.jpg" alt="How to calculate the correct size of Percona XtraDB Cluster's gcache" width="237" height="82" />When a write query is sent to href="http://www.percona.com/software/percona-xtradb-cluster" >Percona XtraDB Cluster all the nodes store the writeset on a file called gcache. By default the name of that file is galera.cache and it is stored in the MySQL datadir. This is a very important file, and as usual with the most important variables in MySQL, the default value is not good for high-loaded servers. Let’s see why it’s important and how can we calculate a correct value for the workload of our cluster.

What’s the gcache? /> When a node goes out of the cluster (crash or maintenance) it obviously stops receiving changes. When you try to reconnect the node to the cluster the data will be outdated. The joiner node needs to ask a donor to send the changes happened during the downtime.

The donor will first try to transfer an incremental (IST), that is, the writesets the cluster received while the node was down. The donor checks the last writeset received by the joiner and then checks local gcache file. If all needed writesets are on that cache the donor sends them to the joiner. The joiner applies them and that’s all, it is up to date and ready to join the cluster. Therefore, IST can only be achieved if all changes missed by the node that went away are still in that gcache file of the donor.

On the other hand, if the writesets are not there a full transfer would be needed (SST) using one of the supported methods, XtraBackup, Rsync or mysqldump.

In a summary, the difference between a IST and SST is the time that a node needs to join the cluster. The difference could be from seconds to hours. In case of WAN connections and large datasets maybe days.

That’s why having a correct gcache is important. It work as a circular log, so when it is full it starts to rewrite the writesets at the beginning. With a larger gcache a node can be out of the cluster more time without requiring a SST. My colleague Jay Janssen explains in more detail about href="http://www.percona.com/blog/2014/01/08/finding-good-ist-donor-percona-xtradb-cluster-5-6/">how IST works and how to find the right server to use as donor.

Calculating the correct size /> When trick is pretty similar to the one used to calculate the correct InnoDB log file size. We need to check how many bytes are written every minute. The variables to check are:

wsrep_replicated_bytes: Total size (in bytes) of writesets sent to other nodes.

wsrep_received_bytes: Total size (in bytes) of writesets received from other nodes.

mysql> show global status like 'wsrep_received_bytes';
show global status like 'wsrep_replicated_bytes';
select sleep(60);
show global status like 'wsrep_received_bytes';
show global status like 'wsrep_replicated_bytes';
+----------------------+----------+
| Variable_name        | Value    |
+----------------------+----------+
| wsrep_received_bytes | 83976571 |
+----------------------+----------+
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_replicated_bytes | 0     |
+------------------------+-------+
[...]
+----------------------+----------+
| Variable_name        | Value    |
+----------------------+----------+
| wsrep_received_bytes | 90576957 |
+----------------------+----------+
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| wsrep_replicated_bytes | 800   |
+------------------------+-------+

Therefore:

Bytes per minute:

(second wsrep_received_bytes – first wsrep_received_bytes) + (second wsrep_replicated_bytes – first wsrep_replicated_bytes)

(90576957 – 83976571) + (800 – 0) = 6601186 bytes or 6 MB per minute.

Bytes per hour:

6MB * 60 minutes = 360 MB per hour of writesets received by the cluster.

If you want to allow one hour of maintenance (or downtime) of a node, you need to increase the gcache to that size. If you want more time, just make it bigger.

The post rel="nofollow" href="http://www.percona.com/blog/2014/09/08/calculate-correct-size-percona-xtradb-clusters-gcache/">How to calculate the correct size of Percona XtraDB Cluster’s gcache appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Sep
05
2014
--

Percona XtraDB Cluster 5.5.39-25.11 is now available

href="http://www.percona.com/blog/wp-content/uploads/2013/02/XtraDB-Cluster.jpg"> class="alignright size-full wp-image-12836" src="http://www.percona.com/blog/wp-content/uploads/2013/02/XtraDB-Cluster.jpg" alt="Percona XtraDB Cluster 5.5.39-25.11" width="237" height="82" />Percona is glad to announce the new release of href="http://www.percona.com/software/percona-xtradb-cluster">Percona XtraDB Cluster 5.5 on September 5th 2014. Binaries are available from href="http://www.percona.com/downloads/">downloads area or from our href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/installation.html">software repositories.

Based on Percona Server href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.39-36.0.html">5.5.39-36.0 including all the bug fixes in it, rel="nofollow" href="https://github.com/codership/galera/issues?milestone=1&page=1&state=closed" rel="nofollow">Galera Replicator 2.11, and on rel="nofollow" href="https://launchpad.net/wsrep-group/+milestone/5.5.38-25.11" rel="nofollow">Codership wsrep API 25.11, Percona XtraDB Cluster 5.5.39-25.11 is now the current 5.5 General Availability release. All of Percona‘s software is open-source and free, and all the details of the release can be found in the rel="nofollow" href="https://launchpad.net/percona-xtradb-cluster/+milestone/5.5.39-25.11" rel="nofollow">5.5.39-25.11 milestone at Launchpad.

New Features:

  • New session variable href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_sync_wait">wsrep_sync_wait has been implemented to control causality check. The old session variable href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_causal_reads">wsrep_causal_reads is deprecated but is kept for backward compatibility ( rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1277053">#1277053).
  • rel="nofollow" rel="nofollow" href="http://freedesktop.org/wiki/Software/systemd/">systemd integration with RHEL/CentOS 7 is now available for Percona XtraDB Cluster from our testing repository ( rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1342223">#1342223).

Bugs Fixed:

  • Percona XtraDB Cluster has implemented threadpool scheduling fixes. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1333348">#1333348.
  • When href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-provider-index.html#gmcast.listen_addr">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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1240964">#1240964.
  • Client connections were closed unconditionally before generating SST request. Fixed by avoiding closing connections when wsrep is initialized before storage engines. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1258658">#1258658.
  • Issue with re-setting galera provider (in href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_provider_options">wsrep_provider_options) has been fixed. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1260283">#1260283.
  • Variable href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_provider_options">wsrep_provider_options couldn’t be set in runtime if no provider was loaded. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1260290">#1260290.
  • Node consistency issues with foreign keys have been fixed. This fix introduces two new variables: href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_slave_FK_checks">wsrep_slave_FK_checks and href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_slave_UK_checks">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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1260713">#1260713.
  • When FLUSH TABLES WITH READ LOCK was used on a node with href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_causal_reads">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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1271177">#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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1271918">#1271918 and rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1249805">#1249805.
  • Updating a unique key value could cause server hang if slave node has enabled parallel slaves. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1280896">#1280896.
  • Fixed the events replication inconsistencies. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1312618">#1312618.
  • Truncating the sorted version of multi-byte character conversion could lead to wsrep certification failures. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1314854">#1314854.
  • href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_slave_threads">wsrep_slave_threads was counted towards max_connections which could cause ERROR 1040 (HY000): Too many connections error. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1315588">#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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1323412">#1323412 ( rel="nofollow" rel="nofollow" href="https://github.com/codership/galera/issues/41">#41).
  • garbd couldn’t be started with init script on RHEL 6.5. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1323652">#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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1273368">#1273368. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1326012">#1326012.
  • GTID of TOI operations is now also synced to InnoDB tablespace in order to get consistent backups. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1329055">#1329055.
  • mysql-debug (UNIV_DEBUG) is now distributed with binary tar.gz along with RPM and DEB packages. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1332073">#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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1339894">#1339894.
  • wsrep consistency check is now enabled for REPLACE ... SELECT as well. This was implemented because href="http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html">pt-table-checksum uses REPLACE .. SELECT during checksumming. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1343209">#1343209.
  • A memory leak in wsrep_mysql_parse function has been fixed. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1345023">#1345023.
  • SHOW STATUS was generating debug output in the error log. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1347818">#1347818.
  • percona-xtradb-cluster-garbd-3.x package was installed incorrectly on Debian/Ubuntu. Bugs fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1360633">#1360633 and rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1334530">#1334530.

Release notes for Percona XtraDB Cluster href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/release-notes/Percona-XtraDB-Cluster-5.5.39-25.11.html">5.5.39-25.11 are available in our href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/index.html">online documentation along with the href="http://www.percona.com/doc/percona-xtradb-cluster/5.5/installation.html">installation instructions.

Help us improve our software quality by reporting any bugs you encounter using our rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+filebug" rel="nofollow">bug tracking system. As always, thanks for your continued support of Percona!

The post rel="nofollow" href="http://www.percona.com/blog/2014/09/05/percona-xtradb-cluster-5-5-39-25-11-now-available/">Percona XtraDB Cluster 5.5.39-25.11 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Sep
01
2014
--

Percona XtraDB Cluster 5.6.20-25.7 is now available

href="http://www.percona.com/blog/wp-content/uploads/2013/02/XtraDB-Cluster.jpg"> class="alignright size-full wp-image-12836" src="http://www.percona.com/blog/wp-content/uploads/2013/02/XtraDB-Cluster.jpg" alt="Percona XtraDB Cluster 5.6.20-25.7" width="237" height="82" />Percona is glad to announce the new release of href="http://www.percona.com/software/percona-xtradb-cluster">Percona XtraDB Cluster 5.6 on September 1st 2014. Binaries are available from href="http://www.percona.com/downloads/">downloads area or from our href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html">software repositories.

Based on Percona Server href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.20-68.0.html">5.6.20-68.0 including all the bug fixes in it, rel="nofollow" href="https://github.com/codership/galera/issues?milestone=1&page=1&state=closed" rel="nofollow">Galera Replicator 3.7, and on rel="nofollow" href="https://launchpad.net/wsrep-group/+milestone/5.6.20-25.6" rel="nofollow">Codership wsrep API 25.7, Percona XtraDB Cluster 5.6.20-25.7 is now the current General Availability release. All of Percona‘s software is open-source and free, and all the details of the release can be found in the rel="nofollow" href="https://launchpad.net/percona-xtradb-cluster/+milestone/5.6.20-25.7" rel="nofollow">5.6.20-25.7 milestone at Launchpad.

New Features:

  • 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 ( rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1277053">#1277053).
  • rel="nofollow" rel="nofollow" href="http://freedesktop.org/wiki/Software/systemd/">systemd integration with RHEL/CentOS 7 is now available for Percona XtraDB Cluster from our testing repository ( rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1342223">#1342223).

Bugs Fixed:

  • Running START TRANSACTION WITH CONSISTENT SNAPSHOT, mysqldump with --single-transaction or mydumper with disabled binlog would lead to a server crash. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1353644">#1353644.
  • percona-xtradb-cluster-garbd-3.x package was installed incorrectly on Debian/Ubuntu. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1360633">#1360633.
  • Fixed netcat in SST script for CentOS 7 nmap-ncat. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1359767">#1359767.
  • TO isolation was run even when wsrep plugin was not loaded. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1358681">#1358681.
  • The error from net read was not handled in native MySQL mode. This would cause duplicate key error if there was unfinished transaction at the time of shutdown, because it would be committed during the startup recovery. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1358264">#1358264.
  • The netcat in garbd init script has been replaced with nmap for compatibility in CentOS 7. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1349384">#1349384.
  • SHOW STATUS was generating debug output in the error log. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1347818">#1347818.
  • Incorrect source string length could lead to server crash. This fix allows maximum of 3500 bytes of key material to be populated, longer keys will be truncated. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1347768">#1347768.
  • 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 rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1343209">#1343209.
  • Client connections were closed unconditionally before generating SST request. Fixed by avoiding closing connections when wsrep is initialized before storage engines. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1258658">#1258658.
  • Session-level binlog_format change to STATEMENT is now allowed to support pt-table-checksum. A warning (to not use it otherwise) is also added to error log.

Other bug fixes: rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1280270">#1280270.

Release notes for Percona XtraDB Cluster href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/release-notes/Percona-XtraDB-Cluster-5.6.20-25.7.html">5.6.20-25.7 are available in our href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/index.html">online documentation along with the href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html">installation and href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/upgrading_guide_55_56.html">upgrade instructions.

Help us improve our software quality by reporting any bugs you encounter using our rel="nofollow" href="https://bugs.launchpad.net/percona-xtradb-cluster/+filebug" rel="nofollow">bug tracking system. As always, thanks for your continued support of Percona!

The post rel="nofollow" href="http://www.percona.com/blog/2014/09/01/percona-xtradb-cluster-5-6-20-25-7-now-available/">Percona XtraDB Cluster 5.6.20-25.7 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Aug
29
2014
--

Percona Server 5.6.20-68.0 is now available

href="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server.jpeg"> class="alignright size-thumbnail wp-image-22759" src="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server-150x150.jpeg" alt="Percona Server" width="150" height="150" />Percona is glad to announce the release of href="http://www.percona.com/software/percona-server">Percona Server 5.6.20-68.0 on August 29, 2014. Download the latest version from the title="Percona Server 5.6" href="http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.20-68.0/" >Percona web site or from the Percona href="http://www.percona.com/doc/percona-server/5.6/installation.html#using-percona-software-repositories">Software Repositories.

Based on MySQL rel="nofollow" href="http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html" rel="nofollow">5.6.20, including all the bug fixes in it, Percona Server 5.6.20-68.0 is the current GA release in the Percona Server 5.6 series. All of Percona’s software is open-source and free. Complete details of this release can be found in the rel="nofollow" href="https://launchpad.net/percona-server/+milestone/5.6.20-68.0" rel="nofollow">5.6.20-68.0 milestone on Launchpad.

New Features:

  • Percona Server has implemented the MySQL 5.7 SHOW SLAVE STATUS NONBLOCKING syntax for href="http://www.percona.com/doc/percona-server/5.6/reliability/show_slave_status_nolock.html#show-slave-status-nolock">Lock-Free SHOW SLAVE STATUS feature. The existing SHOW SLAVE STATUS NOLOCK is kept as a deprecated alias and will be removed in Percona Server 5.7. There were no functional changes for the feature.
  • Percona Server href="http://www.percona.com/doc/percona-server/5.6/management/audit_log_plugin.html#audit-log-plugin">Audit Log Plugin now supports JSON and CSV formats. The format choice is controlled by href="http://www.percona.com/doc/percona-server/5.6/management/audit_log_plugin.html#audit_log_format">audit_log_format variable.
  • Percona Server href="http://www.percona.com/doc/percona-server/5.6/management/audit_log_plugin.html#audit-log-plugin">Audit Log Plugin now supports href="http://www.percona.com/doc/percona-server/5.6/management/audit_log_plugin.html#streaming-to-syslog">streaming the audit log to syslog.
  • TokuDB storage engine package has been updated to version 7.1.8.

Bugs Fixed:

  • Querying href="http://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#INNODB_CHANGED_PAGES">INNODB_CHANGED_PAGES table with a range condition START_LSN > x AND END_LSN < y would lead to a server crash if the range was empty with x greater than y. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1202252">#1202252 (Jan Lindström and Sergei Petrunia).
  • SQL statements of other connections were missing in the output of SHOW ENGINE INNODB STATUS, in LATEST DETECTED DEADLOCK and TRANSACTIONS sections. This bug was introduced by href="http://www.percona.com/doc/percona-server/5.6/management/statement_timeout.html#statement-timeout">Statement Timeout patch in Percona Server href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.13-61.0.html#5.6.13-61.0">5.6.13-61.0. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1328824">#1328824.
  • Some of TokuDB distribution files were missing in the TokuDB binary tarball. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1338945">#1338945.
  • With href="http://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#changed-page-tracking">XtraDB changed page tracking feature enabled, queries from the href="http://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#INNODB_CHANGED_PAGES">INNODB_CHANGED_PAGES could read the bitmap data whose write was in still progress. This would cause the query to fail with an ER_CANT_FIND_SYSTEM_REC and a warning printed to the server error log. The workaround has been to add an appropriate END_LSN-limiting condition to the query. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1193332">#1193332.
  • mysqld-debug was missing from Debian packages. This regression was introduced in Percona Server href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.16-64.0.html#5.6.16-64.0">5.6.16-64.0. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1290087">#1290087.
  • Fixed a memory leak in href="http://www.percona.com/doc/percona-server/5.6/flexibility/slowlog_rotation.html#slowlog-rotation">Slow Query Log Rotation and Expiration. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1314138">#1314138.
  • The audit log plugin would write log with XML syntax errors when OLD and NEW formats were used. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1320879">#1320879.
  • Combination of href="http://www.percona.com/doc/percona-server/5.6/management/log_archiving.html#log-archiving">Log Archiving for XtraDB, href="http://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#changed-page-tracking">XtraDB changed page tracking, and small InnoDB logs could hang the server on the bootstrap shutdown. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1326379">#1326379.
  • --tc-heuristic-recover option values were broken. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334330">#1334330 (upstream rel="nofollow" rel="nofollow" href="http://bugs.mysql.com/bug.php?id=70860">#70860).
  • If the bitmap directory has a bitmap file sequence with a start LSN of one file less than a start LSN of the previous file, a debug build would assert when queries were run on href="http://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#INNODB_CHANGED_PAGES">INNODB_CHANGED_PAGES table. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1342494">#1342494.

Other bugs fixed: rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1337247">#1337247, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1350386">#1350386, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1208371">#1208371, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1261341">#1261341, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1151723">#1151723, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182050">#1182050, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182068">#1182068, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182072">#1182072, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1184287">#1184287, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1280875">#1280875, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1338937">#1338937, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334743">#1334743, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1349394">#1349394, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182046">#1182046, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182049">#1182049, and rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1328482">#1328482 (upstream rel="nofollow" rel="nofollow" href="http://bugs.mysql.com/bug.php?id=73418">#73418).

Release notes for Percona Server 5.6.20-68.0 are available in the  href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.20-68.0.html">online documentation. Please report any bugs on the rel="nofollow" href="https://bugs.launchpad.net/percona-server/+filebug" rel="nofollow">launchpad bug tracker.

The post rel="nofollow" href="http://www.percona.com/blog/2014/08/29/percona-server-5-6-20-68-0-now-available/">Percona Server 5.6.20-68.0 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Aug
29
2014
--

Percona Server 5.5.39-36.0 is now available

href="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server.jpeg"> class="alignright size-thumbnail wp-image-22759" src="http://www.percona.com/blog/wp-content/uploads/2014/05/percona_server-150x150.jpeg" alt="Percona Server" width="150" height="150" />Percona is glad to announce the release of  href="http://www.percona.com/software/percona-server">Percona Server 5.5.39-36.0 on August 29, 2014 (Downloads are available  href="http://www.percona.com/downloads/">here and from the  href="http://www.percona.com/doc/percona-server/5.5/installation.html">Percona Software Repositories). Based on  rel="nofollow" href="http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-39.html" rel="nofollow">MySQL 5.5.39, including all the bug fixes in it, Percona Server 5.5.39-36.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the  rel="nofollow" href="https://launchpad.net/percona-server/+milestone/5.5.39-36.0" rel="nofollow">5.5.39-36.0 milestone at Launchpad.

New Features:

  • Percona Server href="http://www.percona.com/doc/percona-server/5.5/management/audit_log_plugin.html#audit-log-plugin">Audit Log Plugin now supports JSON and CSV formats. The format choice is controlled by href="http://www.percona.com/doc/percona-server/5.5/management/audit_log_plugin.html#audit_log_format">audit_log_format variable.
  • Percona Server href="http://www.percona.com/doc/percona-server/5.5/management/audit_log_plugin.html#audit-log-plugin">Audit Log Plugin now supports href="http://www.percona.com/doc/percona-server/5.5/management/audit_log_plugin.html#streaming-to-syslog">streaming the audit log to syslog.

Bugs Fixed:

  • Querying href="http://www.percona.com/doc/percona-server/5.5/management/changed_page_tracking.html#INNODB_CHANGED_PAGES">INNODB_CHANGED_PAGES with a range condition START_LSN > x AND END_LSN < y would lead to a server crash if the range was empty with x greater than y. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1202252">#1202252 (Jan Lindström and Sergei Petrunia).
  • With href="http://www.percona.com/doc/percona-server/5.5/management/changed_page_tracking.html#changed-page-tracking">XtraDB changed page tracking feature enabled, queries from the href="http://www.percona.com/doc/percona-server/5.5/management/changed_page_tracking.html#INNODB_CHANGED_PAGES">INNODB_CHANGED_PAGES could read the bitmap data whose write was in still progress. This would cause the query to fail with an ER_CANT_FIND_SYSTEM_REC and a warning printed to the server error log. The workaround has been to add an appropriate END_LSN-limiting condition to the query. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1346122">#1346122.
  • mysqld-debug was missing from Debian packages. This regression was introduced in Percona Server href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.0.html#5.5.36-34.0">5.5.36-34.0. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1290087">#1290087.
  • Fixed a memory leak in href="http://www.percona.com/doc/percona-server/5.5/flexibility/slowlog_rotation.html#slowlog-rotation">Slow Query Log Rotation and Expiration. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1314138">#1314138.
  • The audit log plugin would write log with XML syntax errors when OLD and NEW formats were used. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1320879">#1320879.
  • A server built with system OpenSSL support, such as the distributed Percona Server binaries, had SSL-related memory leaks. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334743">#1334743 (upstream rel="nofollow" rel="nofollow" href="http://bugs.mysql.com/bug.php?id=73126">#73126).
  • If the bitmap directory has a bitmap file sequence with a start LSN of one file less than a start LSN of the previous file, a debug build would assert when queries were run on href="http://www.percona.com/doc/percona-server/5.5/management/changed_page_tracking.html#INNODB_CHANGED_PAGES">INNODB_CHANGED_PAGES table. Bug fixed rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1342494">#1342494.

Other bugs fixed: rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1337324">#1337324, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1151723">#1151723, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182050">#1182050, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182072">#1182072, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1280875">#1280875, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1182046">#1182046, rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1328482">#1328482 (upstream rel="nofollow" rel="nofollow" href="http://bugs.mysql.com/bug.php?id=73418">#73418), and rel="nofollow" rel="nofollow" href="https://bugs.launchpad.net/percona-server/+bug/1334317">#1334317 (upstream rel="nofollow" rel="nofollow" href="http://bugs.mysql.com/bug.php?id=73111">#73111).

Release notes for Percona Server 5.5.39-36.0 are available in our href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.39-36.0.html">online documentation. Bugs can be reported on the rel="nofollow" href="https://bugs.launchpad.net/percona-server/+filebug" rel="nofollow">launchpad bug tracker.

The post rel="nofollow" href="http://www.percona.com/blog/2014/08/29/percona-server-5-5-39-36-0-now-available/">Percona Server 5.5.39-36.0 is now available appeared first on rel="nofollow" href="http://www.percona.com/blog">MySQL Performance Blog.

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com