when I use tap-mysql replication-method as LOG_BASED, where binlog pos save? Is this handled by pipelinewise-tap-mysql or meltano?

95% sure it's in state. And for state the answer is both and it depends.

taps

handle modifying the state and reading the state,

targets

consume state, and send it to stdout.

meltano

takes the `targets`'s state that was output by the

target

and stores them in the

systemdb

Reading https://hub.meltano.com/singer/spec#state will be very helpful for you I think!

The binlog position is stored per-table in the payload column of the job table in the meltano system DB.

I found that when the first initialization fails, it will always start from scratch. Is there a way to solve it?