Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 20, 2015
Percona Live Amsterdam discounted pricing ends July 26!
The Percona Live Data Performance Conference in Amsterdam is just two months away and it’s going to be an incredible [...]
July 16, 2015
Bypassing SST in Percona XtraDB Cluster with binary logs
In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster [...]
July 16, 2015
Bypassing SST in Percona XtraDB Cluster with incremental backups
Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their [...]
July 10, 2015
How to create a rock-solid MySQL database backup & recovery strategy
Have you ever wondered what could happen if your MySQL database goes down? Although it’s evident such a crash will [...]
July 9, 2015
Percona Live Europe 2015 conference, tutorials schedule now available
The conference and tutorial schedule for Percona Live Europe 2015, September 21-23 in Amsterdam, was published this morning and this [...]
July 9, 2015
Percona Server 5.6.25-73.1 is now available
Percona is glad to announce the release of Percona Server 5.6.25-73.1 on July 9, 2015. Download the latest version from the [...]
July 9, 2015
How to obtain the MySQL version from an FRM file
I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to [...]
July 7, 2015
MySQL QA Episode 3: How to use the debugging tool GDB
Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies” In this episode you’ll learn how to [...]
July 6, 2015
TOI wsrep_RSU_method in PXC 5.6.24 and up
I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_OSU_method changed somewhat. Prior to [...]
July 1, 2015
Percona Server 5.5.44-37.3 is now available
Percona is glad to announce the release of Percona Server 5.5.44-37.3 on July 1, 2015. Based on MySQL 5.5.44, including [...]
July 1, 2015
Percona Server 5.6.25-73.0 is now available
Percona is glad to announce the release of Percona Server 5.6.25-73.0 on July 1, 2015. Download the latest version from the [...]
July 1, 2015
Using Cgroups to Limit MySQL and MongoDB memory usage
Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but [...]
June 30, 2015
Playing with Percona XtraDB Cluster in Docker
Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports [...]
June 29, 2015
Practical MySQL Performance Optimization (July 2 webinar)
Applications often become impacted by MySQL performance. Optimization is the obvious solution but where to start? Join me on July [...]
June 25, 2015
Oracle license revenue and the MySQL ecosystem
Oracle was in the news recently with the story of its license revenue declining as much as 17% in the [...]
June 23, 2015
Percona XtraDB Cluster (PXC): How many nodes do you need?
A question I often hear when customers want to set up a production PXC cluster is: “How many nodes should [...]
June 19, 2015
Q&A: High availability when using MySQL in the cloud
Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst [...]
June 18, 2015
Getting EXPLAIN information from already running queries in MySQL 5.7
When a new version of MySQL is about to be released we read a lot of blog posts about the [...]
June 17, 2015
Update on the InnoDB double-write buffer and EXT4 transactions
IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, [...]
June 15, 2015
Speed up MySQL Queries GROUP BY with subselects
We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use [...]