Hack MySQL

Archive for the ‘MySQL’ Category

Hiring: Perl programmer, PHP programmer, UI/UX consultant

without comments

I don’t get to say this often, but “I’m hiring” (at Percona):

I’ve been with Percona for about 5 years, so I can tell you: it’s probably the best company to work at: great pay, great benefits, great people, and truly driven by a desire to do right by customers and do good work.  What more can you ask for?  Of course, all these jobs are MySQL-related: Perl + MySQL, PHP + MySQL–maybe the UI/UX job less so, but still close enough.

Written by Daniel Nichter

April 19th, 2013 at 11:02 am

Posted in MySQL

Tagged with ,

Speaking at PLMCE 2013

without comments

Yes it’s still 4 months away, but some pre-selected sessions for Percona Live MySQL Conference & Expo 2013 have been released, and one is mine: Survey of Percona Toolkit: Command-line Tools for MySQL.  If you’ve not heard of Percona Toolkit, or have but have been putting off getting acquainted with it, attend my talk and I’ll get you off to a good start.  And if you didn’t know: I’m the lead PT developer, so I know the tools pretty well.

Written by Daniel Nichter

December 11th, 2012 at 6:39 pm

Posted in MySQL

Tagged with ,

PT BOF at PLMCE 2012

without comments

PT BOF at PLMCE 2012, or: I submitted a session for Percona Toolkit Birds of a Feather at Percona Live MySQL Conference & Expo 2012. You should BoF too; hard deadline is Monday, March 12th: submit a BoF session, or submit a Lightning Talk.

Written by Daniel Nichter

March 10th, 2012 at 12:27 pm

Posted in MySQL,Random

Tagged with , ,

Speaking at Percona Live MySQL Conference & Expo 2012

without comments

I’m speaking at Percona Live MySQL Conference & Expo 2012. My two talk are: Getting Started with Drizzle 7.1 and Verifying MySQL Replication Safely With pt-table-checksum 2.0. No, there’s no relationship between those topics; they’re just things I know well.

I’ve been stalking Drizzle for many years. When it went GA last year, I began hacking Drizzle, focusing on plugins which give it nearly all its functionality. Recently, I helped overhaul the configuration, administration, and plugin sections of the Drizzle docs. I’m also frequently poking around the plugins’ source code. Consequently, I know a lot about making Drizzle work. My talk with transfer the bulk of the best of that knowledge to you so that you can return to your place of work/hobby/world domination and start using Drizzle 7.1 yourself without having to resolve some of the mysteries I had to resolve by reading the source code.

As for pt-table-checksum 2.0, part of Percona Toolkit, it’s a complete re-write of the venerable pt-table-checksum 1.0 which worked very well for years but required some fine-tuning. Well, in certain cases it didn’t work as well, which required more fine-tuning. So Baron redesigned the entire tool (with help and feedback from a lot of people at Percona), and I programmed it. It works wonderfully, and most of the time you can “just run it” and it will Just Do The Right Thing, but you will nonetheless benefit if you come to this talk and poke and prod its internal with me.

If you’ve never been to this conference before (formerly it was just the “MySQL Conference & Expo”, but it’s always been, afaik, at this time and place), you should really come because it’s very enlightening. It’s the Super Bowl/World Cup/Wimbledon/etc. of MySQL conferences in my humble opinion.

Written by Daniel Nichter

January 26th, 2012 at 6:00 pm

Posted in Drizzle,MySQL

Tagged with

MySQL tools article

with 7 comments

Although I no longer maintain hackmysql.com, I still actively develop MySQL tools. An article I wrote, 10 essential MySQL tools for admin, was published today. I hope no one’s feelings are hurt if their tool isn’t in the list, but it was rather difficult to compile the list given that so many tools are either not actively developed, not tested, or not well documented. Given lag time between writing and publishing, I was not able to write about Yoshinori’s MHA or newer tools. And given length constraints, I was not able to write about more tools. In any case, the world of MySQL tools is alive and well.

Written by Daniel Nichter

August 1st, 2011 at 9:44 am

Posted in MySQL

Tagged with , , , ,