MySQL Foreign Data Wrapper¶
The MySQL Foreign Data Wrapper (mysql_fdw ) is a Postgres extension
that lets you access data that resides on a MySQL database from EDB
Postgres Advanced Server. It’s a writable foreign data wrapper that you
can use with Postgres functions and utilities or with other data that
resides on a Postgres host.
You can install the MySQL Foreign Data Wrapper with an RPM package. You can download an installer from the EDB website .
whats_new requirements_overview architecture_overview installing_the_mysql_data_adapter updating_the_mysql_data_adapter features_of_mysql_fdw configuring_the_mysql_data_adapter example_using_the_mysql_data_adapter example_import_foreign_schema identifying_data_adapter_version troubleshooting conclusion
- Release notes
- Supported database and versions
- Architecture overview
- Key features
- Writable foreign data wrapper
- Connection pooling
- WHERE clause pushdown
- Column pushdown
- Join pushdown
- Aggregate pushdown
- ORDER BY pushdown
- LIMIT OFFSET pushdown
- Configuration file to restrict pushdowns
- IS [NOT] DISTINCT FROM operator
- Prepared Statement
- Import foreign schema
- Automated cleanup
- Truncate table
- Installing
- Initial configuration
- Upgrading
- Uninstalling
- End-to-end
- Import foreign schema
- Join pushdown
- Aggregate pushdown
- ORDER BY pushdown
- LIMIT OFFSET pushdown
- Identifying the version
- Authentication plugin ‘caching_sha2_password’ error
