Installing MySQL Foreign Data Wrapper on RHEL 7 or OL 7 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.

  • Address other prerequisites

    # Install the EPEL repository:
sudo yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
# Enable additional repositories to resolve dependencies:
subscription-manager repos --enable "rhel-*-optional-rpms" --enable "rhel-*-extras-rpms"  --enable "rhel-ha-for-rhel-*-server-rpms"
# Download and install the MYSQL repo:
sudo yum -y install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

# Enable the MYSQL repo:
# For MySQL 8:
sudo yum -y install --enablerepo=mysql80-community --disablerepo=mysql57-community edb-as<xx>-mysql8_fdw

# For MySQL 5:
sudo yum -y install --enablerepo=mysql57-community --disablerepo=mysql80-community edb-as<xx>-mysql5_fdw

Install the package

sudo yum -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 AlmaLinux 8 or Rocky Linux 8 x86_64

Next →

Installing MySQL Foreign Data Wrapper on CentOS 7 x86_64