Installing MySQL Foreign Data Wrapper on SLES 15 ppc64le v2

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 MySQL community repository
    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
    sudo zypper modifyrepo -e mysql80-community
    sudo zypper modifyrepo -d mysql57-community
    
    # Activate the required SUSE module
    sudo SUSEConnect -p PackageHub/15.3/ppc64le
    
    # Refresh the metadata
    sudo zypper refresh

Install the package

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