… drop foreign key without rebuilding whole table by using any online schema changes approaches available out there: create a new table with no… links back. But I agree, having the ability to instantly change FK definition after RENAME TABLE and not being able to…
Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 23, 2012 By 33 Comments
… than subquery optimizations. DROP TABLE is done as part of online-schema change. But you are in luck, a lot of work has…
Comment: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 13, 2012 By 1 Comment
Glad to see a few bugs we were dealing with in Online-Schema-Change released in this build. It’s already installed on all of our machines 
Comment: Give feedback on a pt-online-schema-change update
May 31, 2012 By 4 Comments
… is already my must-have ! Now my question about pt-online-schema-change, could it be possible to drop all indexes before copying…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 9, 2012 By 10 Comments
Quick question… does the pt-online-schema-change tool work at tables using the MyISAM storage engine? Would it work to convert a table from MyISAM to InnoDB?
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 11, 2012 By 30 Comments
… Cluster is designed for scale out, XtraDB Cluster is not. Online schema change is work in progress in XtraDB Cluster and some solution…
Comment: Percona Toolkit 1.0.1 released
September 8, 2011 By 13 Comments
…-digest simpler, and yanking out that code will help. pt-online-schema-change hasn’t been extensively tested in the real world and…
Comment: Percona Toolkit 1.0.1 released
September 7, 2011 By 13 Comments
Looking at the list it appears as though the vast majority, if not all, tools from Maatkit & Aspersa made it through to Percona Toolkit. Is that the case? I have a particular interest in pt-online-schema-change: how far has it been used+tested on your customers production servers?
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… do it because we’d loose the ability to do “online schema change” or LVM snapshot backup. And finally we were not able…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… mysql schema. We deployed and used MySQL Master-Master replication manager (MMM) ever since we started working so doing all the schema changes…’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql -u root db < changes.sql… changes are applied .. $ mmm_control @C1 set_online db2 This is the “downtime” part. The longer it takes to apply application changes, the…
