MySQL Foreign Data Wrapper Guide

The MySQL Foreign Data Wrapper (mysql_fdw) is a Postgres extension that allows you to access data that resides on a MySQL database from EDB Postgres Advanced Server. It is a writable foreign data wrapper that you can use with Postgres functions and utilities, or in conjunction with other data that resides on a Postgres host.

The MySQL Foreign Data Wrapper can be installed with an RPM package. You can download an installer from the EDB website.

This guide uses the term Postgres to refer to an instance of EDB Postgres Advanced Server.

• What’s New
• Requirements Overview
  • Supported Versions
  • Supported Platforms
• Architecture Overview
• Installing the MySQL Foreign Data Wrapper
  • Installing the MySQL Foreign Data Wrapper using an RPM Package
    • On RHEL 7
    • On RHEL 8
    • On CentOS 7
    • On CentOS 8
  • Installing the MySQL Foreign Data Wrapper on a Debian or Ubuntu Host
• Features of the MySQL Foreign Data Wrapper
  • Writable FDW
  • Connection Pooling
  • WHERE Clause Push-down
  • Column Push-down
  • Prepared Statement
  • Import Foreign Schema
  • Automated Cleanup
• Configuring the MySQL Foreign Data Wrapper
  • CREATE EXTENSION
  • CREATE SERVER
  • CREATE USER MAPPING
  • CREATE FOREIGN TABLE
    • Data Type Mappings
  • IMPORT FOREIGN SCHEMA
• Example: Using the MySQL Foreign Data Wrapper
• Example: Import Foreign Schema
• Identifying the MySQL Foreign Data Wrapper Version
• Troubleshooting
• Conclusion