Apr
01
2016
--

Percona XtraBackup 2.4.2 is now available

Percona XtraBackup

Percona XtraBackup 2.4.2 Percona is glad to announce the first GA release of Percona XtraBackup 2.4.2 on April 1st, 2016. Downloads are available from our download site and from apt and yum repositories.

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:

Bugs Fixed:

  • When backup was taken on MariaDB 10 with GTID enabled, Percona XtraBackup didn’t store gtid_slave_pos in xtrabackup_slave_info but logged it only to STDERR. Bug fixed #1404484.
  • Backup process would fail if --throttle option was used. Bug fixed #1554235.

Release notes with all the bugfixes for Percona XtraBackup 2.4.2 are available in our online documentation. Bugs can be reported on the launchpad bug tracker.

Mar
24
2016
--

Want to be a superhero? Join the Database Performance Team!

database performance team

database performance team

Admit it, you’ve always wanted to fight danger, win battles and save the day! Who doesn’t? Do you want to be a superhero? Percona can show you how!

We don’t have any radioactive spiders or billionaire gadgets, but we do have our own team of superheroes dedicated to protecting your database performance: The Database Performance Team!

The Database Performance Team is comprised of our services experts, who work tirelessly every day to guarantee the performance of your database. Percona’s database services are some of our most valuable customer resources – besides the software itself. Whether it’s support, consulting, technical account managers, or remote DBAs, our support team is made up of superheroes that make sure your database is running at peak performance.

We want you to join us in the fight against poor performance. Join our Database Performance Team crew as part of the Database Street Team!

We’ll be introducing the members of our super group in the coming weeks. As we introduce the Database Performance Team (the “characters” below), we want you! We’ll be offering “missions” for you to complete: challenges, puzzles, or actions that get you prizes for success!

Your first mission: guess the identities of our secret team before we reveal them!

Mystery Character 1

Mystery Character 2

Mystery Character 3

Mystery Character 4

Mystery
Character 5

Mystery-1 Mystery-2 Mystery-3 Mystery-4 Mystery-5
Hint: Hint: Hint: Hint: Hint:
Funny, friendly, quick-witted, supporting, fast and courteous – but still able to get the job done with amazing competence. Computer-like smarts, instant recall, a counselor, able to understand a problem and the solution quickly. Technical, with clairvoyant foresight, with the knowledge and statistics to account for all issues, manages problems before they happen. Remotely all-seeing, a director, good at multi-tasking, adapts-on-the-fly, cool in a crisis. Insanely strong, can’t be stopped, hard to knock down, the product of rigorous testing, unlimited endurance.
Who am I? Who am I? Who am I? Who am I? Who am I?

Follow @Percona on Twitter and use the hashtag #DatabasePerformanceTeam to cast your guess on who any mystery character is. Correctly guess any of their names or roles, and the lucky winner gets their choice of our mystery T-shirt in either men’s or women’s style.

Stay tuned, as we reveal the identities of the Database Performance Team over the coming weeks! Respond with your guess in the comments below.

Join the ranks of the Database Street Team! Fun games, cool prizes – more info is coming soon!

Some facts:*

Gartner has estimated the average cost of downtime at $5,000 per minute!

Join The Database Performance Team today!

 

 

*Source: Global Cloud-based Database Market 2014-2018

Mar
18
2016
--

Percona Server for MongoDB 3.0.10-1.5 is now available

psmdb-logo

Percona Server for MongoDBPercona is pleased to announce the release of Percona Server for MongoDB 3.0.10-1.5 on March 18, 2016. Download the latest version from the Percona web site or the Percona Software Repositories.

Percona Server for MongoDB 3.0.10-1.5 is an enhanced, open source, fully compatible, highly scalable, zero-maintenance downtime database supporting the MongoDB v3.0 protocol and drivers. Based on MongoDB 3.0.10, it extends MongoDB with MongoRocks and PerconaFT storage engines, as well as features like external authentication and audit logging. Percona Server for MongoDB requires no changes to MongoDB applications or code.

NOTE: The MongoRocks storage engine is still under development. There is currently no officially released version of MongoRocks that can be recommended for production.


This release includes all changes from MongoDB 3.0.10MongoDB 3.0.10, and there are no additional improvements or new features on top of those upstream fixes.

