test

 

 1 gh-ost --user=root  \
 2 --password=root \
 3 --host=5.5.5.101 \
 4 --port=3306 \
 5 --database=lxddb \
 6 --table=t123 \
 7 --alter=" add column age int(10) NOT NULL DEFAULT '18' COMMENT '年龄',add index idx_t123_age(age)" \
 8 --allow-on-master  \
 9 --assume-rbr  \
10 --initially-drop-old-table \
11 --initially-drop-ghost-table \
12 --ok-to-drop-table \
13 --cut-over-lock-timeout-seconds=10 \
14 --serve-socket-file /tmp/test-gh-ost.sock \
15 --replica-server-id 88888 --execute
View Code

 

posted @ 2018-12-12 20:44  knowledge-is-power  阅读(129)  评论(0)  编辑  收藏  举报