Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
May 4, 2015
Keep your MySQL data in sync when using Tungsten Replicator
MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human [...]
April 30, 2015
Optimizer hints in MySQL 5.7.7 – The missed manual
In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about [...]
April 28, 2015
Test your knowledge: Percona XtraDB Cluster (PXC) quiz
I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous [...]
April 27, 2015
Indexing 101: Optimizing MySQL queries on a single table
I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was [...]
April 21, 2015
Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!
MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, [...]
April 13, 2015
Staying ahead of MySQL operational problems at Percona Live
I’ve started my long journey from Florianópolis, Brazil, to Santa Clara, California and I type this words while waiting for [...]
April 9, 2015
pquery binaries with statically included client libs now available!
After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear [...]
April 8, 2015
More on OpenStack Live and our talks at OpenStack Summit Vancouver
In April and May, Percona will hold and participate in two OpenStack events: OpenStack Summit. Join our talks at these [...]
April 7, 2015
More on (transactional) MySQL metadata locks
Two years ago Ovais Tariq had explained in detail what kinds of problems existed before MySQL introduced metadata locks in [...]
March 18, 2015
Getting started guide for OpenStack contributors
So you want to contribute to OpenStack? I can help! For the last year or so I have been involved [...]
March 17, 2015
MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun
MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun This episode consists of 13 parts, and an [...]
March 17, 2015
Free MySQL QA & Bash/Linux Training Series
Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, I’d [...]
March 13, 2015
Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an [...]
March 3, 2015
Introducing ‘MySQL 101,’ a 2-day intensive educational track at Percona Live this April 15-16
Talking with Percona Live attendees last year I heard a couple of common themes. First, people told me that there [...]
March 2, 2015
Emulating MySQL roles with the Percona PAM plugin and proxy users
From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to [...]
February 27, 2015
3 handy tools to remove problematic MySQL processes
DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL [...]
February 26, 2015
Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?
If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or [...]
February 25, 2015
Using MySQL Event Scheduler and how to prevent contention
MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events [...]
February 20, 2015
How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) [...]
February 18, 2015
Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23)
Percona has submitted seven talks for the next Voting ends February 23, and if you aren’t already an OpenStack Foundation [...]