Where do you use Maatkit in real life?
I note that Maatkit has been deemed unworthy to mention on Wikipedia. Someone emailed me the deletion log today:
20:13, 10 July 2008 Djsasso (Talk | contribs) deleted “Maatkit” ‎ (WP:PROD, reason was ‘Non-notable application, single primary source’.)
I have never been a very big promoter. I prefer to let people promote things themselves, and I try for a policy of attraction rather than promotion myself.
With that said, I often hear people saying some variant of “Maatkit saved my behind, thanks so much. I use it all the time.”
But that’s my private email and phone calls. So now is your chance to say so in public. Put your love story in the comments, and let’s see if Maatkit is notable or not. Oh, and feel free to bring back the Wikipedia page if you think Wikipedia is notable enough that it’s important for Maatkit to be there ;-)
Further Reading:
We’re using maatkit for our two master to master replicated database servers. We find it very useful and are really grateful for your work.
Žilvinas
13 Jan 09 at 10:58 am
Maatkit saved me on a several occasions. I ran into a few of the MySQL replication quirks such as UPDATE with LIMIT without an ORDER BY and I was able to correct the data in a tenth of the time than it would have without it. Thank-you for such a fantastic tool.
Richard Ayotte
13 Jan 09 at 11:52 am
I’ve been using mk-parellel-dump for full and incremental backups, two instances of mk-heartbeat to monitor a 15 node replication array, mk-archiver to keep our logs and sessions tables trim, and mk-find to audit the overall state of our data when need be. It has changed every task in my daily life as a DBA for the better. The 2nd edition of the book is the perfect complement.
Andrew
13 Jan 09 at 11:59 am
Using it to keep a replication slave 20 minutes behind the master.
Antonio
13 Jan 09 at 2:06 pm
Maatkit keeps me warm. I have the t-shirt on right now.
I use it indirectly by reading about the features it provides and reimplementing some of them in Python.
Mark Callaghan
13 Jan 09 at 9:17 pm
I am using Makkit for http://viddler.com :)
Todd Troxell
13 Jan 09 at 10:07 pm
I can also never remember the correct spelling of Maatkit :)
Todd Troxell
13 Jan 09 at 10:08 pm
I’m using maatkit wrapped in a python script to regularly (once a night) md5 the records in our 28 master servers and compare them with the slave server they replicate back to. It then produces a nice “CIO friendly” colour coded email of the results.
Thanks for such a great tool kit!
Bowen
14 Jan 09 at 5:10 am
I personally use Maatkit in my own startup, Inkzee for table purging, but apart from that we also use it in Tuenti.com, the biggest social network in Spain.
Alex Barrera
18 Jan 09 at 7:48 am
I use maatkit for backups and restores, master-slave auditing, correction of replication audit failures, query analysis, slow query log analysis, grant auditing, and a few other things. Maatkit is the secret sauce that makes my MySQL database consulting business successful.
Justin Dossey
21 Jan 09 at 9:25 pm
I use maatkit to check all our slave databases are in sync all the time – i’d be lost without it!
GBA
26 Jan 09 at 5:39 pm
I’m contracting at a start-up working p/t. I’ve got them using mk-parallel-dump & mk-parallel-restore (whoa those are fast & cool). I want them to have one backup a day where they use parallel dump.
I’m working on getting mk-archiver working so that it can be put into a script.
I love! maatkit. I think the terse docs may keep some away from using it.
Right now I’m trying to figure out how to archive from a table where the PK is missing in another table. I archive into another db.
erin
17 Mar 09 at 1:36 pm
Now that Ryan Lowe has come to the SF-MySQL-Meetup to talk about Maatkit I’ve become very familiar with mk-query-digest.
I use it with –processlist. It sure would be great to see an example of it being used with tcpdump. But for now it’s working great. Ryan said once I started using it I’d feel like I owed him a beer. He’s right!
erin
1 Jul 09 at 7:01 pm