Percona Server for MongoDB 3.0.10-1.5 release notes are available in the official documentation.

 

Mar
17
2016
--

Percona XtraBackup 2.3.4 is now available

Percona XtraBackup

Percona XtraBackup 2.3.4 for MySQL Percona is glad to announce the release of Percona XtraBackup 2.3.4 on March 17th, 2016. Downloads are available from our download site or Percona Software Repositories.

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.

This release is the current GA (Generally Available) stable release in the 2.3 series.

Bugs Fixed:

  • Percona XtraBackup didn’t respect variables stored in backup-my.cnf unless it was specified. One needed to specify --defaults-file=backup-my.cnf for options to be respected. Bug fixed #1527081.
  • Percona XtraBackup didn’t abort the backup if innobackupex --rsync completed with error. Bug fixed #1537256.
  • When backup was taken on MariaDB 10 with GTID enabled, Percona XtraBackup didn’t store gtid_slave_pos in xtrabackup_slave_info file but logged it only to STDERR. Bug fixed #1404484.
  • Percona XtraBackup was silently skipping extra arguments. Bug fixed #1533542 (Fungo Wang).
  • Percona XtraBackup refuses client connecting to server if it uses old (pre-4.1.1) protocol. To disable this check in order and to allow backing up servers with legacy passwords still set, new xtrabackup --skip-secure-auth option has been implemented. Bug fixed #1508450.

Release notes with all the bugfixes for Percona XtraBackup 2.3.4 are available in our online documentation. Bugs can be reported on the launchpad bug tracker.

Mar
15
2016
--

Percona Server 5.7.11-4 is now available

Percona Server

Percona Server 5.7.11-4Percona is glad to announce the GA release of Percona Server 5.7.11-4 on March 15, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.7.11, including all the bug fixes in it, Percona Server 5.7.11-4 is the current GA release in the Percona Server 5.7 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.7.11-4 milestone at Launchpad.

New Features:

Bugs Fixed:

  • If pid-file option wasn’t specified with the full path, Ubuntu/Debian sysvinit script wouldn’t notice if the server is actually running which would lead to timeout or in some cases even hang. Bug fixed #1549333.
  • Buffer pool may fail to remove dirty pages for a particular tablesspace from the flush list, as requested by, for example, DROP TABLE or TRUNCATE TABLE commands. This could lead to a crash. Bug fixed #1552673.
  • Audit Log Plugin worker thread may crash on write call writing fewer bytes than requested. Bug fixed #1552682 (upstream #80606).
  • Percona Server 5.7 systemd script now takes the last option specified in my.cnf if the same option is specified multiple times. Previously it would try to take all values which would break the script and server would fail to start. Bug fixed #1554976.
  • mysqldumpslow script has been removed because it was not compatible with Percona Server extended slow query log format. Please use pt-query-digest from Percona Toolkit instead. Bug fixed #856910.

Other bugs fixed: #1521120, #1549301 (upstream #80496), and #1554043 (upstream #80607).

Release notes for Percona Server 5.7.11-4 are available in the online documentation. Please report any bugs on the launchpad bug tracker .

Mar
11
2016
--

Percona Server for MongoDB 3.0.9-1.4 is now available

psmdb-logo

Percona Server for MongoDBPercona is pleased to announce the release of Percona Server for MongoDB 3.0.9-1.4 on March 11, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.

Percona Server for MongoDB is an enhanced, open source, fully compatible, highly scalable, zero-maintenance downtime database supporting the MongoDB v3.0 protocol and drivers. Based on MongoDB 3.0.9, it extends MongoDB with MongoRocks and PerconaFT storage engines, as well as features like external authentication and audit logging. Percona Server for MongoDB requires no changes to MongoDB applications or code.

 

NOTE: The MongoRocks storage engine is still under development. There is currently no officially released version of MongoRocks that can be recommended for production.


Bugs Fixed

  • PSMDB-56: Fixed failure of audit logging in debug build.

Other Improvements

Percona Server for MongoDB 3.0.9-1.4 release notes are available in the official documentation.

Mar
07
2016
--

Percona Toolkit 2.2.17 is now available

Percona Toolkit

