MySQL Foreign Data Wrapper v2

Suggest edits

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

Planning

Architecture overview

Key features

Installing and upgrading

Installing

Initial configuration

Upgrading

Uninstalling

Using

Example: End-to-end

Example: Import foreign schema

Example: Join pushdown

Example: Aggregate pushdown

Example: ORDER BY pushdown

Example: LIMIT OFFSET pushdown

Troubleshooting

Identifying the version

Authentication plugin ‘caching_sha2_password’ error