Postgresql slave for Mysql Master. Possible ?

Question

Hi,

I need to make some tests for a potential migration from Mysql to PostgreSql. It will be easier to test if it is possible to use Postgre as slave for my MySQL master.

Is it possible ?

Thanks in advance

Answer 1

I don't think so, master-slave replication is only possible between same databases.

You could configure MySQL using the PostgreSQL-SQL-mode and you could also make a dump ready to import in Postgresql by using --compatible in mysqldump.

Answer 2

No.

You can build something yourself using triggers and an external process to send data over, but it's fairly difficult since mysql has a rather limited support for triggers.

For your scenario you're likely to be better off doing periodic dumps of the data over. The best way is often to migrate the schema manually, and then send your data over as CSV. The "mysqldump --compatible" usually doesn't work well enough.