Not the answer you need?
Register and ask your own question!

Back up of data before performing pt-online-schema-change.

sairamsairam EntrantCurrent User Role Beginner

According to the percona's documentation, it is suggested to have recoverable backups before using the tool. Is this required, for online schema change ?

Because for osc, the tool will create a copy of the table being modified and with --nodrop-old-table option this table can act as back up. In such cases, why is the back up step mentioned in the documentation required ?


  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    If everything worked 100% as expected (and never failed), we would not need backups for anything. Unfortunately, that is not the case.

    So while the backup is not required, it is a good idea to backup your database prior to doing anything that could potentially harm it. =)
  • atxdbaatxdba Entrant Inactive User Role Beginner
    When the time comes, you'll know.

    Any kind of change inherently involves some amount of risk. There could be some bug in the tool that despite all best efforts and unit tests around it that gets unearthed in your particular setup.

    There could be user error where the tool works as designed but you just told it to do the wrong thing.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.