Installing MySQL Foreign Data Wrapper on Debian 10 x86_64 v2

Suggest edits

Prerequisites

Before you begin the installation process:

  • Install EDB Postgres Advanced Server on the same host. See Installing EDB Postgres Advanced Server.

  • Set up the repository Setting up the repository is a one-time task. If you have already set up your repository, you do not need to perform this step.

    To set up the repository, go to EDB repositories and follow the instructions provided there.

  • 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

    # For MySQL 8:
sudo echo "deb http://repo.mysql.com/apt/debian/buster mysql-8.0" | sudo tee  /etc/apt/sources.list.d/mysql.list

# For MySQL 5:
sudo echo "deb http://repo.mysql.com/apt/debian/buster mysql-5.7" | 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-as<xx>-mysql<y>-fdw

Where <xx> is the version of EDB Postgres Advanced server and <y> is the version of MySQL to be installed. For example if EDB Postgres Version is 13 and MySQL version is 8 then the package name is edb-as13-mysql8-fdw.

← Prev

Installing MySQL Foreign Data Wrapper on Debian 11 x86_64

Next →

Installing MySQL Foreign Data Wrapper on Linux IBM Power (ppc64le)