4 ms·
Good call. As an aside why not use postgres's mysql foreign data wrapper instead of syncing with the mysql database?
by tankenmate 2y ago
Good call.
As an aside why not use postgres's mysql foreign data wrapper instead of syncing with the mysql database?
- jd3 2y agoI was not tech lead on that part of the project and did not contribute to any of its initial research/implementation, sadly; I was brought in post-hoc to help with perf issues/cleanup. To directly answer your question, though, without going into too much detail, there were pci compliance issues with some tables/columns in the mysql db, so if I had to guess, perhaps DMS had the capability to assuage that concern more elegantly than mysql_fdw[0], though the mysql_fwd EXCEPT parameter seems to also do the same thing, so honestly, I have no idea. By default, all views and tables existing in a particular database on the MySQL host are imported. Using this option, you can exclude specified foreign tables from the import.[1] [0]: https://github.com/EnterpriseDB/mysql_fdw https://github.com/EnterpriseDB/mysql_fdw [1]: https://www.enterprisedb.com/docs/mysql_data_adapter/latest/configuring/#parameters-4 https://www.enterprisedb.com/docs/mysql_data_adapter/latest/...