Percona ToolkitPercona is pleased to announce the availability of Percona Toolkit 2.2.17.  Released March 7, 2016. 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 is the current GA (Generally Available) stable release in the 2.2 series. It includes multiple bug fixes for pt-table-checksum with better support for Percona XtraDB Cluster, various other fixes, as well as MySQL 5.7 general compatibility. Full details are below. Downloads are available here and from the Percona Software Repositories.

New Features:

  • Percona Toolkit 2.2.17 has implemented general compatibility with MySQL 5.7 tools, documentation and test suite.

Bugs Fixed:

  • Bug 1523685: pt-online-schema-change invalid recursion method where a comma was interpreted as the separation of two DSN methods has been fixed.
  • Bugs 1480719 and 1536305: The current version of Perl on supported distributions has implemented stricter checks for arguments provided to sprintf. This could cause warnings when pt-query-digest and pt-table-checksum were being run.
  • Bug 1498128: pt-online-schema-change would fail with an error if the table being altered has foreign key constraints where some start with an underscore and some don’t.
  • Bug 1336734: pt-online-schema-change has implemented new --null-to-non-null flag which can be used to convert NULL columns to NOT NULL.
  • Bug 1362942: pt-slave-restart would fail to run on MariaDB 10.0.13 due to a different implementation of GTID.
  • Bug 1389041: pt-table-checksum had a high likelihood to skip a table when row count was around chunk-size * chunk-size-limit value. To address this issue a new --slave-skip-tolerance option has been implemented.
  • Bug 1506748: pt-online-schema-change could not set the SQL_MODE by using the --set-vars option, preventing some use case schema changes that require it.
  • Bug 1523730: pt-show-grants didn’t sort the column-level privileges.
  • Bug 1526105: pt-online-schema-change would fail if used with –no-drop-old-table option after ten times. The issue would arise because there was an accumulation of tables that have already had their names extended, the code would retry ten times to append an underscore, each time finding an old table with that number of underscores appended.
  • Bug 1529411: pt-mysql-summary was displaying incorrect information about Fast Server Restarts for Percona Server 5.6.
  • pt-stalk shell collect module was confusing the new MySQL variable binlog_error_action with the log_error variable.

Details of the release can be found in the release notes and the 2.2.17 milestone at Launchpad. Bugs can be reported on the Percona Toolkit launchpad bug tracker.

Mar
07
2016
--

Percona Server 5.6.29-76.2 is now available

Percona Server

Percona Server 5.6.29-76.2Percona is glad to announce the release of Percona Server 5.6.29-76.2 on March 7, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.6.29, including all the bug fixes in it, Percona Server 5.6.29-76.2 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this is the latest release of our enhanced, drop-in replacement for MySQL. Complete details of this release can be found in the 5.6.29-76.2 milestone on Launchpad.

Bugs Fixed:

  • With Expanded Fast Index Creation enabled, DDL queries involving InnoDB temporary tables would cause later queries on the same tables to produce warnings that their indexes were not found in the index translation table. Bug fixed #1233431.
  • Package upgrade on Ubuntu would run mysql_install_db even though data directory already existed. Bug fixed #1457614.
  • Package upgrade on Ubuntu and Debian could reset the GTID number sequence when post-install script was restarting the service. Bug fixed #1507812.
  • Starting MySQL with systemctl would fail with timeout if the socket was specified with a custom path. Bug fixed #1534825.
  • Write-heavy workload with a small buffer pool could lead to a deadlock when free buffers are exhausted. Bug fixed #1521905.
  • libjemalloc.so.1 was missing from binary tarball. Bug fixed #1537129.
  • mysqldumpslow script has been removed because it was not compatible with Percona Server extended slow query log format. Please use pt-query-digest from Percona Toolkit instead. Bug fixed #856910.
  • When cmake/make/make_binary_distribution workflow was used to produce binary tarballs it would produce tarballs with mysql-... naming instead of percona-server-.... Bug fixed #1540385.
  • Cardinality of partitioned TokuDB tables became inaccurate after the changes introduced by TokuDB Background ANALYZE TABLE feature in Percona Server 5.6.27-76.0. Bug fixed #925.
  • Running the TRUNCATE TABLE while TokuDB Background ANALYZE TABLE is enabled could lead to a server crash once analyze job tries to access the truncated table. Bug fixed #938.
  • Added proper memory cleanup if for some reason a TokuDB table is unable to be opened from a dead closed state. This prevents an assertion from happening the next time the table is attempted to be opened. Bug fixed #917.

