I have a project currently based on PostgreSQL 8.1. However, some of the data processing for it needs to happen on a server for which 7.4 is the latest version (for now, only official packages via
yum can be used there).
What I would like to be able to do is split the processing out so that data for which MySQL works better can be operated-on talking to a MySQL database, while data for which PostgreSQL is better can be operated-on there.
I also want to have a fully-replicated environment across the two different RDBMS environments for redundancy.
I'm wondering if there is a way (preferably a "good" one!) of "subscribing" to the MySQL db from PostgreSQL, and to the PostgreSQL db from MySQL.
I'm not averse to writing the interfacing mechanism myself, and will if that's what needs to be done; just hoping something already exists that would handle this for me :)