[root@h101 ~]# pt-online-schema-change -u root -h localhost -pmysql --alter='add column newid char(20) ' --execute D=pt,t=forpttest
No slaves found. See --recursion-method if host h101.temp has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Altering `pt`.`forpttest`...
Creating new table...
Created new table pt._forpttest_new OK.
Altering new table...
Altered `pt`.`_forpttest_new` OK.
2015-10-23T13:53:01 Creating triggers...
2015-10-23T13:53:01 Created triggers OK.
2015-10-23T13:53:01 Copying approximately 41 rows...
2015-10-23T13:53:01 Copied rows OK.
2015-10-23T13:53:01 Swapping tables...
2015-10-23T13:53:01 Swapped original and new tables OK.
2015-10-23T13:53:01 Dropping old table...
2015-10-23T13:53:01 Dropped old table `pt`.`_forpttest_old` OK.
2015-10-23T13:53:01 Dropping triggers...
2015-10-23T13:53:01 Dropped triggers OK.
Successfully altered `pt`.`forpttest`.
[root@h101 ~]# echo $?
0
[root@h101 ~]#
已经添加好新列
mysql> desc forpttest;
+---------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| id | int(6) | NO | PRI | 0 | |
| name | char(10) | YES | | NULL | |
| comment | char(10) | YES | | NULL | |
| abc | char(10) | YES | | NULL | |
| newid | char(20) | YES | | NULL | |
+---------+----------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql>
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。