{"action":"created","issue":{"url":"https://api.github.com/repos/github/gh-ost/issues/493","repository_url":"https://api.github.com/repos/github/gh-ost","labels_url":"https://api.github.com/repos/github/gh-ost/issues/493/labels{/name}","comments_url":"https://api.github.com/repos/github/gh-ost/issues/493/comments","events_url":"https://api.github.com/repos/github/gh-ost/issues/493/events","html_url":"https://github.com/github/gh-ost/issues/493","id":255884659,"number":493,"title":"Test gh-ost on master, the parameters have been added parameters output invalid","user":{"login":"boomballa","id":8543659,"avatar_url":"https://avatars1.githubusercontent.com/u/8543659?v=4","gravatar_id":"","url":"https://api.github.com/users/boomballa","html_url":"https://github.com/boomballa","followers_url":"https://api.github.com/users/boomballa/followers","following_url":"https://api.github.com/users/boomballa/following{/other_user}","gists_url":"https://api.github.com/users/boomballa/gists{/gist_id}","starred_url":"https://api.github.com/users/boomballa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boomballa/subscriptions","organizations_url":"https://api.github.com/users/boomballa/orgs","repos_url":"https://api.github.com/users/boomballa/repos","events_url":"https://api.github.com/users/boomballa/events{/privacy}","received_events_url":"https://api.github.com/users/boomballa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-09-07T10:07:45Z","updated_at":"2017-09-07T18:11:29Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Example 1:\r\n[shell ~]# gh-ost -user=\"root\" -password=\"pwd4mysql\" -host=\"172.16.3.88\" -port=3306 -database=\"crm\"  -table=\"dish\" -alter=\"drop colomn archer_test_column\"   –allow-on-master -switch-to-rbr  –cut-over=default –default-retries=120 –throttle-control-replicas=\"172.16.3.95\"  –max-lag-millis=1500  –verbose -debug  -execute \r\n2017-09-07 17:32:20 FATAL You must be using ROW binlog format. I can switch it for you, provided --switch-to-rbr and that 172.16.3.88:3306 doesn't have replicas\r\n\r\n\r\nJust in the example above, I have added the -switch-to-rbr parameter, and I also have from the  replicas, do not know gh-ost is what principle to use to check from the  replicas?\r\n\r\nmysql> show slave hosts;\r\n+-----------+------+------+-----------+--------------------------------------+\r\n| Server_id | Host | Port | Master_id | Slave_UUID                           |\r\n+-----------+------+------+-----------+--------------------------------------+\r\n|    943308 |      | 3306 |    999999 | 2fa13881-5a1e-11e7-a3d5-000c2902e7e6 |\r\n|  99993306 |      | 3306 |    999999 | 64dbbdec-5a1f-11e7-a3dd-000c29cb5c36 |\r\n+-----------+------+------+-----------+--------------------------------------+\r\n2 rows in set (0.00 sec)\r\n\r\nExample 2：\r\n[shell ~]# gh-ost –allow-on-master –max-load=Threads_running=25 –critical-load=Threads_running=1000 –chunk-size=1000 –throttle-control-replicas=\"172.16.3.95:3306\" –max-lag-millis=1500 -user=\"root\" -password=\"pwd4mysql\" -host=\"172.16.3.88\"   -database=\"crm\"  -table=\"dish\" –verbose -alter=\"drop colomn archer_test_column\"    –cut-over=default –default-retries=120 –switch-to-rbr –panic-flag-file=/tmp/ghost.panic.flag –postpone-cut-over-flag-file=/tmp/ghost.postpone.flag  –execute\r\n2017-09-07 17:41:31 FATAL --database must be provided and database name must not be empty\r\n\r\nI have added the -database parameters, why suggested that my database parameters empty?\r\nThe first test gh-ost, do not know if the method is not used? I hope everyone and the author to help."},"comment":{"url":"https://api.github.com/repos/github/gh-ost/issues/comments/327880110","html_url":"https://github.com/github/gh-ost/issues/493#issuecomment-327880110","issue_url":"https://api.github.com/repos/github/gh-ost/issues/493","id":327880110,"user":{"login":"boomballa","id":8543659,"avatar_url":"https://avatars1.githubusercontent.com/u/8543659?v=4","gravatar_id":"","url":"https://api.github.com/users/boomballa","html_url":"https://github.com/boomballa","followers_url":"https://api.github.com/users/boomballa/followers","following_url":"https://api.github.com/users/boomballa/following{/other_user}","gists_url":"https://api.github.com/users/boomballa/gists{/gist_id}","starred_url":"https://api.github.com/users/boomballa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boomballa/subscriptions","organizations_url":"https://api.github.com/users/boomballa/orgs","repos_url":"https://api.github.com/users/boomballa/repos","events_url":"https://api.github.com/users/boomballa/events{/privacy}","received_events_url":"https://api.github.com/users/boomballa/received_events","type":"User","site_admin":false},"created_at":"2017-09-07T18:11:29Z","updated_at":"2017-09-07T18:11:29Z","author_association":"CONTRIBUTOR","body":"Thank you for your answers and suggestions first.\r\n\r\nExample 1:\r\n\r\nthe `binlog_format` on the mainframe is not Row format on the host which ip is `172.16.3.88 `, I think in the master on the use of `-allow-on-master` and `-switch-to-rbr` parameters can be changed. This is my misuse of the use of parameters. So i can understand into the binlog is not Row format master can not use gh-ost tools? This is also used in the use of certain limitations.\r\n\r\nExample 2:\r\n```\r\n[shell ~]# gh-ost –allow-on-master –max-load=Threads_running=25 –critical-load=Threads_running=1000 –chunk-size=1000 –throttle-control-replicas=\"172.16.3.95:3306\" –max-lag-millis=1500 -user=\"root\" -password=\"pwd4mysql\" -host=\"172.16.3.88\"   --database=\"crm\"  -table=\"dish\" –verbose -alter=\"drop colomn archer_test_column\"    –cut-over=default –default-retries=120 –switch-to-rbr –panic-flag-file=/tmp/ghost.panic.flag –postpone-cut-over-flag-file=/tmp/ghost.postpone.flag  –execute\r\n2017-09-08 01:52:05 FATAL --database must be provided and database name must not be empty\r\n```    \r\nI try `--database` instead of `-database` ,But still can not work properly,and  the same error output.\r\n\r\nI would like to ask, `gh-ost` tool to add the parameters before the end is added `-` or `--`? This point that makes me very confused, I see the help document, the display is used `-` why some parameters need to use `--`?"}}
{"actor":{"display_login":"boomballa"}}