Have you tested pt-online-schema-change?
I’ve been seeing a lot of interest in pt-online-schema-change (nonblocking MySQL schema changes), with a lively discussion on the mailing list (which I think I’m not keeping up with…) and a couple of bug reports filed. I’m really interested whether people have tested it rigorously to ensure that it maintains your data integrity. I have done so, and there is a set of tests for it in the codebase, but nothing replaces real-world testing. If you find any problems or have questions, please address them to the percona-discussion Google Group.
I haven’t tested it but I am planning on ripping off a few features for FB OSC :)
Rob Wultsch
22 May 12 at 11:44 pm
We started using it at Podio today, we’ll keep you posted.
Phil Chambers
23 May 12 at 8:11 am
We’ve done a fair bit of testing this at box. On our largest table we ran it and did some “poor man checksums”. Basically a join where old.column = new.column and a count on that. Of over 100,000,000 rows tested (about 10% of the table), less than 100 were different. This we attributed to updates that had occurred since the change was made.
Will Gunty
25 May 12 at 4:43 pm
This is a great tool but if you use a lot of triggers … that you have a problem.
Could you place the code in the procedure and next re-create a trigger that already exists with “call” at the beginning ?
seweryn
29 Sep 12 at 4:10 pm