Give feedback on a pt-online-schema-change update

I am writing a specification for updating pt-online-schema-change. The outline of the changes I want to make is here:

The idea is to make the tool Do The Right Thing, with features such as automatically throttling its operation to avoid causing replicas to lag. Many of the features and improvements are similar to those added to the newly rewritten pt-table-checksum.

If you have any comments on it, please write to the mailing list with your suggestions. Thanks!

Share this post

Comments (4)

  • Guy Nir Reply

    Very interesting and important changes, I have faced some of the problems with the pt-online-schema-change which are:

    – Primary Key with multiple fields is not supported in OSC – I cannot see any plan to fix this, are there plans for future change ?
    – Column names in quotes – as we have reserved words as column names, it will be good to have the col name in quotes inside the osc, which will allow altering a table without restrictions of col names.

    I have also seen you have addressed the Sleep time problem (with –max-lag parameter), for which we have worked around by allowing the sleep time to be dynamically changed via a file.
    will this also handle the part of rolling forward of changes of a table in chunks with sleep ? this cause a huge replication delays with no sleep option in between (now I set the lag to be very high just before the new table

    March 23, 2012 at 9:20 am
  • Nicolas V Reply

    First, thanks for all these great tools :), I discover MySQL for only 2 monthes (previously I was PostgreSQL DBA), and PerconaTools is already my must-have !

    Now my question about pt-online-schema-change, could it be possible to drop all indexes before copying the data, then recreate all indexes after ?
    With InnoDB and the fast index creation, it will be much faster. I run few test, and it’s about 3 time faster.

    May 31, 2012 at 2:20 am
    • Baron Schwartz Reply

      It is something we have noted as a future enhancement.

      May 31, 2012 at 8:59 am

Leave a Reply