Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 20, 2014
Percona Replication Manager (PRM) now supporting 5.6 GTID
Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of [...]
January 17, 2014
keepalived with reader and writer VIPs for Percona XtraDB Cluster
This is a followup to Jay Janssen’s October post, “HaProxy would. keepalived is a simple load balancer with HA capabilities, [...]
January 13, 2014
Webinars: Common (but deadly) MySQL mistakes
On January 22 I’ll be presenting the first of a series of two new webinars focusing on avoiding common MySQL [...]
January 10, 2014
The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB
Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even [...]
January 9, 2014
Percona Cloud Tools: Making MySQL performance easy
One of our primary focuses at Percona is performance. Let me make some statements on what is “performance.” In doing [...]
January 6, 2014
The ARCHIVE Storage Engine – does it do what you expect?
Sometimes there is a need for keeping large amounts of old, rarely used data without investing too much on expensive [...]
January 3, 2014
Multiple column index vs multiple indexes with MySQL 5.6
A question often comes when talking about indexing: should we use multiple column indexes or multiple indexes on single columns? Peter [...]
January 2, 2014
How to recover table structure from .frm files with MySQL Utilities
MySQL table structures are stored in .frm files and in the InnoDB Data Dictionary. Sometimes, usually in data recovery issues, [...]
![[ERROR] mysqld: Sort aborted: Server shutdown in progress](https://www.percona.com/blog/wp-content/uploads/2023/03/3d-modern-background-with-design-extruding-cubes.jpg)
December 30, 2013
[ERROR] mysqld: Sort aborted: Server shutdown in progress
Recently, one of our support customers faced this: “[ERROR] mysqld: Sort aborted: Server shutdown in progress.” At first it would [...]
December 26, 2013
2 cases for MySQL server overload
Your MySQL server is overloaded. You see hundreds of running queries in the SHOW PROCESSLIST taking many seconds to run, [...]
December 24, 2013
Renaming database schema in MySQL
One of the routine tasks for a DBA is MySQL renaming database schemas, and as such MySQL added a command [...]
December 13, 2013
Seconds_Behind_Master fluctuating wildly? Check for events caught in a loop
Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds [...]
December 12, 2013
One more InnoDB gap lock to avoid
While troubleshooting deadlocks for a customer, I came around an interesting situation involving InnoDB gap locks. For a non-INSERT write [...]
December 10, 2013
Q&A: Geographical disaster recovery with Percona Replication Manager
My December 4 webinar, “Geographical disaster recovery with Percona Replication Manager (PRM),” gave rise to a few questions. The recording of [...]
December 4, 2013
Multi-Data Center MySQL with Continuent Tungsten: Dec. 11 webinar
I’m looking forward to next week’s MySQL webinar with Robert Hodges, CEO of Continuent. We’ll be speaking on the topic [...]
December 3, 2013
INFORMATION_SCHEMA: innodb_stats_on_metadata and slow queries
INFORMATION_SCHEMA is usually the place to go when you want to get facts about a system (how many tables do [...]
November 28, 2013
MySQL Error: Too many connections
Editor’s Note: Follow up to this post here MySQL 5.7 Performance Tuning After Installation. We have always received quite a [...]
November 26, 2013
Geographical disaster recovery with PRM: Register for Dec. 4 Webinar
Downtime caused by a disaster is probable in your application’s lifetime. While caused by a large-scale geographical disaster, cyber attack, [...]
November 21, 2013
Integrating pt-online-schema-change with a Scripted Deployment
Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high [...]
November 20, 2013
How to add VIPs to Percona XtraDB Cluster or MHA with Pacemaker
It is a rather frequent problem to have to manage Virtual IP addresses (VIPs) with a Percona XtraDB Cluster (PXC) [...]