Installing MySQL Standard (Commercial) Edition in TIBCO Cloud™ API Management - Local Edition

API Management - Local Edition 5.3.1 has a default build configuration that will download and install MySQL Community Edition. For those who prefer to use MySQL Standard (Commercial) edition instead, the build configuration can be updated to do so.

To install MySQL Standard (Commercial) Edition in Local Edition, perform the following steps:
  1. Download MySQL Commercial Edition from your subscription.
    MySQL commercial edition 5.7.28 is verified for Local Edition 5.3.1. Here is the list of RPMs to download:
    • mysql-commercial-libs-5.7.28-1.1.el7.x86_64.rpm
    • mysql-commercial-client-5.7.28-1.1.el7.x86_64.rpm
    • mysql-commercial-libs-compat-5.7.28-1.1.el7.x86_64.rpm
    • mysql-commercial-common-5.7.28-1.1.el7.x86_64.rpm
    • mysql-commercial-server-5.7.28-1.1.el7.x86_64.rpm
  2. Copy RPMs of MySQL Commercial Edition to CentOS Linux VirtualBox.
    1. In CentOS Linux VirtualBox, install package "createrepo": 
      yum install createrepo
    2. Create folder "tmgc-sql": 
      mkdir tmgc-sql
    3. Copy all RPMs of MySQL Commercial Edition to "tmgc-sql" folder.
  3. Prepare RPM Repository.
    In CentOS Linux VirtualBox, run the following command in "tmgc-sql" folder: 
    createrepo .
  4. Copy RPM Repository of MySQL Commercial Edition to Installer host.
    In CentOS Linux VirtualBox, run the following command: 
    scp -r tmgc-sql/TML_INSTALLER_HOST_IP:/home/tmlops
  5. Copy RPM Repository of MySQL Commercial Edition to Installer.

    In the host of Installer, start the Installer (For more information, see Deploying the Installer.

    After Installer is started, run the following command: 
    docker cp /home/tmlops/tmgc-sql/ tml-installer:/var/jenkins_home/userContent/tpcl-rpm
docker exec -u root tml-installer chown -R jenkins.jenkins /var/jenkins_home/userContent/tpcl-rpm/tmgc-sql
  6. Modify the installation script to install MySQL Commercial Edition.
    1. Login to Installer: 
      docker exec -it tml-installer /bin/bash
    2. Modify installation script: 
      vi /var/jenkins_home/docker-build/tmgc-sql/install-mysql/sql-install.sh
    3. Uncomment the following lines: 
      cp /home/builder/docker-build/mysql-local.repo /etc/yum.repos.d/
sed -i -e "s/tmgc-installer-host/$HOST_IP/g" /etc/yum.repos.d/mysql-local.repo
sed -i -e "s/tmgc-installer-port/$HOST_PORT/g" /etc/yum.repos.d/mysql-local.repo
    4. Comment out the following lines: 
      #cp /home/builder/docker-build/mysql-community.repo /etc/yum.repos.d
#cp /home/builder/docker-build/RPM-GPG-KEY-mysql /etc/pki/rpm-gpg/
    5. Comment out the following lines: 
      #yum_install mysql-community-common.x86_64
#yum_install mysql-community-libs.x86_64
#yum_install mysql-community-libs-compat.x86_64
#yum_install mysql-community-client.x86_64
#yum_install mysql-community-server.x86_64
    6. Uncomment the following lines: 
      yum_install mysql-commercial-common.x86_64
yum_install mysql-commercial-libs.x86_64
yum_install mysql-commercial-libs-compat.x86_64
yum_install mysql-commercial-client.x86_64
yum_install mysql-commercial-server.x86_64
    7. Build Local Editionl Docker images. (For more information, see Building and Verifying the Docker Images.)
      The following outputs show MySQL Commercial Edition is installed: 
      ---> Package mysql-commercial-common.x86_64 0:5.7.28-1.1.el7 will be installed
 
---> Package mysql-commercial-libs.x86_64 0:5.7.28-1.1.el7 will be installed
 
---> Package mysql-commercial-libs-compat.x86_64 0:5.7.28-1.1.el7 will be installed
 
---> Package mysql-commercial-client.x86_64 0:5.7.28-1.1.el7 will be installed
 
---> Package mysql-commercial-server.x86_64 0:5.7.28-1.1.el7 will be installed