The tools we ve redesigned in Percona Toolkit recently have moved away from a legacy technique for operating on small numbers of rows at a time, towards a more reliable and predictable method. We call the old version chunking and the new version...
I got a really intriguing email today. As you might imagine, I get a lot of email offering to advertise, or trade links, or guest post, etc etc. But this is the most compelling one I ve ever gotten: I came across your blog...
Please join me tomorrow (Wednesday) for a webinar about the new version of pt-online-schema-change , Percona Toolkit s tool for performing nonblocking ALTER TABLE operations. Registration is free. I will explain how the tool works and cover some...
In the last few weeks I ve been caught off guard by the number of people who ve told me they have been evaluating Percona XtraDB Cluster ( link ), and even more surprised at the projects they re considering it for. Yesterday alone I spoke to...
I don t think there is a single good-quality MySQL init script for a Unix-like operating system. On Windows, there is the service facility, and I used to write Windows services. Based on that, I believe Windows has a pretty good claim to better...
It s nice that this happened again this year: The question I ask myself every year is, When am I going to get time to study all of these great blog posts? Further Reading: Schedule for...
What are your pet peeves about the tools? I have a lot. For example, pt-table-sync doesn t let me do things I want it to do sometimes (and I know it could be made to do them). Another example: pt-query-digest s tcpdump parser doesn t pay attention...
Oracle has released another huge batch of improvements to MySQL slated for MySQL 5.6. The pace of innovation in MySQL is accelerating rapidly and the improvements are impressive. I have not read all of the blog posts thoroughly yet, but I ve...
MySQL became wildly successful in part because it had built-in, simple replication. Sure, it had lots of interesting failure scenarios and was not great at first it is much better these days but it was nevertheless successful because there was a...
In case you live under a rock , the MySQL conference starts on Tuesday. There are 8 concurrent tracks of content. Aside from my own talks, here are the sessions I would most like to see. On Tuesday: Tutorial: Innodb and XtraDB Architecture and...