Other bugs fixed: #898, #1521120 and #1534246.

Release notes for Percona Server 5.6.29-76.2 are available in the online documentation. Please report any bugs on the launchpad bug tracker .

Mar
04
2016
--

Percona Server 5.5.48-37.8 is now available

Percona Server

Percona Server 5.5.48-37.8
Percona is glad to announce the release of Percona Server 5.5.48-37.8 on March 4, 2016. Based on MySQL 5.5.48, including all the bug fixes in it, Percona Server 5.5.48-37.8 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 5.5.48-37.8 milestone on Launchpad. Downloads are available here and from the Percona Software Repositories.

Bugs Fixed:

  • With Expanded Fast Index Creation enabled, DDL queries involving InnoDB temporary tables would cause later queries on the same tables to produce warnings that their indexes were not found in the index translation table. Bug fixed #1233431.
  • Package upgrade on Ubuntu would run mysql_install_db even though data directory already existed. Bug fixed #1457614.
  • Starting MySQL with systemctl would fail with a timeout if the socket was specified with a custom path. Bug fixed #1534825.
  • mysqldumpslow script has been removed because it was not compatible with Percona Server extended slow query log format. Please use pt-query-digest from Percona Toolkit instead. Bug fixed #856910.
  • When cmake/make/make_binary_distribution workflow was used to produce binary tarballs it would produce tarballs with mysql-... naming instead of percona-server-.... Bug fixed #1540385.

Other bugs fixed: #1521120 and #1534246.

Release notes for Percona Server 5.5.48-37.8 are available in our online documentation. Bugs can be reported on the launchpad bug tracker.

Feb
24
2016
--

Percona Server for MongoDB 3.0.8-1.3 is now available

psmdb-logo

Percona Server for MongoDBPercona is pleased to announce the release of Percona Server for MongoDB 3.0.8-1.3 on February 24, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.

Percona Server for MongoDB is an enhanced, open source, fully compatible, highly scalable, zero-maintenance downtime database supporting the MongoDB v3.0 protocol and drivers. Based on MongoDB 3.0.8, it extends MongoDB with MongoRocks and PerconaFT storage engines, as well as features like external authentication and audit logging. Percona Server for MongoDB requires no changes to MongoDB applications or code.

NOTE: MongoRocks has been labeled experimental. This is not related to any changes, it is a reminder that the storage engine is still under development. There is currently no officially released version of MongoRocks that can be recommended for production.


New Features

  • The mongod daemon now logs stdout and stderr to the following files:
    • On Debian and Ubuntu:
      • /var/log/mongodb/mongod.stdout
      • /var/log/mongodb/mongod.stderr
    • On RHEL and CentOS:
      • /var/log/mongo/mongod.stdout
      • /var/log/mongo/mongod.stderr

When you upgrade, make sure that the defaults file contains the STDOUT and STDERR variables.

On Debian and Ubuntu: /etc/default/mongod

On RHEL and CentOS: /etc/sysconfig/mongod

If you did not manually modify the defaults file before upgrading, the installer should correctly replace the defaults file. Otherwise, add the STDOUT and STDERR variables after you install the new version of Percona Server for MongoDB.

On Ubuntu 14.04 LTS (Trusty Tahr), the post-install script cannot correctly start mongod with stdout and stderr not directed to /dev/null. To enable the new logging functionality, you need to add the -C option to the start-stop-daemon command in /etc/init.d/mongod. The line that starts mongod should look similar to the following:

start-stop-daemon -C --background --start --quiet --pidfile $PIDFILEPATH

After you make necessary changes to the script, restart the daemon:

$ service mongod restart

  • Changed the default value of the processManagement.fork parameter in mongod.conf from false to true. This does not affect normal operation, only PID tracking in the OS.

Before upgrading on Debian 8 (“jessie”), Ubuntu 15.04 (Vivid Vervet), or Ubuntu 15.10 (Wily Werewolf), you will need to manually change the processManagement.fork parameter to true.

  • PSMDB-30: Added SELinux support for Red Hat Enterprise Linux and CentOS.

Bugs Fixed

  • PSMDB-39: Fixed issue that caused incorrect behavior during hot backup when the --logpathoption was set.

Percona Server for MongoDB 3.0.8-1.3 release notes are available in the official documentation.

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