Installing MySQL Standard (Commercial) Edition in Mashery Local

Mashery Local 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 Mashery Local, perform the following steps:
  1. Download MySQL Commercial Edition from your subscription.
    MySQL commercial edition 5.7.28 is verified for Mashery Local 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 Mashery Local 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 Mashery Local Installer.

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

    After Mashery Local 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 Mashery Local 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 Mashery Local 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