Support LOG_BASED replication method

[MeltyBot]

Spec discussions here:

• Spec for log-based replication in the SDK #1012
• How to handle interop when binlog pointer changes, or when migrating between binlog and column-based incremental sync #1015

---

Migrated from GitLab: https://gitlab.com/meltano/sdk/-/issues/306

Originally created by @aaronsteers on 2022-01-19 03:37:10

---

We don't currently have any examples of SDK-based taps which use LOG_BASED replication. After merging !44, we can start exploring this method.

Community contributions welcomed.

[MeltyBot]

View 1 previous comment from the original issue on GitLab

[edgarrmondragon]

@tayloramurphy We discussed in the Singer Guild meeting of 2023-07-13, that it's probably better to address this once we have a reference implementation in a SQL tap, so I'm removing it from the V1 list if that's ok.

[tayloramurphy]

@edgarrmondragon I don't like the idea of dropping this from v1. We've got Derek working Postgres and MySQL and I think we can implement this there. @visch what would it take to get log-based replication working and tested in postgres and mysql?