EmergencyEMERGENCY? Get 24/7 Help Now!

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

 | May 1, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these […]

Read More

Distro Packages, Pre-built Binaries or Compile Your Own MySQL

 | September 4, 2012 |  Posted In: MySQL

I’ve been helping customers deploy and maintain MySQL (and variants) for the last couple of years and it has always been interesting to hear customer thoughts on how they want their servers installed. It has also been asked many times not only by our support and consulting customers, but widely from different forums and blogs […]

Read More

How To Test Your Upgrades – pt-upgrade

 | December 29, 2011 |  Posted In: Insight for DBAs

Upgrades are usually one of the biggest part of any database infrastructure maintenance. Even with enough planning something else can go bad after sending your production application to the version you’ve upgraded to. Let’s look at how one Percona Toolkit tool, pt-upgrade can help you identify what to expect and test your upgrades better which […]

Read More

When Does InnoDB Update Table Statistics? (And When It Can Bite)

 | October 6, 2011 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

An InnoDB table statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a table’s statistics or index cardinality becomes outdated, you might see queries which previously performed well suddenly show up on slow query log until InnoDB again updates the statistics. But when does InnoDB […]

Read More

SELECT UNION Results INTO OUTFILE

 | September 14, 2011 |  Posted In: Insight for Developers, MySQL

Here’s a quick tip I know some of us has overlooked at some point. When doing SELECT … UNION SELECT, where do you put the the INTO OUTFILE clause? On the first SELECT, on the last or somewhere else? The manual has the answer here, to quote: Only the last SELECT statement can use INTO […]

Read More