apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined
182 stars 8 forks source link

Supporting replication based on log file position #155

Closed VWagen1989 closed 4 days ago

VWagen1989 commented 1 week ago

MyDuck Server does not support log file based positioning replication due to the implementation of the vitess parser. i.e. Syntax like CHANGE REPLICATION SOURCE TO ... SOURCE_LOG_FILE='binlog.xxxxxxx', SOURCE_LOG_POS=xxx is not supported.

To enable MyDuck Server to replicate from those MySQL instances that have not enabled the system variable GTID_MODE, we should implement the log file based positioning replication for it.

VWagen1989 commented 1 week ago

Related to Syntax Error with SOURCE_LOG_FILE in CHANGE REPLICATION SOURCE TO Command.