MySQL_Zero_Downtime_SchemaChange.sh

gistfile1.txt

#!/bin/bash

# Example of how to use Percona's online schema changer tool.

# Tips!
#  Don't put any semicolons in your schema commmands!
#  Separate schema commands by commas; i.e., ADD COLUMN y_id bigint NULL, ADD CONSTRAINT y_fk FOREIGN KEY (y_id) REFERENCES y(y_id)"
#  When testing, remove the --execute flag!


# This'll print out lots of rich output too!

pt-online-schema-change \
  --execute \
	--progress time,1 \
  --print \
  --recursion-method=none \
	-h $HOST \
  -u $USER \
	--ask-pass \
  --alter-foreign-keys-method drop_swap \
	--alter "$COMMAND" \
	D=heart,t=lambda_invocation_set