gh-ost

gh-ost
====================================================================
1.
2016-10-19 15:06:09 DEBUG Looking for master on 192.168.110.133:3306
2016-10-19 15:06:09 DEBUG Master of 192.168.110.133:3306 is 192.168.110.137:3306
2016-10-19 15:06:09 FATAL There seems to be a master-master setup at 192.168.110.137:3306. This is unsupported. Bailing out
reset slave all;

2.
2016-10-19 15:10:41 FATAL It seems like this migration attempt to run directly on master. Preferably it would be executed on a replica (and this reduces load from the master). To proceed please provide --allow-on-master
添加参数--allow-on-master

3.
2016-10-19 15:21:24 FATAL Table `_room_today_cost_detail_test_gho` already exists. Panicking. Use --initially-drop-ghost-table to force dropping it, though I really prefer that you drop it or rename it away

./gh-ost --initially-drop-ghost-table --conf=/etc/my.cnf --host '192.168.110.133' --execute --debug --database "mydb" --allow-on-master --table "room_today_cost_detail_test" --assume-rbr  --alter "add column cost_value int(11)" --alter "ADD COLUMN add_tst varchar(30)"


4.
./gh-ost --user "admin" --password "mysql123" --initially-drop-ghost-table --initially-drop-old-table --initially-drop-socket-file --debug --database "mydb"  --table "room_today_cost_detail_test" --switch-to-rbr --alter "add column cost_value int not null default 0" --execute