3 ms·
Curious: has anyone tried linking a Postgres installation with a MySQL installation using https://github.com/EnterpriseDB/mysql_fdw https://github.com/Enterpris
by derefr 9y ago
Curious: has anyone tried linking a Postgres installation with a MySQL installation using https://github.com/EnterpriseDB/mysql_fdw https://github.com/EnterpriseDB/mysql_fdw ?
My intuition is that, if there's anything MySQL does uniquely well on the "being an ACID datastore" front, then this would let you get the best of both worlds—essentially letting some of your Postgres tables use MySQL's storage engines et al.
- pgaddict 9y agoIt's possible, but FWDs are not really a viable solution for "pluggable storage". It also limits what the planner/optimizer can do, and (obviously) it introduces latency because there's network communications. FWD are a great thing when you need to occasionally access remote systems, but it's not a drop-in replacement for storage. For example, how exactly would you do consistent backups?