Buy Percona ServicesBuy Now!

Percona XtraDB Cluster 5.6 GA release now available

 | January 30, 2014 |  Posted In: MySQL, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster

Percona is pleased to announce the first General Availability release of the leading open source High Availability solution for MySQL, Percona XtraDB Cluster 5.6 on January 30, 2014. Binaries are available from downloads area or from our software repositories. Percona XtraDB Cluster 5.6 Percona XtraDB Cluster 5.6 is an active/active cluster solution for High Availability (HA) MySQL […]

Read More

Percona Server: Thread Pool Improvements for Transactional Workloads

 | January 29, 2014 |  Posted In: Benchmarks, MySQL, Percona Server for MySQL

In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads. When we were evaluating MariaDB’s thread pool implementation, we observed that it improves scalability for AUTOCOMMIT […]

Read More

Percona Server: Improve Scalability with Percona Thread Pool

 | January 23, 2014 |  Posted In: Benchmarks, MySQL, Percona Server for MySQL

By default, for every client connection the MySQL server spawns a separate thread which will process all statements for this connection. This is the ‘one-thread-per-connection’ model. It’s simple and efficient until some number of connections N is reached. After this point performance of the MySQL server will degrade, mostly due to various contentions caused by […]

Read More

Percona Server 5.5.35-33.0 is now available

 | December 20, 2013 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.5.35-33.0 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.35, including all the bug fixes in it, Percona Server 5.5.35-33.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 […]

Read More

Percona Server 5.1.73-14.11 is now available

 | December 20, 2013 |  Posted In: Events and Announcements, Percona Server for MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.1.73-14.11 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.73, including all the bug fixes in it, Percona Server 5.1.73-14.11 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release […]

Read More

Percona Server 5.6.15-63.0 is now available

 | December 19, 2013 |  Posted In: Events and Announcements, Percona Server for MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.6.15-63.0 on December 19th, 2013 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.15, including all the bug fixes in it, Percona Server 5.6.15-63.0 is the current GA release in the Percona Server 5.6 series. All of Percona’s software is […]

Read More

Percona XtraBackup – A workaround to the failed assertion bug

 | November 27, 2013 |  Posted In: MySQL, Percona Remote DBA, Percona Server for MySQL, Percona Software, Percona XtraBackup

I recently conducted a test backup of my “master-slave” setup in my VirtualBox as I was migrating from Percona Server 5.6.12 to version 5.6.13-rel61.0 with Percona XtraBackup v2.2.0 rev. 4885. However, doing the backup on my slave, I encountered this problem:

This is related to a bug posted by my colleague George https://bugs.launchpad.net/percona-xtrabackup/+bug/1177201. While I was […]

Read More

Integrating pt-online-schema-change with a Scripted Deployment

 | November 21, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Server for MySQL, Percona Software

Recently, I helped a client that was having issues with deployments causing locking in their production databases.  At a high level, the two key components used in the environment were: Capistrano (scripted deployments) [website] Liquibase (database version control) [website] At a high level, they currently used a CLI call to Liquibase as a sub-task within […]

Read More

How Percona tested Percona Server 5.6: A world premiere in advanced testing

 | November 11, 2013 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL

8PM. One of the servers found a critical bug. Hop online and discuss, log bug. 10PM. Patch ready. 10:30PM. New build ready. 10:45PM. New RQG run initiated. This was by no means an uncommon sight during the months of testing that went into Percona Server 5.6, in fact it was commonplace. At a certain point, […]

Read More

Using per-query variable statements in Percona Server

 | November 7, 2013 |  Posted In: MySQL, Percona Server for MySQL

Percona Server has implemented per-query variable statement support in version 5.6.14-62.0. This feature provides the ability to set variable values only for a certain query, after execution of which the previous values will be restored. Per-query variable values can be set up with the following command:

Example: If we want to increase the sort_buffer_size […]

Read More