3 ms·
The percona toolkit is critical for any MySQL DBA. So flexible and invaluable for many aspects of running a production fleet. edit: I'm getting nostalgia of
by Twirrim 9y ago
The percona toolkit is critical for any MySQL DBA. So flexible and invaluable for many aspects of running a production fleet.
edit: I'm getting nostalgia of doing things with the toolkit like running a 24 hour lagged slave because one Developer kept dropping tables from the live primary database he'd decided were "obsolete" (when they weren't). Sadly we could never remove his root access.
Also of particular value: pt-online-schema-change, pt-table-checksum and pt-query-digest. The latter you can do some neat stuff, like tcpdump live traffic and pump it in to find out interesting stuff about live performance.