Emergency

Monthly Archives: February 2011

Percona Server 5.5.8 Beta Release

It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout …

Read More
 

High availability for MySQL on Amazon EC2 – Part 6 – Publishing server location

This post is the sixth of a series that started here. From the previous posts of this series, we now have an HA MySQL service running on EC2. We now need to find a way …

Read More
 

High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script

This post is the fifth of a series that started here. From the previous posts of this series, we now have nearly everything setup, only a few pieces are missing. One of the missing pieces …

Read More
 

Percona Live is on Wednesday – thank you to all our sponsors

Percona Live is in only two days away – and we’ve managed to completely sell out (something I predicted earlier).  Before I go into details, I want to thank three sponsors who have been absolutely …

Read More
 

3 Common Rails + MySQL Mistakes

This is a cross-posting of an article we wrote for Engine Yard: Rails makes database interaction so simple that it’s easy to forget that the database isn’t always happy with what Rails does to it. …

Read More
 

Team Percona back from Cancun, Mexico

All Perconians are back home after spending January 19-25 near Cancun, Mexico for our fourth annual company meeting. A total of 60 people gathered at the Grand Palladium Resort & Spa on the Maya Riviera. …

Read More
 

My-Shhhh!-QL

I gave a talk entitled “How to Index Massive Data Sets Quickly” at the Morrelly Homeland Security Center. The event was hosted at the Long Island Forum for Technology (LIFT) and was jointly supported by …

Read More
 

Moving Subtrees in Closure Table Hierarchies

Many software developers find they need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. Sometimes it’s tricky to do this in SQL and still run efficient queries against the …

Read More
 

Basic performance and diagnostic tools on Solaris

Much has been written about tools to inspect Linux systems, and much has been written about Solaris’s Big Important Tools such as DTrace. But I don’t recall seeing much in the MySQL blogs about basic …

Read More
 

Percona Server and XtraBackup weekly news, February 12th

Here’s the second installment of the weekly Percona Server news roundup. There’s no team or personnel-related news, so let’s dive right in.

Read More