EmergencyEMERGENCY? Get 24/7 Help Now!

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

 | March 24, 2016 |  Posted In: Events and Announcements, Percona Managed Services, Percona MySQL Consulting, Percona MySQL Support, Percona Software

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! […]

Read More

The cost of not properly managing your databases

 | April 6, 2015 |  Posted In: MySQL, Percona MySQL Consulting, Percona MySQL Support

Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist. Let’s look at some. The setup: […]

Read More

Is MySQL’s innodb_file_per_table slowing you down?

 | February 24, 2015 |  Posted In: Benchmarks, InnoDB, MySQL, Percona MySQL Consulting, Percona Server

MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many of you in the audience are responsible for running automated tests on your […]

Read More

MySQL ring replication: Why it is a bad option

 | October 7, 2014 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona MySQL Consulting

I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability. Alas, this is simply not true. Here is why. High Availability Having several […]

Read More

OpenStack users shed light on Percona XtraDB Cluster deadlock issues

 | September 11, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, OpenStack, Percona MySQL Consulting, Percona XtraDB Cluster

I was fortunate to attend an Ops discussion about databases at the OpenStack Summit Atlanta this past May as one of the panelists. The discussion was about deadlock issues OpenStack operators see with Percona XtraDB Cluster (of course this is applicable to any Galera-based solution). I asked to describe what they are seeing, and as […]

Read More

Using MySQL 5.6 Global Transaction IDs (GTIDs) in production: Q&A

 | September 5, 2014 |  Posted In: MySQL, MySQL Webinars, Percona MySQL Consulting

Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download the sides (free). We had a lot of questions during the […]

Read More

Migrating to Percona XtraDB Cluster 2014 edition: Sept. 10 MySQL webinar

 | September 3, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, Percona MySQL Consulting, Percona XtraDB Cluster

Join me online next week (September 10 at 10 a.m. PDT) for my live webinar on Migrating to Percona XtraDB Cluster.  This was a popular webinar that I gave a few years ago, so I’m doing it again with updates for Percona XtraDB Cluster 5.6 (PXC) and all the latest in the Galera world. This webinar […]

Read More

Using sysbench 0.5 for performing MySQL benchmarks

 | September 2, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, OpenStack, Percona MySQL Consulting, Percona MySQL Support

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including: fileio – File I/O test cpu – CPU performance test memory – […]

Read More

How to use MySQL Global Transaction IDs (GTIDs) in production

 | August 20, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, Percona MySQL Consulting

Reconfiguring replication has always been a challenge with MySQL. Each time the replication topology has to be changed, the process is tedious and error-prone because finding the correct binlog position is not straightforward at all. Global Transaction IDs (GTIDs) introduced in MySQL 5.6 aim at solving this annoying issue. The idea is quite simple: each […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.