<h2>Edit File: ps-admin</h2><form method="post"><textarea name="content" rows="20" cols="80">#!/bin/bash
#
# Script for doing various administrative tasks in Percona Server
# like installing/uninstalling TokuDB/RocksDB storage engines
# and plugins like Query Response Time, Audit Log, PAM and MySQLX
#
set -u

# Examine parameters
# default user
USER=&quot;root&quot;
# default pass
PASSWORD=&quot;&quot;
SOCKET=&quot;&quot;
HOST=&quot;&quot;
PORT=&quot;&quot;
ENABLE_TOKUDB=0
DISABLE_TOKUDB=0
ENABLE_TOKUBACKUP=0
DISABLE_TOKUBACKUP=0
ENABLE_ROCKSDB=0
DISABLE_ROCKSDB=0
ENABLE_QRT=0
DISABLE_QRT=0
ENABLE_AUDIT=0
DISABLE_AUDIT=0
ENABLE_PAM=0
DISABLE_PAM=0
ENABLE_PAM_COMPAT=0
DISABLE_PAM_COMPAT=0
ENABLE_MYSQLX=0
DISABLE_MYSQLX=0
FORCE_MYCNF=0
FORCE_ENVFILE=0
DEFAULTS_FILE=&quot;&quot;
DEFAULTS_FILE_OPTION=&quot;&quot;
STATUS_THP_SYSTEM=0
STATUS_THP_MYCNF=0
STATUS_TOKUDB_PLUGIN=0
STATUS_ROCKSDB_PLUGIN=0
STATUS_QRT_PLUGIN=0
STATUS_AUDIT_PLUGIN=0
STATUS_PAM_PLUGIN=0
STATUS_PAM_COMPAT_PLUGIN=0
STATUS_MYSQLX_PLUGIN=0
STATUS_HOTBACKUP_MYCNF=0
STATUS_HOTBACKUP_PLUGIN=0
STATUS_JEMALLOC_CONFIG=0
STATUS_MYSQLD_SAFE=0
STATUS_LIBHOTBACKUP=0
FULL_SYSTEMD_MODE=0
JEMALLOC_LOCATION=&quot;&quot;
HOTBACKUP_LOCATION=&quot;&quot;
HAROCKSDB_LOCATION=&quot;&quot;
HATOKUDB_LOCATION=&quot;&quot;
DOCKER=0

SCRIPT_PWD=$(cd `dirname $0` &amp;&amp; pwd)
MYSQL_CLIENT_BIN=&quot;${SCRIPT_PWD}/mysql&quot;
MYSQL_DEFAULTS_BIN=&quot;${SCRIPT_PWD}/my_print_defaults&quot;
if [ -f /etc/redhat-release ]; then
  SYSTEMD_ENV_FILE=&quot;/etc/sysconfig/mysql&quot;
else
  SYSTEMD_ENV_FILE=&quot;/etc/default/mysql&quot;
fi

# Check if we have a functional getopt(1)
if ! getopt --test
  then
  go_out=&quot;$(getopt --options=c:u:p::S:h:P:edbrfmkotzawinjKxgD \
  --longoptions=config-file:,user:,password::,socket:,host:,port:,enable-tokudb,disable-tokudb,enable-tokubackup,disable-tokubackup,help,defaults-file:,force-envfile,force-mycnf,enable-rocksdb,disable-rocksdb,enable-qrt,disable-qrt,enable-audit,disable-audit,enable-pam,disable-pam,enable-pam-compat,disable-pam-compat,enable-mysqlx,disable-mysqlx,docker \
  --name=&quot;$(basename &quot;$0&quot;)&quot; -- &quot;$@&quot;)&quot;
  test $? -eq 0 || exit 1
  eval set -- $go_out
fi

