Skip to content

Instantly share code, notes, and snippets.

@cosmos-sajal

cosmos-sajal/pt-online-schema-change

Last active December 27, 2017 19:00
Show Gist options
  • Save cosmos-sajal/a70150b0c378417005510b6c7a5f7689 to your computer and use it in GitHub Desktop.
Save cosmos-sajal/a70150b0c378417005510b6c7a5f7689 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pt-online-schema-change
sudo apt-get install percona-toolkit
pt-online-schema-change --alter
"Add column <new_column> varchar(60) NOT NULL default <default_value>"
--user=root D=<database_name>,t=<table_name> --execute
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment