Percona-toolkit pt-online-schema-change Online modification of table structure

[Email protected] bin]#/pt-online-schema-change--user=checksums--password=checksums--recursion-method= " Processlist "--alter=" add column birth3 int "H=10.50.12.33,p=3336,d=gaoquan,t=t1--execut

Found 2 Slaves:

Bj-ecs-xhm-test-yl-21.domain.com

Bj-ecs-xhm-test-yl-20.domain.com

Would check slave lag on:

Bj-ecs-xhm-test-yl-21.domain.com

Bj-ecs-xhm-test-yl-20.domain.com

Operation, tries, wait:

Analyze_table, 10, 1

Copy_rows, 10, 0.25

Create_triggers, 10, 1

Drop_triggers, 10, 1

Swap_tables, 10, 1

Update_foreign_keys, 10, 1

Altering ' Gaoquan '. ' T1 ' ...

Creating New Table ...

Created new Table Gaoquan._t1_new OK.

Waiting forever for new table ' Gaoquan '. ' _t1_new ' to replicate to bj-ecs-xhm-test-yl-20.domain.com ...

Altering new Table ...

Altered ' Gaoquan '. ' _t1_new ' OK.

2015-12-28T15:13:58 Creating triggers ...

2015-12-28T15:13:58 Created triggers OK.

2015-12-28t15:13:58 Copying approximately 4 rows ...

2015-12-28t15:13:58 Copied rows OK.

2015-12-28t15:13:58 Analyzing new Table ...

2015-12-28T15:13:58 Swapping tables ...

2015-12-28T15:13:58 swapped original and new tables OK.

2015-12-28t15:13:58 dropping old table ...

2015-12-28t15:13:58 Dropped old table ' Gaoquan '. ' _t1_old ' OK.

2015-12-28T15:13:58 dropping triggers ...

2015-12-28T15:13:58 Dropped triggers OK.

Successfully altered ' Gaoquan '. ' T1 '.

Percona-toolkit pt-online-schema-change Online modification of table structure