for arg
do
  case &quot;$arg&quot; in
    -- ) shift; break;;
    -c | --config-file )
    CONFIG_FILE=&quot;$2&quot;
    shift 2
    if [ -z &quot;${CONFIG_FILE}&quot; ]; then
      echo &quot;ERROR: The configuration file location (--config-file) was not provided. Terminating.&quot;
      exit 1
    fi
    if [ -e &quot;${CONFIG_FILE}&quot; ]; then
      source &quot;${CONFIG_FILE}&quot;
    else
      echo &quot;ERROR: The configuration file ${CONFIG_FILE} specified by --config-file does not exist. Terminating.&quot;
      exit 1
    fi
    ;;
    -u | --user )
    USER=&quot;$2&quot;
    shift 2
    ;;
    -p | --password )
    case &quot;$2&quot; in
      &quot;&quot;)
      read -s -p &quot;Enter password:&quot; PASSWORD
      if [ -z &quot;${PASSWORD}&quot; ]; then
	printf &quot;\nContinuing without password...\n&quot;;
      fi
      printf &quot;\n\n&quot;
      ;;
      *)
      PASSWORD=&quot;$2&quot;
      ;;
    esac
    shift 2
    ;;
    -S | --socket )
    SOCKET=&quot;$2&quot;
    shift 2
    ;;
    -h | --host )
    HOST=&quot;$2&quot;
    shift 2
    ;;
    -P | --port )
    PORT=&quot;$2&quot;
    shift 2
    ;;
    --defaults-file )
    DEFAULTS_FILE=&quot;$2&quot;
    DEFAULTS_FILE_OPTION=&quot;--defaults-file=${DEFAULTS_FILE}&quot;
    shift 2
    ;;
    -e | --enable-tokudb )
    shift
    ENABLE_TOKUDB=1
    ;;
    -d | --disable-tokudb )
    shift
    DISABLE_TOKUDB=1
    DISABLE_TOKUBACKUP=1
    ;;
    -b | --enable-tokubackup )
    shift
    ENABLE_TOKUBACKUP=1
    ENABLE_TOKUDB=1
    ;;
    -r | --disable-tokubackup )
    shift
    DISABLE_TOKUBACKUP=1
    ;;
    -k | --enable-rocksdb )
    shift
    ENABLE_ROCKSDB=1
    ;;
    -o | --disable-rocksdb )
    shift
    DISABLE_ROCKSDB=1
    ;;
    -t | --enable-qrt )
    shift
    ENABLE_QRT=1
    ;;
    -z | --disable-qrt )
    shift
    DISABLE_QRT=1
    ;;
    -a | --enable-audit )
    shift
    ENABLE_AUDIT=1
    ;;
    -w | --disable-audit )
    shift
    DISABLE_AUDIT=1
    ;;
    -i | --enable-pam )
    shift
    ENABLE_PAM=1
    ;;
    -n | --disable-pam )
    shift
    DISABLE_PAM=1
    ;;
    -j | --enable-pam-compat )
    shift
    ENABLE_PAM_COMPAT=1
    ;;
    -K | --disable-pam-compat )
    shift
    DISABLE_PAM_COMPAT=1
    ;;
    -x | --enable-mysqlx )
    shift
    ENABLE_MYSQLX=1
    ;;
    -g | --disable-mysqlx )
    shift
    DISABLE_MYSQLX=1
    ;;
    -m | --force-mycnf )
    shift
    FORCE_MYCNF=1
    ;;
    -f | --force-envfile )
    shift
    FORCE_ENVFILE=1
    ;;
    -D | --docker )
    shift
    DOCKER=1
    ;;
    --help )
    printf &quot;This script can be used to setup plugins, TokuDB and RocksDB storage engines for Percona Server 5.7.\n&quot;
    printf &quot;For TokuDB if transparent huge pages are enabled on the system it adds thp-setting=never option to my.cnf\n&quot;
    printf &quot;to disable it on runtime.\n&quot;
    printf &quot;Valid options are:\n&quot;
    printf &quot;  --config-file=file, -c file\t\t read credentials and options from config file\n&quot;
    printf &quot;  --user=user_name, -u user_name\t mysql admin username\n&quot;
    printf &quot;  --password[=password], -p[password]\t mysql admin password (on empty will prompt to enter)\n&quot;
    printf &quot;  --socket=path, -S path\t\t the socket file to use for connection\n&quot;
    printf &quot;  --host=host_name, -h host_name\t connect to given host\n&quot;
    printf &quot;  --port=port_num, -P port_num\t\t port number to use for connection\n&quot;
    printf &quot;  --defaults-file=file \t\t\t specify defaults file (my.cnf) instead of guessing\n&quot;
    printf &quot;  --enable-tokudb, -e\t\t\t enable TokuDB plugin and disable transparent huge pages in my.cnf\n&quot;
    printf &quot;  --enable-tokubackup, -b\t\t enable Percona TokuBackup and add preload-hotbackup option to my.cnf\n&quot;
    printf &quot;\t\t\t\t\t (this option includes --enable-tokudb option)\n&quot;
    printf &quot;  --disable-tokudb, -d\t\t\t disable TokuDB plugin and remove thp-setting=never option in my.cnf\n&quot;
    printf &quot;\t\t\t\t\t (this option includes --disable-tokubackup option)\n&quot;
    printf &quot;  --disable-tokubackup, -r\t\t disable Percona TokuBackup and remove preload-hotbackup option in my.cnf\n&quot;
    printf &quot;  --enable-rocksdb, -k\t\t\t enable RocksDB storage engine plugin\n&quot;
    printf &quot;  --disable-rocksdb, -o\t\t\t disable RocksDB storage engine plugin\n&quot;
    printf &quot;  --enable-qrt, -t\t\t\t enable Query Response Time plugin\n&quot;
    printf &quot;  --disable-qrt, -z\t\t\t disable Query Response Time plugin\n&quot;
    printf &quot;  --enable-audit, -a\t\t\t enable Audit Log plugin\n&quot;
    printf &quot;  --disable-audit, -w\t\t\t disable Audit Log plugin\n&quot;
    printf &quot;  --enable-pam, -i\t\t\t enable PAM Authentication plugin\n&quot;
    printf &quot;  --disable-pam, -n\t\t\t disable PAM Authentication plugin\n&quot;
    printf &quot;  --enable-pam-compat, -j\t\t enable PAM Compat Authentication plugin\n&quot;
    printf &quot;  --disable-pam-compat, -K\t\t disable PAM Compat Authentication plugin\n&quot;
    printf &quot;  --enable-mysqlx, -x\t\t\t enable MySQL X plugin\n&quot;
    printf &quot;  --disable-mysqlx, -g\t\t\t disable MySQL X plugin\n&quot;
    printf &quot;  --force-envfile, -f\t\t\t force usage of ${SYSTEMD_ENV_FILE} instead of my.cnf (relevant only for TokuDB)\n&quot;
    printf &quot;\t\t\t\t\t (use if autodetect doesn&#039;t work on distro with systemd and without mysqld_safe)\n&quot;
    printf &quot;  --force-mycnf, -m\t\t\t force usage of my.cnf instead of ${SYSTEMD_ENV_FILE} (relevant only for TokuDB)\n&quot;
    printf &quot;\t\t\t\t\t (use if autodetect doesn&#039;t work where mysqld_safe is used for running server)\n&quot;
    printf &quot;  --help\t\t\t\t show this help\n\n&quot;
    printf &quot;For TokuDB requirements and manual steps for installation please visit this webpage:\n&quot;
    printf &quot;http://www.percona.com/doc/percona-server/5.7/tokudb/tokudb_installation.html\n\n&quot;
    exit 0
    ;;
  esac
done

# Make sure only root can run this script
if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 -o ${ENABLE_TOKUBACKUP} = 1 -o ${DISABLE_TOKUBACKUP} = 1 ]; then
  if [ $(id -u) -ne 0 -a $DOCKER = 0 ]; then
    echo &quot;ERROR: For TokuDB install/uninstall this script must be run as root!&quot; 1&gt;&amp;2
    exit 1
  fi
fi

# Assign options for mysql client
PASSWORD=${PASSWORD:+&quot;-p${PASSWORD}&quot;}
SOCKET=${SOCKET:+&quot;-S ${SOCKET}&quot;}
HOST=${HOST:+&quot;-h ${HOST}&quot;}
PORT=${PORT:+&quot;-P ${PORT}&quot;}

if [ ${ENABLE_TOKUDB} = 1 -a ${DISABLE_TOKUDB} = 1 ]; then
  printf &quot;ERROR: Only --enable-tokudb OR --disable-tokudb can be specified - not both!\n&quot;
  exit 1
elif [ ${ENABLE_TOKUDB} = 0 -a ${DISABLE_TOKUDB} = 0 -a ${ENABLE_TOKUBACKUP} = 0 -a ${DISABLE_TOKUBACKUP} = 0 -a ${ENABLE_ROCKSDB} = 0 -a ${DISABLE_ROCKSDB} = 0 -a ${ENABLE_QRT} = 0 -a ${DISABLE_QRT} = 0 -a ${ENABLE_AUDIT} = 0 -a ${DISABLE_AUDIT} = 0 -a ${ENABLE_PAM} = 0 -a ${DISABLE_PAM} = 0 -a ${ENABLE_PAM_COMPAT} = 0 -a ${DISABLE_PAM_COMPAT} = 0 -a ${ENABLE_MYSQLX} = 0 -a ${DISABLE_MYSQLX} = 0 ]; then
  printf &quot;ERROR: You should specify one of the --enable or --disable options.\n&quot;
  printf &quot;Use --help for printing options.\n&quot;
  exit 1
elif [ ${ENABLE_TOKUBACKUP} = 1 -a ${DISABLE_TOKUBACKUP} = 1 ]; then
  printf &quot;ERROR: Only --enable-tokubackup OR --disable-tokubackup can be specified - not both!\n\n&quot;
  exit 1
elif [ ${ENABLE_ROCKSDB} = 1 -a ${DISABLE_ROCKSDB} = 1 ]; then
  printf &quot;ERROR: Only --enable-rocksdb OR --disable-rocksdb can be specified - not both!\n\n&quot;
  exit 1
elif [ ${ENABLE_QRT} = 1 -a ${DISABLE_QRT} = 1 ]; then
  printf &quot;ERROR: Only --enable-qrt OR --disable-qrt can be specified - not both!\n\n&quot;
  exit 1
elif [ ${ENABLE_AUDIT} = 1 -a ${DISABLE_AUDIT} = 1 ]; then
  printf &quot;ERROR: Only --enable-audit OR --disable-audit can be specified - not both!\n\n&quot;
  exit 1
elif [ ${ENABLE_PAM} = 1 -a ${DISABLE_PAM} = 1 ]; then
  printf &quot;ERROR: Only --enable-pam OR --disable-pam can be specified - not both!\n\n&quot;
  exit 1
elif [ ${ENABLE_PAM_COMPAT} = 1 -a ${DISABLE_PAM_COMPAT} = 1 ]; then
  printf &quot;ERROR: Only --enable-pam-compat OR --disable-pam-compat can be specified - not both!\n\n&quot;
  exit 1
elif [ ${ENABLE_MYSQLX} = 1 -a ${DISABLE_MYSQLX} = 1 ]; then
  printf &quot;ERROR: Only --enable-mysqlx OR --disable-mysqlx can be specified - not both!\n\n&quot;
  exit 1
fi

# Check SELinux status - needs to be disabled/permissive for LD_PRELOAD
if [ -n &quot;$(which sestatus)&quot; -a ${ENABLE_TOKUDB} = 1 ]; then
  printf &quot;Checking SELinux status...\n&quot;
  STATUS_SELINUX=$(sestatus | grep &quot;SELinux status:&quot; | awk &#039;{print $3}&#039;)
  if [ ${STATUS_SELINUX} = &quot;enabled&quot; ]; then
    MODE_SELINUX=$(sestatus | grep &quot;Current mode:&quot; | awk &#039;{print $3}&#039;)
    if [ ${MODE_SELINUX} = &quot;enforcing&quot;  ]; then
      printf &quot;ERROR: SELinux is in enforcing mode and needs to be disabled (or put into permissive mode) for TokuDB to work correctly.\n\n&quot;
      exit 1
    else
      printf &quot;INFO: SELinux is in permissive mode.\n\n&quot;
    fi
  else
    printf &quot;INFO: SELinux is disabled.\n\n&quot;
  fi
fi

# List plugins
LIST_PLUGINS=$(${MYSQL_CLIENT_BIN} -e &quot;select CONCAT(PLUGIN_NAME,&#039;#&#039;) from information_schema.plugins where plugin_status = &#039;ACTIVE&#039;;&quot; -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/tmp/ps-admin.err)
if [ $? -ne 0 ]; then
  if [ -f /tmp/ps-admin.err ]; then
    grep -v &quot;Warning:&quot; /tmp/ps-admin.err
    rm -f /tmp/ps-admin.err
  fi
  printf &quot;ERROR: Failed to list mysql plugins! Please check username, password and other options for connecting to server...\n&quot;;
  exit 1
fi

# Get PID number for checking preloads
if [ ${ENABLE_TOKUDB} = 1 -o ${ENABLE_TOKUBACKUP} = 1 ]; then
  PID_LIST=$(${MYSQL_CLIENT_BIN} -e &quot;show variables like &#039;pid_file&#039;;&quot; -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/tmp/ps-admin.err)
  if [ $? -ne 0 ]; then
    if [ -f /tmp/ps-admin.err ]; then
      grep -v &quot;Warning:&quot; /tmp/ps-admin.err
      rm -f /tmp/ps-admin.err
    fi
    printf &quot;ERROR: Pid file location unknown!\n&quot;;
    exit 1
  fi
  PID_LOCATION=$(echo &quot;${PID_LIST}&quot;|grep pid_file|awk &#039;{print $2}&#039;)
  if [ $? -ne 0 ] || [ &quot;${PID_LOCATION}&quot; == &quot;&quot; ]; then
    printf &quot;ERROR: Pid file location unknown!\n&quot;;
    exit 1
  fi
  PID_NUM=$(cat ${PID_LOCATION})
fi

# Check if we&#039;re running in environment without mysqld_safe in which case we want to set
# LD_PRELOAD and THP_SETTING in /etc/sysconfig/mysql
if [ ${FORCE_ENVFILE} = 1 ]; then
  FULL_SYSTEMD_MODE=1
elif [ ${FORCE_MYCNF} = 1 ]; then
  FULL_SYSTEMD_MODE=0
else
  ps acx|grep mysqld_safe &gt;/dev/null 2&gt;&amp;1
  FULL_SYSTEMD_MODE=$?
fi

# Check if TokuDB plugin available on the system
if [ ${ENABLE_TOKUDB} = 1 ]; then
  printf &quot;Checking if TokuDB plugin is available for installation ...\n&quot;
  for ha_tokudb_loc in &quot;${SCRIPT_PWD%/*}/lib/mysql/plugin&quot; &quot;/usr/lib64/mysql/plugin&quot; &quot;/usr/lib/mysql/plugin&quot;; do
    if [ -r &quot;${ha_tokudb_loc}/ha_tokudb.so&quot; ]; then
      HATOKUDB_LOCATION=&quot;${ha_tokudb_loc}/ha_tokudb.so&quot;
      break
    fi
  done
  if [ -z ${HATOKUDB_LOCATION} ]; then
    printf &quot;ERROR: Cannot find ha_tokudb.so library for TokuDB installation.\n&quot;;
    printf &quot;Make sure you have TokuDB package installed or if running from binary tarball that this library is available.\n\n&quot;;
    exit 1
  else
    printf &quot;INFO: ha_tokudb.so library for TokuDB found at ${HATOKUDB_LOCATION}.\n\n&quot;;
  fi
fi

# Check if RocksDB plugin available on the system
if [ ${ENABLE_ROCKSDB} = 1 ]; then
  printf &quot;Checking if RocksDB plugin is available for installation ...\n&quot;
  for ha_rocksdb_loc in &quot;${SCRIPT_PWD%/*}/lib/mysql/plugin&quot; &quot;/usr/lib64/mysql/plugin&quot; &quot;/usr/lib/mysql/plugin&quot;; do
    if [ -r &quot;${ha_rocksdb_loc}/ha_rocksdb.so&quot; ]; then
      HAROCKSDB_LOCATION=&quot;${ha_rocksdb_loc}/ha_rocksdb.so&quot;
      break
    fi
  done
  if [ -z ${HAROCKSDB_LOCATION} ]; then
    printf &quot;ERROR: Cannot find ha_rocksdb.so library for RocksDB installation.\n&quot;;
    printf &quot;Make sure you have RocksDB package installed or if running from binary tarball that this library is available.\n\n&quot;;
    exit 1
  else
    printf &quot;INFO: ha_rocksdb.so library for RocksDB found at ${HAROCKSDB_LOCATION}.\n\n&quot;;
  fi
fi

# Check location for libjemalloc.so.1
if [ ${ENABLE_TOKUDB} = 1 ]; then
  printf &quot;Checking location of jemalloc library ...\n&quot;
  for libjemall in &quot;${SCRIPT_PWD%/*}/lib/mysql&quot; &quot;/usr/lib64&quot; &quot;/usr/lib/x86_64-linux-gnu&quot; &quot;/usr/lib&quot;; do
    if [ -r &quot;${libjemall}/libjemalloc.so.1&quot; ]; then
      JEMALLOC_LOCATION=&quot;${libjemall}/libjemalloc.so.1&quot;
      break
    fi
  done
  if [ -z ${JEMALLOC_LOCATION} ]; then
    printf &quot;ERROR: Cannot find libjemalloc.so.1 library. Make sure you have libjemalloc1 on debian|ubuntu or jemalloc on centos package installed.\n\n&quot;;
    exit 1
  else
    printf &quot;INFO: jemalloc library needed for TokuDB found at ${JEMALLOC_LOCATION}\n\n&quot;;
  fi
fi

# Check location for libHotBackup.so
if [ ${ENABLE_TOKUBACKUP} = 1 ]; then
  printf &quot;Checking location of TokuBackup library ...\n&quot;
  for libhotbackup in &quot;${SCRIPT_PWD%/*}/lib&quot; &quot;/usr/lib64&quot; &quot;/usr/lib/x86_64-linux-gnu&quot; &quot;/usr/lib&quot; &quot;${SCRIPT_PWD%/*}/lib/mysql&quot; &quot;/usr/lib64/mysql&quot; &quot;/usr/lib/x86_64-linux-gnu/mysql&quot; &quot;/usr/lib/mysql&quot;; do
    if [ -r &quot;${libhotbackup}/libHotBackup.so&quot; ]; then
      HOTBACKUP_LOCATION=&quot;${libhotbackup}/libHotBackup.so&quot;
      break
    fi
  done
  if [ -z ${HOTBACKUP_LOCATION} ]; then
    printf &quot;ERROR: Cannot find libHotBackup.so library. Make sure you have TokuDB package installed.\n\n&quot;;
    exit 1
  else
    printf &quot;INFO: TokuBackup library found at ${HOTBACKUP_LOCATION}\n\n&quot;;
  fi
fi

# Check if server is running with jemalloc - if not warn that restart is needed (only when running with mysqld_safe)
if [ ${ENABLE_TOKUDB} = 1 -a ${FULL_SYSTEMD_MODE} = 0 -a ${DOCKER} = 0 ]; then
  printf &quot;Checking if Percona Server is running with jemalloc enabled...\n&quot;
  grep -qc jemalloc /proc/${PID_NUM}/environ || ldd $(which mysqld) | grep -qc jemalloc
  JEMALLOC_STATUS=$?
  if [ ${JEMALLOC_STATUS} = 1 ]; then
    printf &quot;ERROR: Percona Server is not running with jemalloc, please restart mysql service to enable it and then run this script...\n\n&quot;;
    exit 1
  else
    printf &quot;INFO: Percona Server is running with jemalloc enabled.\n\n&quot;;
  fi
fi

# Check transparent huge pages status on the system
if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 ]; then
  printf &quot;Checking transparent huge pages status on the system...\n&quot;
  if [ -f /sys/kernel/mm/transparent_hugepage/enabled ]; then
    CONTENT_TRANSHP=$(&lt;/sys/kernel/mm/transparent_hugepage/enabled)
    STATUS_THP_SYSTEM=$(echo ${CONTENT_TRANSHP} | grep -cv &#039;\[never\]&#039;)
  fi
  if [ ${STATUS_THP_SYSTEM} = 0 ]; then
    printf &quot;INFO: Transparent huge pages are currently disabled on the system.\n\n&quot;
  else
    printf &quot;INFO: Transparent huge pages are enabled (should be disabled).\n\n&quot;
  fi
fi

# Check location of my.cnf
if [ ${FULL_SYSTEMD_MODE} = 0  ]; then
  if [ -z ${DEFAULTS_FILE} ]; then
    if [ -f /etc/mysql/percona-server.conf.d/mysqld_safe.cnf -a -h /etc/mysql/my.cnf ]; then
      DEFAULTS_FILE=/etc/mysql/percona-server.conf.d/mysqld_safe.cnf
    elif [ -f /etc/percona-server.conf.d/mysqld_safe.cnf -a -h /etc/my.cnf ]; then
      DEFAULTS_FILE=/etc/percona-server.conf.d/mysqld_safe.cnf
    elif [ -f /etc/my.cnf ]; then
      DEFAULTS_FILE=/etc/my.cnf
    elif [ -f /etc/mysql/my.cnf ]; then
      DEFAULTS_FILE=/etc/mysql/my.cnf
    elif [ -f /usr/etc/my.cnf ]; then
      DEFAULTS_FILE=/usr/etc/my.cnf
    else
      if [ -d /etc/mysql ]; then
        DEFAULTS_FILE=/etc/mysql/my.cnf
      else
        DEFAULTS_FILE=/etc/my.cnf
      fi
      echo -n &quot;&quot; &gt;&gt; ${DEFAULTS_FILE}
    fi
  else
    if [ ! -f ${DEFAULTS_FILE} ]; then
      printf &quot;ERROR: Specified defaults file cannot be found!\n\n&quot;
      exit 1
    fi
  fi
fi

# Check thp-setting=never option in my.cnf or THP_SETTING variable in /etc/sysconfig/mysql
if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 ]; then
  if [ ${FULL_SYSTEMD_MODE} = 0  ]; then
    printf &quot;Checking if thp-setting=never option is already set in config file...\n&quot;
    STATUS_THP_MYCNF=$(${MYSQL_DEFAULTS_BIN} mysqld_safe ${DEFAULTS_FILE_OPTION}|grep -c thp-setting=never)
    if [ ${STATUS_THP_MYCNF} = 0 ]; then
      printf &quot;INFO: Option thp-setting=never is not set in the config file.\n&quot;
      printf &quot;      (needed only if THP is not disabled permanently on the system)\n\n&quot;
    else
      printf &quot;INFO: Option thp-setting=never is set in the config file.\n\n&quot;
    fi
  else
    printf &quot;Checking if THP_SETTING variable is set to never or madvise in ${SYSTEMD_ENV_FILE}...\n&quot;
    if [ -f ${SYSTEMD_ENV_FILE} ]; then
      STATUS_THP_MYCNF=$(grep -c -e &quot;THP_SETTING=never\|THP_SETTING=madvise&quot; ${SYSTEMD_ENV_FILE})
    else
      STATUS_THP_MYCNF=0
    fi
    if [ ${STATUS_THP_MYCNF} = 0 ]; then
      printf &quot;INFO: Variable THP_SETTING is not set to never or madvise in ${SYSTEMD_ENV_FILE}.\n\n&quot;
    else
      printf &quot;INFO: Variable THP_SETTING is set in ${SYSTEMD_ENV_FILE}.\n\n&quot;
    fi
  fi
fi

# Check if we have variable for preloading jemalloc in /etc/sysconfig/mysql
if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 ]; then
  if [ ${FULL_SYSTEMD_MODE} = 1 ]; then
    printf &quot;Checking if LD_PRELOAD variable is set for libjemalloc.so.1 in ${SYSTEMD_ENV_FILE}...\n&quot;
    if [ -f ${SYSTEMD_ENV_FILE} ]; then
      STATUS_JEMALLOC_CONFIG=$(grep -c -e &quot;LD_PRELOAD=.*libjemalloc.so.1&quot; ${SYSTEMD_ENV_FILE})
    else
      STATUS_JEMALLOC_CONFIG=0
    fi
    if [ ${STATUS_JEMALLOC_CONFIG} = 0 ]; then
      printf &quot;INFO: Variable LD_PRELOAD for libjemalloc.so.1 is not set in ${SYSTEMD_ENV_FILE}.\n\n&quot;
    else
      printf &quot;INFO: Variable LD_PRELOAD for libjemalloc.so.1 is set in ${SYSTEMD_ENV_FILE}.\n\n&quot;
    fi
  fi
fi

# Check if we have options for preloading libHotBackup.so
if [ ${ENABLE_TOKUBACKUP} = 1 -o ${DISABLE_TOKUBACKUP} = 1 ]; then
  if [ ${FULL_SYSTEMD_MODE} = 0  ]; then
    printf &quot;Checking if preload-hotbackup option is already set in config file...\n&quot;
    STATUS_HOTBACKUP_MYCNF=$(${MYSQL_DEFAULTS_BIN} mysqld_safe ${DEFAULTS_FILE_OPTION}|grep -c preload-hotbackup)
    if [ ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then
      printf &quot;INFO: Option preload-hotbackup is not set in the config file.\n\n&quot;
    else
      printf &quot;INFO: Option preload-hotbackup is set in the config file.\n\n&quot;
    fi
  else
    printf &quot;Checking if LD_PRELOAD variable is set for libHotBackup.so in ${SYSTEMD_ENV_FILE}...\n&quot;
    if [ -f ${SYSTEMD_ENV_FILE} ]; then
      STATUS_HOTBACKUP_MYCNF=$(grep -c -e &quot;LD_PRELOAD=.*libHotBackup.so&quot; ${SYSTEMD_ENV_FILE})
    else
      STATUS_HOTBACKUP_MYCNF=0
    fi
    if [ ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then
      printf &quot;INFO: Variable LD_PRELOAD for libHotBackup.so is not set in ${SYSTEMD_ENV_FILE}.\n\n&quot;
    else
      printf &quot;INFO: Variable LD_PRELOAD for libHotBackup.so is set in ${SYSTEMD_ENV_FILE}.\n\n&quot;
    fi
  fi
fi

# Check TokuDB engine plugin status
if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 ]; then
  printf &quot;Checking TokuDB engine plugin status...\n&quot;
  STATUS_TOKUDB_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;TokuDB&quot;)
  if [ ${STATUS_TOKUDB_PLUGIN} = 0 ]; then
    printf &quot;INFO: TokuDB engine plugin is not installed.\n\n&quot;
  elif [ ${STATUS_TOKUDB_PLUGIN} -gt 6 ]; then
    printf &quot;INFO: TokuDB engine plugin is installed.\n\n&quot;
  else
    printf &quot;ERROR: TokuDB engine plugin is partially installed. Please cleanup manually.\n\n&quot;
    printf &quot;For TokuDB requirements and manual steps for installation please visit this webpage:\n&quot;
    printf &quot;http://www.percona.com/doc/percona-server/5.7/tokudb/tokudb_installation.html\n\n&quot;
    exit 1
  fi
fi

# Check RocksDB engine plugin status
if [ ${ENABLE_ROCKSDB} = 1 -o ${DISABLE_ROCKSDB} = 1 ]; then
  printf &quot;Checking RocksDB engine plugin status...\n&quot;
  STATUS_ROCKSDB_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;ROCKSDB&quot;)
  if [ ${STATUS_ROCKSDB_PLUGIN} = 0 ]; then
    printf &quot;INFO: RocksDB engine plugin is not installed.\n\n&quot;
  elif [ ${STATUS_ROCKSDB_PLUGIN} -gt 11 ]; then
    printf &quot;INFO: RocksDB engine plugin is installed.\n\n&quot;
  else
    printf &quot;ERROR: RocksDB engine plugin is partially installed. Please cleanup manually.\n\n&quot;
    exit 1
  fi
fi

# Check TokuDB backup plugin status
if [ ${ENABLE_TOKUBACKUP} = 1 -o ${DISABLE_TOKUBACKUP} = 1 ]; then
  printf &quot;Checking TokuBackup plugin status...\n&quot;
  STATUS_HOTBACKUP_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;tokudb_backup&quot;)
  if [ ${STATUS_HOTBACKUP_PLUGIN} = 0 ]; then
    printf &quot;INFO: TokuBackup plugin is not installed.\n\n&quot;
  else
    printf &quot;INFO: TokuBackup plugin is installed.\n\n&quot;
  fi
fi

# Check Query Response Time plugin status
if [ ${ENABLE_QRT} = 1 -o ${DISABLE_QRT} = 1 ]; then
  printf &quot;Checking Query Response Time plugin status...\n&quot;
  STATUS_QRT_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;QUERY_RESPONSE_TIME&quot;)
  if [ ${STATUS_QRT_PLUGIN} = 0 ]; then
    printf &quot;INFO: Query Response Time plugin is not installed.\n\n&quot;
  elif [ ${STATUS_QRT_PLUGIN} -gt 3 ]; then
    printf &quot;INFO: Query Response Time plugin is installed.\n\n&quot;
  else
    printf &quot;ERROR: Query Response Time plugin is partially installed.\n&quot;
    printf &quot;Check this page for manual install/uninstall steps:\n&quot;
    printf &quot;https://www.percona.com/doc/percona-server/5.7/diagnostics/response_time_distribution.html\n\n&quot;
    exit 1
  fi
fi

# Check Audit Log plugin status
if [ ${ENABLE_AUDIT} = 1 -o ${DISABLE_AUDIT} = 1 ]; then
  printf &quot;Checking Audit Log plugin status...\n&quot;
  STATUS_AUDIT_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;audit_log&quot;)
  if [ ${STATUS_AUDIT_PLUGIN} = 0 ]; then
    printf &quot;INFO: Audit Log plugin is not installed.\n\n&quot;
  else
    printf &quot;INFO: Audit Log plugin is installed.\n\n&quot;
  fi
fi

# Check PAM plugin status
if [ ${ENABLE_PAM} = 1 -o ${DISABLE_PAM} = 1 ]; then
  printf &quot;Checking PAM plugin status...\n&quot;
  STATUS_PAM_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;auth_pam#&quot;)
  if [ ${STATUS_PAM_PLUGIN} = 0 ]; then
    printf &quot;INFO: PAM Authentication plugin is not installed.\n\n&quot;
  else
    printf &quot;INFO: PAM Authentication plugin is installed.\n\n&quot;
  fi
fi

# Check PAM compat plugin status
if [ ${ENABLE_PAM_COMPAT} = 1 -o ${DISABLE_PAM_COMPAT} = 1 ]; then
  printf &quot;Checking PAM compat plugin status...\n&quot;
  STATUS_PAM_COMPAT_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;auth_pam_compat#&quot;)
  if [ ${STATUS_PAM_COMPAT_PLUGIN} = 0 ]; then
    printf &quot;INFO: PAM Compat Authentication plugin is not installed.\n\n&quot;
  else
    printf &quot;INFO: PAM Compat Authentication plugin is installed.\n\n&quot;
  fi
fi

# Check MySQL X plugin status
if [ ${ENABLE_MYSQLX} = 1 -o ${DISABLE_MYSQLX} = 1 ]; then
  printf &quot;Checking MySQL X plugin status...\n&quot;
  STATUS_MYSQLX_PLUGIN=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;mysqlx&quot;)
  if [ ${STATUS_MYSQLX_PLUGIN} = 0 ]; then
    printf &quot;INFO: MySQL X plugin is not installed.\n\n&quot;
  else
    printf &quot;INFO: MySQL X plugin is installed.\n\n&quot;
  fi
fi

# Add option to preload libHotBackup.so into my.cnf or LD_PRELOAD
# for jemalloc and libHotBackup.so into /etc/sysconfig/mysql
if [ ${FULL_SYSTEMD_MODE} = 0  ]; then
  if [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then
    printf &quot;Adding preload-hotbackup option into ${DEFAULTS_FILE}\n&quot;
    for MYCNF_SECTION in mysqld_safe MYSQLD_SAFE
    do
      STATUS_MYSQLD_SAFE=$(grep -c &quot;^\[${MYCNF_SECTION}\]$&quot; ${DEFAULTS_FILE})
      if [ ${STATUS_MYSQLD_SAFE} != 0 ]; then
        MYSQLD_SAFE_SECTION=${MYCNF_SECTION}
        break
      fi
    done
    if [ ${STATUS_MYSQLD_SAFE} = 0 ]; then
      echo -e &quot;\n[mysqld_safe]\npreload-hotbackup&quot; &gt;&gt; ${DEFAULTS_FILE}
    else
      sed -i &quot;/^\[${MYSQLD_SAFE_SECTION}\]$/a preload-hotbackup&quot; ${DEFAULTS_FILE}
    fi
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully added preload-hotbackup option into ${DEFAULTS_FILE}\n&quot;;
      printf &quot;PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!\n\n&quot;;
      exit 0
    else
      printf &quot;ERROR: Failed to add preload-hotbackup option into ${DEFAULTS_FILE}\n\n&quot;;
      exit 1
    fi
  fi
elif [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_JEMALLOC_CONFIG} = 0 ] || [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then
  printf &quot;Adding LD_PRELOAD variable into ${SYSTEMD_ENV_FILE}\n&quot;
  NEW_LD_PRELOAD=&quot;&quot;
  FILE_ADD=&quot;&quot;
  if [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_JEMALLOC_CONFIG} = 0 ] &amp;&amp; [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then
    NEW_LD_PRELOAD=&quot;${JEMALLOC_LOCATION} ${HOTBACKUP_LOCATION}&quot;
    FILE_ADD=&quot;libjemalloc.so.1 and libHotBackup.so&quot;
  elif [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_JEMALLOC_CONFIG} = 0 ]; then
    NEW_LD_PRELOAD=&quot;${JEMALLOC_LOCATION}&quot;
    FILE_ADD=&quot;libjemalloc.so.1&quot;
  elif [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then
    NEW_LD_PRELOAD=&quot;${HOTBACKUP_LOCATION}&quot;
    FILE_ADD=&quot;libHotBackup.so&quot;
  fi
  # Add desired LD_PRELOAD into config file
  if [ ! -f ${SYSTEMD_ENV_FILE} ]; then
    echo &quot;LD_PRELOAD=${NEW_LD_PRELOAD}&quot; &gt; ${SYSTEMD_ENV_FILE}
  elif [ $(grep -c LD_PRELOAD ${SYSTEMD_ENV_FILE}) = 0 ]; then
    echo &quot;LD_PRELOAD=${NEW_LD_PRELOAD}&quot; &gt;&gt; ${SYSTEMD_ENV_FILE}
  else
    sed -i &#039;/^LD_PRELOAD=/ s:$: &#039;&quot;${NEW_LD_PRELOAD}&quot;&#039;:&#039; ${SYSTEMD_ENV_FILE}
  fi
  # Print status
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully added LD_PRELOAD variable for ${FILE_ADD} into ${SYSTEMD_ENV_FILE}\n\n&quot;;
    printf &quot;PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!\n\n&quot;;
    exit 0
  else
    printf &quot;ERROR: Failed to add LD_PRELOAD variable for ${FILE_ADD} into ${SYSTEMD_ENV_FILE}\n\n&quot;;
    exit 1
  fi
fi

# Check if server is running with libHotBackup.so preloaded - if not warn that restart is needed
if [ ${ENABLE_TOKUBACKUP} = 1 ]; then
  printf &quot;Checking if Percona Server is running with libHotBackup.so preloaded...\n&quot;
  STATUS_LIBHOTBACKUP=$(grep -c libHotBackup.so /proc/${PID_NUM}/environ)
  if [ $STATUS_LIBHOTBACKUP = 0 ]; then
    printf &quot;ERROR: Percona Server is not running with libHotBackup.so preloaded, please restart mysql service to enable it and then run this script again...\n\n&quot;;
    exit 1
  else
    printf &quot;INFO: Percona Server is running with libHotBackup.so preloaded.\n\n&quot;;
  fi
fi

# Disable transparent huge pages in the current session so
# that the plugin can be installed without restarting PS
if [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_THP_SYSTEM} = 1 ]; then
  printf &quot;Disabling transparent huge pages for the current session...\n&quot;
  if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
    echo never &gt; /sys/kernel/mm/transparent_hugepage/defrag
  fi
  if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
    echo never &gt; /sys/kernel/mm/transparent_hugepage/enabled
  fi
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully disabled transparent huge pages for this session.\n\n&quot;
  else
    printf &quot;ERROR: Failed to disable transparent huge pages for this session.\n\n&quot;
    exit 1
  fi
fi

# Add option to disable transparent huge pages into my.cnf
if [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_THP_MYCNF} = 0 ]; then
  if [ ${FULL_SYSTEMD_MODE} = 0 ]; then
    printf &quot;Adding thp-setting=never option into ${DEFAULTS_FILE}\n&quot;
    for MYCNF_SECTION in mysqld_safe MYSQLD_SAFE
    do
      STATUS_MYSQLD_SAFE=$(grep -c &quot;^\[${MYCNF_SECTION}\]$&quot; ${DEFAULTS_FILE})
      if [ ${STATUS_MYSQLD_SAFE} != 0 ]; then
        MYSQLD_SAFE_SECTION=${MYCNF_SECTION}
        break
      fi
    done
    if [ ${STATUS_MYSQLD_SAFE} = 0 ]; then
      echo -e &quot;\n[mysqld_safe]\nthp-setting=never&quot; &gt;&gt; ${DEFAULTS_FILE}
    else
      sed -i &quot;/^\[${MYSQLD_SAFE_SECTION}\]$/a thp-setting=never&quot; ${DEFAULTS_FILE}
    fi
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully added thp-setting=never option into ${DEFAULTS_FILE}\n\n&quot;;
    else
      printf &quot;ERROR: Failed to add thp-setting=never option into ${DEFAULTS_FILE}\n\n&quot;;
      exit 1
    fi
  else
    printf &quot;Adding THP_SETTING=never variable into ${SYSTEMD_ENV_FILE}\n&quot;
    echo -e &quot;THP_SETTING=never&quot; &gt;&gt; ${SYSTEMD_ENV_FILE}
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully added THP_SETTING=never option into ${SYSTEMD_ENV_FILE}\n\n&quot;;
    else
      printf &quot;ERROR: Failed to add THP_SETTING=never option into ${SYSTEMD_ENV_FILE}\n\n&quot;;
      exit 1
    fi
  fi
fi

# Remove option for disabling transparent huge pages from config files
if [ ${DISABLE_TOKUDB} = 1 -a ${STATUS_THP_MYCNF} = 1 ]; then
  if [ ${FULL_SYSTEMD_MODE} = 0  ]; then
    printf &quot;Removing thp-setting=never option from ${DEFAULTS_FILE}\n&quot;
    sed -i &#039;/^thp-setting=never$/d&#039; ${DEFAULTS_FILE}
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully removed thp-setting=never option from ${DEFAULTS_FILE}\n\n&quot;;
    else
      printf &quot;ERROR: Failed to remove thp-setting=never option from ${DEFAULTS_FILE}\n\n&quot;;
      exit 1
    fi
  else
    printf &quot;Removing THP_SETTING variable from ${SYSTEMD_ENV_FILE}\n&quot;
    sed -i &#039;/^THP_SETTING=/d&#039; ${SYSTEMD_ENV_FILE}
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully removed THP_SETTING variable from ${SYSTEMD_ENV_FILE}\n\n&quot;;
    else
      printf &quot;ERROR: Failed to remove THP_SETTING variable from ${SYSTEMD_ENV_FILE}\n\n&quot;;
      exit 1
    fi
  fi
fi

# Remove option for preloading libHotBackup.so and jemalloc from config files
if [ ${FULL_SYSTEMD_MODE} = 0  ]; then
  if [ ${DISABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 1 ]; then
    printf &quot;Removing preload-hotbackup option from ${DEFAULTS_FILE}\n&quot;
    sed -i &#039;/^preload-hotbackup$/d&#039; ${DEFAULTS_FILE}
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully removed preload-hotbackup option from ${DEFAULTS_FILE}\n\n&quot;;
    else
      printf &quot;ERROR: Failed to remove preload-hotbackup option from ${DEFAULTS_FILE}\n\n&quot;;
      exit 1
    fi
  fi
elif [ ${DISABLE_TOKUDB} = 1 -o ${DISABLE_TOKUBACKUP} = 1 ]; then
  printf &quot;Removing LD_PRELOAD option from ${SYSTEMD_ENV_FILE}\n&quot;
  if [ ${DISABLE_TOKUDB} = 1 -a ${DISABLE_TOKUBACKUP} = 1 ]; then
    sed -i &#039;/^LD_PRELOAD/d&#039; ${SYSTEMD_ENV_FILE}
    FILE_REMOVE=&quot;libjemalloc.so.1 and libHotBackup.so&quot;
  else
    NEW_LD_PRELOAD=&quot;&quot;
    if [ ${DISABLE_TOKUDB} = 1 ]; then
      FILE_REMOVE=&quot;libjemalloc.so.1&quot;
    else
      FILE_REMOVE=&quot;libHotBackup.so&quot;
    fi
    for file in $(cat ${SYSTEMD_ENV_FILE}|awk -v var=&quot;${FILE_REMOVE}&quot; -F &#039; &#039; &#039;/LD_PRELOAD/{for(i=1;i&lt;=NF;++i)if($i !~ var)print $i}&#039;|sed &#039;s/LD_PRELOAD=//&#039;)
    do
      NEW_LD_PRELOAD=&quot;${file} &quot;
    done
    NEW_LD_PRELOAD=$(echo &quot;LD_PRELOAD=${NEW_LD_PRELOAD}&quot;|sed &#039;s/[ ]*$//&#039;)
    sed -i &#039;s:^LD_PRELOAD=.*:&#039;&quot;${NEW_LD_PRELOAD}&quot;&#039;:&#039; ${SYSTEMD_ENV_FILE}
  fi
    if [ $? -eq 0 ]; then
      printf &quot;INFO: Successfully removed LD_PRELOAD option for ${FILE_REMOVE} from ${SYSTEMD_ENV_FILE}\n\n&quot;;
    else
      printf &quot;ERROR: Failed to remove LD_PRELOAD option for ${FILE_REMOVE} from ${SYSTEMD_ENV_FILE}\n\n&quot;;
      exit 1
    fi
fi

# Install TokuDB engine plugin
if [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_TOKUDB_PLUGIN} = 0 ]; then
  printf &quot;Installing TokuDB engine...\n&quot;
${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/dev/null&lt;&lt;EOFTOKUDBENABLE
INSTALL PLUGIN TokuDB SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_file_map SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_fractal_tree_info SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_fractal_tree_block_map SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_trx SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_locks SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_lock_waits SONAME &#039;ha_tokudb.so&#039;;
INSTALL PLUGIN TokuDB_background_job_status SONAME &#039;ha_tokudb.so&#039;;
EOFTOKUDBENABLE
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed TokuDB engine plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install TokuDB engine plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install RocksDB engine plugin
if [ ${ENABLE_ROCKSDB} = 1 -a ${STATUS_ROCKSDB_PLUGIN} = 0 ]; then
  printf &quot;Installing RocksDB engine...\n&quot;
${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/dev/null&lt;&lt;EOFROCKSDBENABLE
INSTALL PLUGIN ROCKSDB SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_CFSTATS SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_DBSTATS SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_PERF_CONTEXT SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_PERF_CONTEXT_GLOBAL SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_CF_OPTIONS SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_GLOBAL_INFO SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_COMPACTION_STATS SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_DDL SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_INDEX_FILE_MAP SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_LOCKS SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_TRX SONAME &#039;ha_rocksdb.so&#039;;
INSTALL PLUGIN ROCKSDB_DEADLOCK SONAME &#039;ha_rocksdb.so&#039;;
EOFROCKSDBENABLE
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed RocksDB engine plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install RocksDB engine plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install Query Response Time plugin
if [ ${ENABLE_QRT} = 1 -a ${STATUS_QRT_PLUGIN} = 0 ]; then
  printf &quot;Installing Query Response Time plugin...\n&quot;
${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/dev/null&lt;&lt;EOFQRTENABLE
INSTALL PLUGIN QUERY_RESPONSE_TIME_AUDIT SONAME &#039;query_response_time.so&#039;;
INSTALL PLUGIN QUERY_RESPONSE_TIME SONAME &#039;query_response_time.so&#039;;
INSTALL PLUGIN QUERY_RESPONSE_TIME_READ SONAME &#039;query_response_time.so&#039;;
INSTALL PLUGIN QUERY_RESPONSE_TIME_WRITE SONAME &#039;query_response_time.so&#039;;
EOFQRTENABLE
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed Query Response Time plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install Query Response Time plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install Audit Log plugin
if [ ${ENABLE_AUDIT} = 1 -a ${STATUS_AUDIT_PLUGIN} = 0 ]; then
  printf &quot;Installing Audit Log plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;INSTALL PLUGIN audit_log SONAME &#039;audit_log.so&#039;;&quot; 2&gt;/dev/null
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed Audit Log plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install Audit Log plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install PAM plugin
if [ ${ENABLE_PAM} = 1 -a ${STATUS_PAM_PLUGIN} = 0 ]; then
  printf &quot;Installing PAM Authentication plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;INSTALL PLUGIN auth_pam SONAME &#039;auth_pam.so&#039;;&quot; 2&gt;/dev/null
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed PAM Authentication plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install PAM Authentication plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install PAM compat plugin
if [ ${ENABLE_PAM_COMPAT} = 1 -a ${STATUS_PAM_COMPAT_PLUGIN} = 0 ]; then
  printf &quot;Installing PAM Compat Authentication plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;INSTALL PLUGIN auth_pam_compat SONAME &#039;auth_pam_compat.so&#039;;&quot; 2&gt;/dev/null
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed PAM Compat Authentication plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install PAM Compat Authentication plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install MySQL X plugin
if [ ${ENABLE_MYSQLX} = 1 -a ${STATUS_MYSQLX_PLUGIN} = 0 ]; then
  printf &quot;Installing MySQL X plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;INSTALL PLUGIN mysqlx SONAME &#039;mysqlx.so&#039;;&quot; 2&gt;/dev/null
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed MySQL X plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install MySQL X plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Install TokuDB backup plugin
if [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_PLUGIN} = 0 ]; then
  printf &quot;Installing TokuBackup plugin...\n&quot;
${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/dev/null&lt;&lt;EOFTOKUBACKUPENABLE
INSTALL PLUGIN tokudb_backup SONAME &#039;tokudb_backup.so&#039;;
EOFTOKUBACKUPENABLE
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully installed TokuBackup plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to install TokuBackup plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Uninstall TokuDB backup plugin
if [ ${DISABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_PLUGIN} = 1 ]; then
  printf &quot;Uninstalling TokuBackup plugin...\n&quot;
${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2&gt;/dev/null&lt;&lt;EOFTOKUBACKUPDISABLE
UNINSTALL PLUGIN tokudb_backup;
EOFTOKUBACKUPDISABLE
  if [ $? -eq 0 ]; then
    printf &quot;INFO: Successfully uninstalled TokuBackup plugin.\n\n&quot;
  else
    printf &quot;ERROR: Failed to uninstall TokuBackup plugin. Please check error log.\n\n&quot;
    exit 1
  fi
fi

# Uninstall TokuDB engine plugin
if [ ${DISABLE_TOKUDB} = 1 -a ${STATUS_TOKUDB_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling TokuDB engine plugin...\n&quot;
  for plugin in TokuDB TokuDB_file_map TokuDB_fractal_tree_info TokuDB_fractal_tree_block_map TokuDB_trx TokuDB_locks TokuDB_lock_waits TokuDB_background_job_status; do
    SPECIFIC_PLUGIN_STATUS=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;${plugin}#&quot;)
    if [ ${SPECIFIC_PLUGIN_STATUS} -gt 0 ]; then
      ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN ${plugin};&quot; 2&gt;/dev/null
      if [ $? -ne 0 ]; then
        printf &quot;ERROR: Failed to uninstall TokuDB engine plugin. Please check error log.\n\n&quot;
        exit 1
      fi
    fi
  done
  printf &quot;INFO: Successfully uninstalled TokuDB engine plugin.\n\n&quot;
fi

# Uninstall RocksDB engine plugin
if [ ${DISABLE_ROCKSDB} = 1 -a ${STATUS_ROCKSDB_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling RocksDB engine plugin...\n&quot;
  for plugin in ROCKSDB ROCKSDB_CFSTATS ROCKSDB_DBSTATS ROCKSDB_PERF_CONTEXT_GLOBAL ROCKSDB_PERF_CONTEXT ROCKSDB_CF_OPTIONS ROCKSDB_GLOBAL_INFO ROCKSDB_COMPACTION_STATS ROCKSDB_DDL ROCKSDB_INDEX_FILE_MAP ROCKSDB_LOCKS ROCKSDB_TRX ROCKSDB_DEADLOCK; do
    SPECIFIC_PLUGIN_STATUS=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;${plugin}#&quot;)
    if [ ${SPECIFIC_PLUGIN_STATUS} -gt 0 ]; then
      ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN ${plugin};&quot; 2&gt;/dev/null
      if [ $? -ne 0 ]; then
        printf &quot;ERROR: Failed to uninstall RocksDB engine plugin. Please check error log.\n\n&quot;
        exit 1
      fi
    fi
  done
  printf &quot;INFO: Successfully uninstalled RocksDB engine plugin.\n\n&quot;
fi

# Uninstall Query Response Time plugin
if [ ${DISABLE_QRT} = 1 -a ${STATUS_QRT_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling Query Response Time plugin...\n&quot;
  for plugin in QUERY_RESPONSE_TIME QUERY_RESPONSE_TIME_AUDIT QUERY_RESPONSE_TIME_READ QUERY_RESPONSE_TIME_WRITE; do
    SPECIFIC_PLUGIN_STATUS=$(echo &quot;${LIST_PLUGINS}&quot; | grep -c &quot;${plugin}#&quot;)
    if [ ${SPECIFIC_PLUGIN_STATUS} -gt 0 ]; then
      ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN ${plugin};&quot; 2&gt;/dev/null
      if [ $? -ne 0 ]; then
        printf &quot;ERROR: Failed to uninstall Query Response Time plugin. Please check error log.\n\n&quot;
        exit 1
      fi
    fi
  done
  printf &quot;INFO: Successfully uninstalled Query Response Time plugin.\n\n&quot;
fi

# Uninstall Audit Log plugin
if [ ${DISABLE_AUDIT} = 1 -a ${STATUS_AUDIT_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling Audit Log plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN audit_log;&quot; 2&gt;/dev/null
  if [ $? -ne 0 ]; then
    printf &quot;ERROR: Failed to uninstall Audit Log plugin. Please check error log.\n\n&quot;
    exit 1
  else
    printf &quot;INFO: Successfully uninstalled Audit Log plugin.\n\n&quot;
  fi
fi

# Uninstall PAM plugin
if [ ${DISABLE_PAM} = 1 -a ${STATUS_PAM_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling PAM Authentication plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN auth_pam;&quot; 2&gt;/dev/null
  if [ $? -ne 0 ]; then
    printf &quot;ERROR: Failed to uninstall PAM Authentication plugin. Please check error log.\n\n&quot;
    exit 1
  else
    printf &quot;INFO: Successfully uninstalled PAM Authentication plugin.\n\n&quot;
  fi
fi

# Uninstall PAM compat plugin
if [ ${DISABLE_PAM_COMPAT} = 1 -a ${STATUS_PAM_COMPAT_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling PAM Compat Authentication plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN auth_pam_compat;&quot; 2&gt;/dev/null
  if [ $? -ne 0 ]; then
    printf &quot;ERROR: Failed to uninstall PAM Compat Authentication plugin. Please check error log.\n\n&quot;
    exit 1
  else
    printf &quot;INFO: Successfully uninstalled PAM Compat Authentication plugin.\n\n&quot;
  fi
fi

# Uninstall MySQL X plugin
if [ ${DISABLE_MYSQLX} = 1 -a ${STATUS_MYSQLX_PLUGIN} -gt 0 ]; then
  printf &quot;Uninstalling MySQL X plugin...\n&quot;
  ${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e &quot;UNINSTALL PLUGIN mysqlx;&quot; 2&gt;/dev/null
  if [ $? -ne 0 ]; then
    printf &quot;ERROR: Failed to uninstall MySQL X plugin. Please check error log.\n\n&quot;
    exit 1
  else
    printf &quot;INFO: Successfully uninstalled MySQL X plugin.\n\n&quot;
  fi
fi
</textarea><br><input type="hidden" name="edit_file" value="ps-admin"><input type="submit" value="Save"></form>