Installing MySQL Foreign Data Wrapper on SLES 12 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:

  zypper lr -E | 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 MySQL community repository:

  → WrapCopy

  sudo wget https://dev.mysql.com/get/mysql80-community-release-sles12-5.noarch.rpm
  rpm --import /etc/RPM-GPG-KEY-mysql-2022

• Enable the MySQL8 repository and disable the MySQL 5 repository:

  → WrapCopy

  sudo zypper modifyrepo -e mysql80-community
  sudo zypper modifyrepo -d mysql57-community

• Activate the required SUSE module:

  → WrapCopy

  sudo SUSEConnect -p PackageHub/12.5/x86_64
  sudo SUSEConnect -p sle-sdk/12.5/x86_64
  

• Refresh the metadata:

  → WrapCopy

  sudo zypper refresh

Install the package

sudo zypper -n 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.

• On this page
• Prerequisites
• Install the package