Skip to content

Instantly share code, notes, and snippets.

@isopropylcyanide

isopropylcyanide/connector-hostname-death-view-offset.json

Created February 5, 2021 19:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save isopropylcyanide/dcbe01cf146323ed3e989b850ec48a33 to your computer and use it in GitHub Desktop.
Save isopropylcyanide/dcbe01cf146323ed3e989b850ec48a33 to your computer and use it in GitHub Desktop.
Download ZIP
connector-hostname-death-view-offset.json
Raw
connector-hostname-death-view-offset.json
-- Current binlog = my-database-bin.000004. In sync but the host has changed.
{"ts_sec":1610704790,"file":"my-database-bin.000004","pos":1932,"row":1,"server_id":2001186,"event":2}
-- Once you update the connector, it will take a snapshot and update to the earliest binlog
{"file":"new-host-bin.000001","pos":2000}
-- As it is processing the events, it will update the status. Notice the new server id
{"ts_sec":1610708790,"file":"new-host-bin.000001","pos":2001,"row":1,"server_id":1973403,"event":2}
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment