{"action":"created","comment":{"url":"https://api.github.com/repos/debezium/debezium.github.io/pulls/comments/203836118","pull_request_review_id":138807400,"id":203836118,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIwMzgzNjExOA==","diff_hunk":"@@ -0,0 +1,66 @@\n+= Five Advantages of Log-Based CDC\n+gmorling\n+:awestruct-tags: [ discussion ]\n+:awestruct-layout: blog-post\n+\n+Yesterday I had the opportunity to present Debezium and the idea of change data capture to the https://twitter.com/JUG_DA/status/1019634941020332032[Darmstadt Java User Group].\n+It was a great evening with lots of interesting discussions and questions.\n+One of the questions being the following: what is the advantage of using a log-based change data capturing tool such as Debezium over simply polling for updated records e.g. via JDBC?\n+\n+I replied with a couple of advantages of using Debezium.\n+But as this wasn't the first time this question came up, I thought I could provide a more extensive answer here on the blog.\n+That way I'll be able to refer to this post in the future, should the question come up again :)\n+\n+So without further ado, here's my list of five advantages of log-based CDC over polling-based (or query-based) approaches.\n+\n+All Data Changes Are Captured:: By reading the database's log (e.g. MySQL's binlog or MongoDB's op log) you get the complete list of all data changes in their exact order of application.\n+This is vital for many use cases where you are interested in the complete history of record changes.\n+In contrast, with a polling-based approach you might miss data changes that happen between two runs of the poll loop.","path":"blog/2018-07-19-advantages-of-log-based-cdc.adoc","position":18,"original_position":18,"commit_id":"267c7abae97dd0e7e333c142a96135829c50bbb6","original_commit_id":"267c7abae97dd0e7e333c142a96135829c50bbb6","user":{"login":"gunnarmorling","id":28612,"node_id":"MDQ6VXNlcjI4NjEy","avatar_url":"https://avatars2.githubusercontent.com/u/28612?v=4","gravatar_id":"","url":"https://api.github.com/users/gunnarmorling","html_url":"https://github.com/gunnarmorling","followers_url":"https://api.github.com/users/gunnarmorling/followers","following_url":"https://api.github.com/users/gunnarmorling/following{/other_user}","gists_url":"https://api.github.com/users/gunnarmorling/gists{/gist_id}","starred_url":"https://api.github.com/users/gunnarmorling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunnarmorling/subscriptions","organizations_url":"https://api.github.com/users/gunnarmorling/orgs","repos_url":"https://api.github.com/users/gunnarmorling/repos","events_url":"https://api.github.com/users/gunnarmorling/events{/privacy}","received_events_url":"https://api.github.com/users/gunnarmorling/received_events","type":"User","site_admin":false},"body":"Yes, that's a nice idea. Going to add this.","created_at":"2018-07-19T18:55:22Z","updated_at":"2018-07-19T18:55:50Z","html_url":"https://github.com/debezium/debezium.github.io/pull/180#discussion_r203836118","pull_request_url":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/debezium/debezium.github.io/pulls/comments/203836118"},"html":{"href":"https://github.com/debezium/debezium.github.io/pull/180#discussion_r203836118"},"pull_request":{"href":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180"}},"in_reply_to_id":203781033},"pull_request":{"url":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180","id":202564650,"node_id":"MDExOlB1bGxSZXF1ZXN0MjAyNTY0NjUw","html_url":"https://github.com/debezium/debezium.github.io/pull/180","diff_url":"https://github.com/debezium/debezium.github.io/pull/180.diff","patch_url":"https://github.com/debezium/debezium.github.io/pull/180.patch","issue_url":"https://api.github.com/repos/debezium/debezium.github.io/issues/180","number":180,"state":"open","locked":false,"title":"Adding post 'Five Advantages of Log-Based CDC'","user":{"login":"gunnarmorling","id":28612,"node_id":"MDQ6VXNlcjI4NjEy","avatar_url":"https://avatars2.githubusercontent.com/u/28612?v=4","gravatar_id":"","url":"https://api.github.com/users/gunnarmorling","html_url":"https://github.com/gunnarmorling","followers_url":"https://api.github.com/users/gunnarmorling/followers","following_url":"https://api.github.com/users/gunnarmorling/following{/other_user}","gists_url":"https://api.github.com/users/gunnarmorling/gists{/gist_id}","starred_url":"https://api.github.com/users/gunnarmorling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunnarmorling/subscriptions","organizations_url":"https://api.github.com/users/gunnarmorling/orgs","repos_url":"https://api.github.com/users/gunnarmorling/repos","events_url":"https://api.github.com/users/gunnarmorling/events{/privacy}","received_events_url":"https://api.github.com/users/gunnarmorling/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-07-19T13:45:23Z","updated_at":"2018-07-19T18:55:50Z","closed_at":null,"merged_at":null,"merge_commit_sha":"570be1d0a9c1c3376f0e0a741c4eccfc5318c811","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180/commits","review_comments_url":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180/comments","review_comment_url":"https://api.github.com/repos/debezium/debezium.github.io/pulls/comments{/number}","comments_url":"https://api.github.com/repos/debezium/debezium.github.io/issues/180/comments","statuses_url":"https://api.github.com/repos/debezium/debezium.github.io/statuses/267c7abae97dd0e7e333c142a96135829c50bbb6","head":{"label":"gunnarmorling:advantages_log_based_cdc","ref":"advantages_log_based_cdc","sha":"267c7abae97dd0e7e333c142a96135829c50bbb6","user":{"login":"gunnarmorling","id":28612,"node_id":"MDQ6VXNlcjI4NjEy","avatar_url":"https://avatars2.githubusercontent.com/u/28612?v=4","gravatar_id":"","url":"https://api.github.com/users/gunnarmorling","html_url":"https://github.com/gunnarmorling","followers_url":"https://api.github.com/users/gunnarmorling/followers","following_url":"https://api.github.com/users/gunnarmorling/following{/other_user}","gists_url":"https://api.github.com/users/gunnarmorling/gists{/gist_id}","starred_url":"https://api.github.com/users/gunnarmorling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunnarmorling/subscriptions","organizations_url":"https://api.github.com/users/gunnarmorling/orgs","repos_url":"https://api.github.com/users/gunnarmorling/repos","events_url":"https://api.github.com/users/gunnarmorling/events{/privacy}","received_events_url":"https://api.github.com/users/gunnarmorling/received_events","type":"User","site_admin":false},"repo":{"id":87472811,"node_id":"MDEwOlJlcG9zaXRvcnk4NzQ3MjgxMQ==","name":"debezium.github.io","full_name":"gunnarmorling/debezium.github.io","owner":{"login":"gunnarmorling","id":28612,"node_id":"MDQ6VXNlcjI4NjEy","avatar_url":"https://avatars2.githubusercontent.com/u/28612?v=4","gravatar_id":"","url":"https://api.github.com/users/gunnarmorling","html_url":"https://github.com/gunnarmorling","followers_url":"https://api.github.com/users/gunnarmorling/followers","following_url":"https://api.github.com/users/gunnarmorling/following{/other_user}","gists_url":"https://api.github.com/users/gunnarmorling/gists{/gist_id}","starred_url":"https://api.github.com/users/gunnarmorling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunnarmorling/subscriptions","organizations_url":"https://api.github.com/users/gunnarmorling/orgs","repos_url":"https://api.github.com/users/gunnarmorling/repos","events_url":"https://api.github.com/users/gunnarmorling/events{/privacy}","received_events_url":"https://api.github.com/users/gunnarmorling/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/gunnarmorling/debezium.github.io","description":"Source for the Debezium website at http://debezium.io Please log issues in our JIRA at https://issues.jboss.org/projects/DBZ/issues","fork":true,"url":"https://api.github.com/repos/gunnarmorling/debezium.github.io","forks_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/forks","keys_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/keys{/key_id}","collaborators_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/teams","hooks_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/hooks","issue_events_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/issues/events{/number}","events_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/events","assignees_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/assignees{/user}","branches_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/branches{/branch}","tags_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/tags","blobs_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/git/refs{/sha}","trees_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/git/trees{/sha}","statuses_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/statuses/{sha}","languages_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/languages","stargazers_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/stargazers","contributors_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/contributors","subscribers_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/subscribers","subscription_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/subscription","commits_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/commits{/sha}","git_commits_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/git/commits{/sha}","comments_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/comments{/number}","issue_comment_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/issues/comments{/number}","contents_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/contents/{+path}","compare_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/compare/{base}...{head}","merges_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/merges","archive_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/downloads","issues_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/issues{/number}","pulls_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/pulls{/number}","milestones_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/milestones{/number}","notifications_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/labels{/name}","releases_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/releases{/id}","deployments_url":"https://api.github.com/repos/gunnarmorling/debezium.github.io/deployments","created_at":"2017-04-06T20:38:50Z","updated_at":"2018-07-13T13:33:52Z","pushed_at":"2018-07-19T14:35:45Z","git_url":"git://github.com/gunnarmorling/debezium.github.io.git","ssh_url":"git@github.com:gunnarmorling/debezium.github.io.git","clone_url":"https://github.com/gunnarmorling/debezium.github.io.git","svn_url":"https://github.com/gunnarmorling/debezium.github.io","homepage":"","size":3453,"stargazers_count":0,"watchers_count":0,"language":"CSS","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"develop"}},"base":{"label":"debezium:develop","ref":"develop","sha":"da36907f009d93ff89b9ec2d5bc95f520f4a1d0b","user":{"login":"debezium","id":11964329,"node_id":"MDEyOk9yZ2FuaXphdGlvbjExOTY0MzI5","avatar_url":"https://avatars2.githubusercontent.com/u/11964329?v=4","gravatar_id":"","url":"https://api.github.com/users/debezium","html_url":"https://github.com/debezium","followers_url":"https://api.github.com/users/debezium/followers","following_url":"https://api.github.com/users/debezium/following{/other_user}","gists_url":"https://api.github.com/users/debezium/gists{/gist_id}","starred_url":"https://api.github.com/users/debezium/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/debezium/subscriptions","organizations_url":"https://api.github.com/users/debezium/orgs","repos_url":"https://api.github.com/users/debezium/repos","events_url":"https://api.github.com/users/debezium/events{/privacy}","received_events_url":"https://api.github.com/users/debezium/received_events","type":"Organization","site_admin":false},"repo":{"id":55010150,"node_id":"MDEwOlJlcG9zaXRvcnk1NTAxMDE1MA==","name":"debezium.github.io","full_name":"debezium/debezium.github.io","owner":{"login":"debezium","id":11964329,"node_id":"MDEyOk9yZ2FuaXphdGlvbjExOTY0MzI5","avatar_url":"https://avatars2.githubusercontent.com/u/11964329?v=4","gravatar_id":"","url":"https://api.github.com/users/debezium","html_url":"https://github.com/debezium","followers_url":"https://api.github.com/users/debezium/followers","following_url":"https://api.github.com/users/debezium/following{/other_user}","gists_url":"https://api.github.com/users/debezium/gists{/gist_id}","starred_url":"https://api.github.com/users/debezium/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/debezium/subscriptions","organizations_url":"https://api.github.com/users/debezium/orgs","repos_url":"https://api.github.com/users/debezium/repos","events_url":"https://api.github.com/users/debezium/events{/privacy}","received_events_url":"https://api.github.com/users/debezium/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/debezium/debezium.github.io","description":"Source for the Debezium website at http://debezium.io Please log issues in our JIRA at https://issues.jboss.org/projects/DBZ/issues","fork":false,"url":"https://api.github.com/repos/debezium/debezium.github.io","forks_url":"https://api.github.com/repos/debezium/debezium.github.io/forks","keys_url":"https://api.github.com/repos/debezium/debezium.github.io/keys{/key_id}","collaborators_url":"https://api.github.com/repos/debezium/debezium.github.io/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/debezium/debezium.github.io/teams","hooks_url":"https://api.github.com/repos/debezium/debezium.github.io/hooks","issue_events_url":"https://api.github.com/repos/debezium/debezium.github.io/issues/events{/number}","events_url":"https://api.github.com/repos/debezium/debezium.github.io/events","assignees_url":"https://api.github.com/repos/debezium/debezium.github.io/assignees{/user}","branches_url":"https://api.github.com/repos/debezium/debezium.github.io/branches{/branch}","tags_url":"https://api.github.com/repos/debezium/debezium.github.io/tags","blobs_url":"https://api.github.com/repos/debezium/debezium.github.io/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/debezium/debezium.github.io/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/debezium/debezium.github.io/git/refs{/sha}","trees_url":"https://api.github.com/repos/debezium/debezium.github.io/git/trees{/sha}","statuses_url":"https://api.github.com/repos/debezium/debezium.github.io/statuses/{sha}","languages_url":"https://api.github.com/repos/debezium/debezium.github.io/languages","stargazers_url":"https://api.github.com/repos/debezium/debezium.github.io/stargazers","contributors_url":"https://api.github.com/repos/debezium/debezium.github.io/contributors","subscribers_url":"https://api.github.com/repos/debezium/debezium.github.io/subscribers","subscription_url":"https://api.github.com/repos/debezium/debezium.github.io/subscription","commits_url":"https://api.github.com/repos/debezium/debezium.github.io/commits{/sha}","git_commits_url":"https://api.github.com/repos/debezium/debezium.github.io/git/commits{/sha}","comments_url":"https://api.github.com/repos/debezium/debezium.github.io/comments{/number}","issue_comment_url":"https://api.github.com/repos/debezium/debezium.github.io/issues/comments{/number}","contents_url":"https://api.github.com/repos/debezium/debezium.github.io/contents/{+path}","compare_url":"https://api.github.com/repos/debezium/debezium.github.io/compare/{base}...{head}","merges_url":"https://api.github.com/repos/debezium/debezium.github.io/merges","archive_url":"https://api.github.com/repos/debezium/debezium.github.io/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/debezium/debezium.github.io/downloads","issues_url":"https://api.github.com/repos/debezium/debezium.github.io/issues{/number}","pulls_url":"https://api.github.com/repos/debezium/debezium.github.io/pulls{/number}","milestones_url":"https://api.github.com/repos/debezium/debezium.github.io/milestones{/number}","notifications_url":"https://api.github.com/repos/debezium/debezium.github.io/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/debezium/debezium.github.io/labels{/name}","releases_url":"https://api.github.com/repos/debezium/debezium.github.io/releases{/id}","deployments_url":"https://api.github.com/repos/debezium/debezium.github.io/deployments","created_at":"2016-03-29T20:59:44Z","updated_at":"2018-07-19T18:31:24Z","pushed_at":"2018-07-19T18:33:50Z","git_url":"git://github.com/debezium/debezium.github.io.git","ssh_url":"git@github.com:debezium/debezium.github.io.git","clone_url":"https://github.com/debezium/debezium.github.io.git","svn_url":"https://github.com/debezium/debezium.github.io","homepage":"","size":7288,"stargazers_count":3,"watchers_count":3,"language":"CSS","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":38,"mirror_url":null,"archived":false,"open_issues_count":2,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":38,"open_issues":2,"watchers":3,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180"},"html":{"href":"https://github.com/debezium/debezium.github.io/pull/180"},"issue":{"href":"https://api.github.com/repos/debezium/debezium.github.io/issues/180"},"comments":{"href":"https://api.github.com/repos/debezium/debezium.github.io/issues/180/comments"},"review_comments":{"href":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180/comments"},"review_comment":{"href":"https://api.github.com/repos/debezium/debezium.github.io/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/debezium/debezium.github.io/pulls/180/commits"},"statuses":{"href":"https://api.github.com/repos/debezium/debezium.github.io/statuses/267c7abae97dd0e7e333c142a96135829c50bbb6"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"gunnarmorling"}}