Installing MySQL Foreign Data Wrapper on RHEL 7 or OL 7 x86_64 v2

Prerequisites

Before you begin the installation process:

• Install Postgres on the same host. See:

  • Installing EDB Postgres Advanced Server

  • Installing PostgreSQL

• 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:

  dnf repolist | grep 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.

• Install the EPEL repository:

  Toggle WrapCopy

  sudo yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

• Enable additional repositories to resolve dependencies:

  Toggle WrapCopy

  subscription-manager repos --enable "rhel-*-optional-rpms" --enable "rhel-*-extras-rpms"  --enable "rhel-ha-for-rhel-*-server-rpms"

• Download and install the MYSQL repo:

  Toggle WrapCopy

  sudo yum -y install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

• Enable the MYSQL repo:

  Toggle WrapCopy

  # 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 15 and MySQL version is 8 then the package name is edb-as15-mysql8-fdw.

• On this page
• Prerequisites
• Install the package