rosettable

Shameless plug: check out [Rosettable https://github.com/francoisp/rosettable]. Brings Postgres triggers and notifies to your MySQL schema, with it you can organize a smooth transition. Using MySQL_fdw you can use your current MySQL schema with the above you can know when a client interacted directly with MySQL; all the while you add some nice jsonb and Plpgsql and transition out of MySQL incrementally. Don’t rewrite, write onward

hello Matt, you might be interested in this: uses binlog to provide 2 way sync to postgres including hard delete detection, using postgres triggers. https://github.com/francoisp/rosettable

check this out, https://github.com/francoisp/rosettable. Uses binlog a reader to call postgres triggers, upon which you can build 2 way sync realtime.

Very nice! Data wants to be free. Please check out this rosettable thing we open-sourced last year, it could come in handy: it allows real time ETL-like sync between mysql and postgres. https://github.com/francoisp/rosettable I've implemented the struts of a framework built around rosettable, with mautic <-> davical as a proof of concept, it keeps a user defined map (one to one, many to one, one to many and many to many) in sync, live, both ways, surviving restarts even if there's been divergent edits on both sides while offline. I havent released this as OS yet, but I'll put a demo online shortly. For datalakes, I've also implemented something that could be useful: check out duplexRsync: https://github.com/francoisp/duplexRsync. I'll try to reach out via email to make sure you guys see this. cheers! best, F

https://github.com/francoisp/rosettable Bringing postgres triggers and notifies to mysql. I'm half-backing a linked mautic and davical service based on this, to automate analytics, marketing and messaging to your self-hosted contacts. end goal is de-googlify mail contacts and analytics.