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 is the Pacemaker script that run on the MySQL instance.
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 awesome: Clustrix is providing an open bar all evening, New Relic is providing all attendees with lunch and Fusion-io is [...]
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. Here are three leading mistakes that hurt many Rails applications. » Read the rest at Engine Yard’s blog. While you’re [...]
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. 39 were Percona employees and 21 were family and guests. Earlier Percona gatherings were held in Egypt (2007), Turkey (2008), [...]
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 data. I’ll be presenting a webinar for Percona on February 28 at 9am PST. I’ll describe several solutions for storing [...]
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 tools to find one’s way around a Solaris system and discover the system, get fundamental performance, configuration, and status information, [...]
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.
The performance problems caused by battery auto learning go many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least not with Dell RAID controllers, H700 and H800 have the same problem too. At the same time situation got worse as a lot more people [...]
Percona was working closely with Virident on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper “Scaling MySQL Deployments Efficiently Using Virident tachIOn Drives”, available from Virident website. It was done as part of our consulting practice, but all results and numbers are certified by Percona. I personally really enjoyed performance [...]
About a year ago, I started a study of emergency incidents that our customers filed with us. What I found was really surprising, and defied conventional wisdom. I learned a lot about preventing emergencies. I just published the outcome as a white paper, including checklists that you can use and modify for your own servers. [...]