gh-ost使用例子

 

1.创建索引同时删除旧表

连接主库

/opt/gh-ost/gh-ost \
--allow-on-master \
--chunk-size=10000 \
--user=root \
--password='hxl3040' \
--host='192.168.1.113' \
--port=3306 \
--database="db_test" \
--table="t_order_hxl" \
--verbose \
--alter="alter table t_order_hxl add index idx_name4(name4)" \
--assume-rbr \
--cut-over=default \
--cut-over-lock-timeout-seconds=5 \
--dml-batch-size=10 \
--concurrent-rowcount \
--default-retries=10 \
--heartbeat-interval-millis=2000 \
--timestamp-old-table \
--initially-drop-socket-file \
--initially-drop-ghost-table \
--throttle-flag-file=/tmp/gh-ost.throttle \
--skip-metadata-lock-check \
--ok-to-drop-table \
--execute

 

2.加字段

/opt/gh-ost/gh-ost \
--allow-on-master \
--chunk-size=10000 \
--user=root \
--password='hxl3040' \
--host='192.168.1.113' \
--port=3306 \
--database="db_zhuanjs" \
--table="wechat_notice_info" \
--verbose \
--alter="alter table wechat_notice_info add column name4 varchar(32), add column name5 varchar(32)" \
--assume-rbr \
--cut-over=default \
--cut-over-lock-timeout-seconds=5 \
--dml-batch-size=10 \
--concurrent-rowcount \
--default-retries=10 \
--heartbeat-interval-millis=2000 \
--timestamp-old-table \
--initially-drop-socket-file \
--initially-drop-ghost-table \
--throttle-flag-file=/tmp/gh-ost.throttle \
--skip-metadata-lock-check \
--executez　

执行完会保留备份表

 

暂停迁移:touch /tmp/gh-ost.throttle
恢复迁移:rm -f /tmp/gh-ost.throttle

 

3.删除字段,并删除备份表

 

/opt/gh-ost/gh-ost \
--allow-on-master \
--chunk-size=10000 \
--user=root \
--password='hxl3040' \
--host='192.168.1.113' \
--port=3306 \
--database="db_zhuanjs" \
--table="wechat_notice_info" \
--verbose \
--alter="alter table wechat_notice_info drop column name4,drop column name5" \
--assume-rbr \
--cut-over=default \
--cut-over-lock-timeout-seconds=5 \
--dml-batch-size=10 \
--concurrent-rowcount \
--default-retries=10 \
--heartbeat-interval-millis=2000 \
--timestamp-old-table \
--initially-drop-socket-file \
--initially-drop-ghost-table \
--throttle-flag-file=/tmp/gh-ost.throttle \
--skip-metadata-lock-check \
--ok-to-drop-table \
--execute