Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Is it possible to do streaming replication to PostgeSQL, from another database, say MYSQL?

This would be the best way to do a migration without braking an existing system.



Well we can consider that pgloader already implements the first half of the streaming replication: the base copy to stream changes onto.

Adding support for the MySQL binlog replication format is on the TODO list, if you're proficient in it I would welcome hints to implement it correctly.

In terms of priority and organisation, it's Open Source so you know how it works right? Contributions are welcome, as are feature based sponsoring.


I would love to contribute to it, but I am not an expert on the subject. Its just something I tried to do a while back, but couldn't find a clean way.

Let me see if I can figure it out and will try to give you a pull request.


Awesome, thanks already for putting some time on it. You will easily find my email if you need help playing with pgloader internals and stuff.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: