Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save isopropylcyanide/0feb8dc8cb091d53ddc37c7dfcd082a9 to your computer and use it in GitHub Desktop.
Save isopropylcyanide/0feb8dc8cb091d53ddc37c7dfcd082a9 to your computer and use it in GitHub Desktop.
connector-update-fixing-rolled-over-binlogs-post.sh
# Current binlog = 1932
# Last binlog = 143
# Connector status: 131 < 143. So it is out of date
{"ts_sec":1610704790,"file":"my-database-bin.000004","pos":131,"row":1,"server_id":2001186,"event":2}
# Once you update the connector, it will take a snapshot and update to the earliest binlog
{"file":"my-database-bin.000004","pos":143}
# As it is processing the events and catches up, it will update the status.
{"ts_sec":1610704790,"file":"my-database-bin.000004","pos":193,"row":1,"server_id":2001186,"event":2}
{"ts_sec":1610704790,"file":"my-database-bin.000004","pos":713,"row":1,"server_id":2001186,"event":2}
...
{"ts_sec":1610704790,"file":"my-database-bin.000004","pos":1932,"row":1,"server_id":2001186,"event":2}
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment