{"action":"created","issue":{"url":"https://api.github.com/repos/github/gh-ost/issues/215","repository_url":"https://api.github.com/repos/github/gh-ost","labels_url":"https://api.github.com/repos/github/gh-ost/issues/215/labels{/name}","comments_url":"https://api.github.com/repos/github/gh-ost/issues/215/comments","events_url":"https://api.github.com/repos/github/gh-ost/issues/215/events","html_url":"https://github.com/github/gh-ost/issues/215","id":174199446,"number":215,"title":"Any idea about delete operation","user":{"login":"gywndi","id":7335357,"avatar_url":"https://avatars.githubusercontent.com/u/7335357?v=3","gravatar_id":"","url":"https://api.github.com/users/gywndi","html_url":"https://github.com/gywndi","followers_url":"https://api.github.com/users/gywndi/followers","following_url":"https://api.github.com/users/gywndi/following{/other_user}","gists_url":"https://api.github.com/users/gywndi/gists{/gist_id}","starred_url":"https://api.github.com/users/gywndi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gywndi/subscriptions","organizations_url":"https://api.github.com/users/gywndi/orgs","repos_url":"https://api.github.com/users/gywndi/repos","events_url":"https://api.github.com/users/gywndi/events{/privacy}","received_events_url":"https://api.github.com/users/gywndi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-31T07:02:59Z","updated_at":"2016-08-31T07:55:52Z","closed_at":null,"body":"Hi~\r\n\r\nI have some question about data copy operation.\r\n\r\nThis is kind of CDC tool, using binlog parser.\r\nAny change on source table applied by binlog (ROW FORMAT) event, then copy data from source to target with query operation. I understand like this.. (Right?)\r\n\r\nBut what I concern is \"DELETE\" operation.\r\nActually, there's \"NO LOCK\" between source and target table, only async copy & apply.\r\nThen.. many delete&insert operation, any possibilities \"NOT DELLETED\", even though last binlog event is \"DELETE EVENT\".\r\n\r\n1. SELETE CHUNK DATA\r\n2. COPY TO TARGET | DELETED ON SOURCE\r\n3. COPY TO TARGET | DELETED ON TARGET\r\n4. COPY TO TARGET - DELETED DATA\r\n\r\nThis is from \"NO LOCK mechanism\" copy & apply logic.\r\nIt's ok there's no delete operation, but many delete??\r\n\r\nDo you have any idea to solve this kind of problems?\r\n\r\nThanks.\r\nChan."},"comment":{"url":"https://api.github.com/repos/github/gh-ost/issues/comments/243687363","html_url":"https://github.com/github/gh-ost/issues/215#issuecomment-243687363","issue_url":"https://api.github.com/repos/github/gh-ost/issues/215","id":243687363,"user":{"login":"gywndi","id":7335357,"avatar_url":"https://avatars.githubusercontent.com/u/7335357?v=3","gravatar_id":"","url":"https://api.github.com/users/gywndi","html_url":"https://github.com/gywndi","followers_url":"https://api.github.com/users/gywndi/followers","following_url":"https://api.github.com/users/gywndi/following{/other_user}","gists_url":"https://api.github.com/users/gywndi/gists{/gist_id}","starred_url":"https://api.github.com/users/gywndi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gywndi/subscriptions","organizations_url":"https://api.github.com/users/gywndi/orgs","repos_url":"https://api.github.com/users/gywndi/repos","events_url":"https://api.github.com/users/gywndi/events{/privacy}","received_events_url":"https://api.github.com/users/gywndi/received_events","type":"User","site_admin":false},"created_at":"2016-08-31T07:55:52Z","updated_at":"2016-08-31T07:55:52Z","body":"Hi~ I think.. both. :)\r\n\r\n\"DELETE DATA\" is really general operation.\r\nWithout \"Lock\" on specific  row.. how to prevent  the \"DELETED DATA\" revive.\r\n(I also have similar concerns.. processing streaming log and copy data.)"}}
{"actor":{"display_login":"gywndi"}}