Installing MySQL Foreign Data Wrapper on Debian 11 x86_64 v2

Prerequisites

Before you begin the installation process:

  • Install Postgres on the same host. See:

  • Set up the EDB repository.

    Setting up the repository is a one-time task. If you have already set up your repository, you don't need to perform this step.

    To determine if your repository exists, enter this command:

    apt-cache search enterprisedb

    If no output is generated, the repository isn't installed.

    To set up the EDB repository:

    1. Go to EDB repositories.

    2. Select the button that provides access to the EDB repository.

    3. Select the platform and software that you want to download.

    4. Follow the instructions for setting up the EDB repository.

  • Address other prerequisites:

    # Download the GPG key to your APT keyring directly using the apt-key utility:
    sudo apt-key adv --keyserver pgp.mit.edu --recv-keys 3A79BD29
    
    # Install and configure the MySQL repo:
    sudo echo "deb http://repo.mysql.com/apt/debian/bullseye mysql-8.0" | sudo tee  /etc/apt/sources.list.d/mysql.list
    
    # Get the most up-to-date package information from the MySQL APT repository:
    sudo apt-get update

Install the package

sudo apt-get -y install edb-as15-mysql8_fdw

Where 15 is the version of EDB Postgres Advanced server and 8 is the version of MySQL to be installed.