Percona Toolkit is a must-have set of tools that can help serious MySQL administrators perform tasks that are common but difficult to do manually. Years of deployments by tens of thousands of users including some of the best-known Internet sites, have proven the reliability of the Percona Toolkit tools for MySQL. In this presentation, you [...]
Zero-Downtime Schema Changes in MySQL
May 2, 2012
Do schema changes (“migrations”) require a lot of advance scheduling and impact your development and business progress? Is an ALTER TABLE on the critical path in your project planning chart? This common problem comes from the fact that most ALTER operations in MySQL cause the table to be locked and rebuilt, which can be a [...]
Verifying Replication Integrity with Percona Toolkit
Jan 20, 2012
Percona Toolkit 2.0 has a newly upgraded tool for verifying replication integrity, pt-table-checksum. This unique tool verifies that your replicas have exactly the same logical dataset as their masters. No other tool offers this capability, yet it’s vitally important to check that replication isn’t causing data drift, and correct any problems that might be uncovered. [...]
Measuring Scalability and Performance with TCP
Dec 15, 2011
What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]
Percona Toolkit en pratique
Dec 9, 2011
Viadeo le réseau social professionnel et Le MySQL User Group Francophone (lemug.fr) ont organisés une rencontre MySQL le 16 novembre 2011 à Paris. Stéphane est DBA MySQL chez Dailymotion. Il travaille sur la plate-forme LAMP depuis presque 10 ans pour différentes sociétés et est particulièrement enthousiaste au sujet de MySQL. Il intervient régulièrement dans des [...]
Percona Toolkit – MySQL Guru in a Box
Nov 23, 2011
The Percona Toolkit is now “live” and there are some new things there that weren’t in Maatkit. In this talk, Bill Karwin will be covering what’s in Percona Toolkit, but also how-and-why to migrate from Maatkit. Bill Karwin – SF MySQL Meetup Group Nov 15th, 2011 Slides can be downloaded from Percona presentations page.
