Hi, Our Applications team is looking to move to MySQL v8x for their use and We are the downstream data platform. We’re currently using Meltano with

pipelinewise-tap-mysql

which appears to be incompatible with mysql 8 due to this bug Management is pressuring us now to either find solution for MySql 8 compatibility or move out of Meltano dependency to some managed solution due to its slow movement on that bug. Does anybody have experience with using Meltano and MySQL 8. We are in an escalation mode following this. I welcome suggestions for overcoming this hurdle if anybody has one.

We use meltano and pipelinewise-tap-mysql in production with MySQL 8 and have for many months. Is there something specifically not working for you?

No we didnt start, looking at the open issue itself, setting up an Aurora mysql 8 instance with BINLOGs for data pull requires some large setup for our Ops teams, so we were holding back. What kind of MySQL 8 instance are you using. Managed/Self hosted ? @thomas_briggs

AWS RDS. MySQL not Aurora though

Okay, thank you

You can test it with MySQL in a local docker container though... it's no different as far as tap-mysql is concerned

I wasnt sure if binlogs worked with docker, but thanks for recommendations I will check it out