#!/bin/bash

#

# Script for doing various administrative tasks in Percona Server

# like installing/uninstalling TokuDB/RocksDB storage engines

# and plugins like Audit Log and PAM

#

set -u

# Examine parameters

# default user

USER="root"

# default pass

PASSWORD=""

SOCKET=""

HOST=""

PORT=""

ENABLE_TOKUDB=0

DISABLE_TOKUDB=0

ENABLE_TOKUBACKUP=0

DISABLE_TOKUBACKUP=0

ENABLE_ROCKSDB=0

DISABLE_ROCKSDB=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=""

DEFAULTS_FILE_OPTION=""

STATUS_THP_SYSTEM=0

STATUS_THP_MYCNF=0

STATUS_TOKUDB_PLUGIN=0

STATUS_ROCKSDB_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=""

HOTBACKUP_LOCATION=""

HAROCKSDB_LOCATION=""

HATOKUDB_LOCATION=""

DOCKER=0

SCRIPT_PWD=$(cd `dirname $0` && pwd)

MYSQL_CLIENT_BIN="${SCRIPT_PWD}/mysql"

MYSQL_DEFAULTS_BIN="${SCRIPT_PWD}/my_print_defaults"

if [ -f /etc/redhat-release -o -f /etc/system-release ]; then

SYSTEMD_ENV_FILE="/etc/sysconfig/mysql"

else

SYSTEMD_ENV_FILE="/etc/default/mysql"

fi

# Check if we have a functional getopt(1)

if ! getopt --test

then

go_out="$(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-audit,disable-audit,enable-pam,disable-pam,enable-pam-compat,disable-pam-compat,enable-mysqlx,disable-mysqlx,docker \

--name="$(basename "$0")" -- "$@")"

test $? -eq 0 || exit 1

eval set -- $go_out

fi

for arg

do

case "$arg" in

-- ) shift; break;;

-c | --config-file )

CONFIG_FILE="$2"

shift 2

if [ -z "${CONFIG_FILE}" ]; then

echo "ERROR: The configuration file location (--config-file) was not provided. Terminating."

exit 1

fi

if [ -e "${CONFIG_FILE}" ]; then

source "${CONFIG_FILE}"

else

echo "ERROR: The configuration file ${CONFIG_FILE} specified by --config-file does not exist. Terminating."

exit 1

fi

;;

-u | --user )

USER="$2"

shift 2

;;

-p | --password )

case "$2" in

"")

read -s -p "Enter password:" PASSWORD

if [ -z "${PASSWORD}" ]; then

printf "\nContinuing without password...\n";

fi

printf "\n\n"

;;

*)

PASSWORD="$2"

;;

esac

shift 2

;;

-S | --socket )

SOCKET="$2"

shift 2

;;

-h | --host )

HOST="$2"

shift 2

;;

-P | --port )

PORT="$2"

shift 2

;;

--defaults-file )

DEFAULTS_FILE="$2"

DEFAULTS_FILE_OPTION="--defaults-file=${DEFAULTS_FILE}"

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

;;

-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 "This script can be used to setup plugins, TokuDB and RocksDB storage engines for Percona Server 5.7.\n"

printf "For TokuDB if transparent huge pages are enabled on the system it adds thp-setting=never option to my.cnf\n"

printf "to disable it on runtime.\n"

printf "Valid options are:\n"

printf " --config-file=file, -c file\t\t read credentials and options from config file\n"

printf " --user=user_name, -u user_name\t mysql admin username\n"

printf " --password[=password], -p[password]\t mysql admin password (on empty will prompt to enter)\n"

printf " --socket=path, -S path\t\t the socket file to use for connection\n"

printf " --host=host_name, -h host_name\t connect to given host\n"

printf " --port=port_num, -P port_num\t\t port number to use for connection\n"

printf " --defaults-file=file \t\t\t specify defaults file (my.cnf) instead of guessing\n"

printf " --enable-tokudb, -e\t\t\t enable TokuDB plugin and disable transparent huge pages in my.cnf\n"

printf " --enable-tokubackup, -b\t\t enable Percona TokuBackup and add preload-hotbackup option to my.cnf\n"

printf "\t\t\t\t\t (this option includes --enable-tokudb option)\n"

printf " --disable-tokudb, -d\t\t\t disable TokuDB plugin and remove thp-setting=never option in my.cnf\n"

printf "\t\t\t\t\t (this option includes --disable-tokubackup option)\n"

printf " --disable-tokubackup, -r\t\t disable Percona TokuBackup and remove preload-hotbackup option in my.cnf\n"

printf " --enable-rocksdb, -k\t\t\t enable RocksDB storage engine plugin\n"

printf " --disable-rocksdb, -o\t\t\t disable RocksDB storage engine plugin\n"

printf " --enable-audit, -a\t\t\t enable Audit Log plugin\n"

printf " --disable-audit, -w\t\t\t disable Audit Log plugin\n"

printf " --enable-pam, -i\t\t\t enable PAM Authentication plugin\n"

printf " --disable-pam, -n\t\t\t disable PAM Authentication plugin\n"

printf " --enable-pam-compat, -j\t\t enable PAM Compat Authentication plugin\n"

printf " --disable-pam-compat, -K\t\t disable PAM Compat Authentication plugin\n"

printf " --enable-mysqlx, -x\t\t\t enable MySQL X plugin\n"

printf " --disable-mysqlx, -g\t\t\t disable MySQL X plugin\n"

printf " --force-envfile, -f\t\t\t force usage of ${SYSTEMD_ENV_FILE} instead of my.cnf (relevant only for TokuDB)\n"

printf "\t\t\t\t\t (use if autodetect doesn't work on distro with systemd and without mysqld_safe)\n"

printf " --force-mycnf, -m\t\t\t force usage of my.cnf instead of ${SYSTEMD_ENV_FILE} (relevant only for TokuDB)\n"

printf "\t\t\t\t\t (use if autodetect doesn't work where mysqld_safe is used for running server)\n"

printf " --help\t\t\t\t show this help\n\n"

printf "For TokuDB requirements and manual steps for installation please visit this webpage:\n"

printf "http://www.percona.com/doc/percona-server/5.7/tokudb/tokudb_installation.html\n\n"

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 "ERROR: For TokuDB install/uninstall this script must be run as root!" 1>&2

exit 1

fi

fi

# Assign options for mysql client

PASSWORD=${PASSWORD:+"-p${PASSWORD}"}

SOCKET=${SOCKET:+"-S ${SOCKET}"}

HOST=${HOST:+"-h ${HOST}"}

PORT=${PORT:+"-P ${PORT}"}

if [ ${ENABLE_TOKUDB} = 1 -a ${DISABLE_TOKUDB} = 1 ]; then

printf "ERROR: Only --enable-tokudb OR --disable-tokudb can be specified - not both!\n"

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_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 "ERROR: You should specify one of the --enable or --disable options.\n"

printf "Use --help for printing options.\n"

exit 1

elif [ ${ENABLE_TOKUBACKUP} = 1 -a ${DISABLE_TOKUBACKUP} = 1 ]; then

printf "ERROR: Only --enable-tokubackup OR --disable-tokubackup can be specified - not both!\n\n"

exit 1

elif [ ${ENABLE_ROCKSDB} = 1 -a ${DISABLE_ROCKSDB} = 1 ]; then

printf "ERROR: Only --enable-rocksdb OR --disable-rocksdb can be specified - not both!\n\n"

exit 1

elif [ ${ENABLE_AUDIT} = 1 -a ${DISABLE_AUDIT} = 1 ]; then

printf "ERROR: Only --enable-audit OR --disable-audit can be specified - not both!\n\n"

exit 1

elif [ ${ENABLE_PAM} = 1 -a ${DISABLE_PAM} = 1 ]; then

printf "ERROR: Only --enable-pam OR --disable-pam can be specified - not both!\n\n"

exit 1

elif [ ${ENABLE_PAM_COMPAT} = 1 -a ${DISABLE_PAM_COMPAT} = 1 ]; then

printf "ERROR: Only --enable-pam-compat OR --disable-pam-compat can be specified - not both!\n\n"

exit 1

elif [ ${ENABLE_MYSQLX} = 1 -a ${DISABLE_MYSQLX} = 1 ]; then

printf "ERROR: Only --enable-mysqlx OR --disable-mysqlx can be specified - not both!\n\n"

exit 1

fi

# List plugins

LIST_PLUGINS=$(${MYSQL_CLIENT_BIN} -e "select CONCAT(PLUGIN_NAME,'#') from information_schema.plugins where plugin_status = 'ACTIVE';" -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2>/tmp/ps-admin.err)

if [ $? -ne 0 ]; then

if [ -f /tmp/ps-admin.err ]; then

grep -v "Warning:" /tmp/ps-admin.err

rm -f /tmp/ps-admin.err

fi

printf "ERROR: Failed to list mysql plugins! Please check username, password and other options for connecting to server...\n";

exit 1

fi

# Get PID number for checking preloads

if [ ${ENABLE_TOKUDB} = 1 -o ${ENABLE_TOKUBACKUP} = 1 ]; then

PID_LIST=$(${MYSQL_CLIENT_BIN} -e "show variables like 'pid_file';" -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2>/tmp/ps-admin.err)

if [ $? -ne 0 ]; then

if [ -f /tmp/ps-admin.err ]; then

grep -v "Warning:" /tmp/ps-admin.err

rm -f /tmp/ps-admin.err

fi

printf "ERROR: Pid file location unknown!\n";

exit 1

fi

PID_LOCATION=$(echo "${PID_LIST}"|grep pid_file|awk '{print $2}')

if [ $? -ne 0 ] || [ "${PID_LOCATION}" == "" ]; then

printf "ERROR: Pid file location unknown!\n";

exit 1

fi

PID_NUM=$(cat ${PID_LOCATION})

fi

# Check if we'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 >/dev/null 2>&1

FULL_SYSTEMD_MODE=$?

fi

# Check if TokuDB plugin available on the system

if [ ${ENABLE_TOKUDB} = 1 ]; then

printf "Checking if TokuDB plugin is available for installation ...\n"

for ha_tokudb_loc in "${SCRIPT_PWD%/*}/lib/mysql/plugin" "/usr/lib64/mysql/plugin" "/usr/lib/mysql/plugin"; do

if [ -r "${ha_tokudb_loc}/ha_tokudb.so" ]; then

HATOKUDB_LOCATION="${ha_tokudb_loc}/ha_tokudb.so"

break

fi

done

if [ -z ${HATOKUDB_LOCATION} ]; then

printf "ERROR: Cannot find ha_tokudb.so library for TokuDB installation.\n";

printf "Make sure you have TokuDB package installed or if running from binary tarball that this library is available.\n\n";

exit 1

else

printf "INFO: ha_tokudb.so library for TokuDB found at ${HATOKUDB_LOCATION}.\n\n";

fi

fi

# Check if RocksDB plugin available on the system

if [ ${ENABLE_ROCKSDB} = 1 ]; then

printf "Checking if RocksDB plugin is available for installation ...\n"

for ha_rocksdb_loc in "${SCRIPT_PWD%/*}/lib/plugin" "/usr/lib64/mysql/plugin" "/usr/lib/mysql/plugin"; do

if [ -r "${ha_rocksdb_loc}/ha_rocksdb.so" ]; then

HAROCKSDB_LOCATION="${ha_rocksdb_loc}/ha_rocksdb.so"

break

fi

done

if [ -z ${HAROCKSDB_LOCATION} ]; then

printf "ERROR: Cannot find ha_rocksdb.so library for RocksDB installation.\n";

printf "Make sure you have RocksDB package installed or if running from binary tarball that this library is available.\n\n";

exit 1

else

printf "INFO: ha_rocksdb.so library for RocksDB found at ${HAROCKSDB_LOCATION}.\n\n";

fi

fi

# Check location for libjemalloc.so.1

if [ ${ENABLE_TOKUDB} = 1 ]; then

printf "Checking location of jemalloc library ...\n"

for libjemall in "${SCRIPT_PWD%/*}/lib/mysql" "/usr/lib64" "/usr/lib/x86_64-linux-gnu" "/usr/lib"; do

if [ -r "${libjemall}/libjemalloc.so.1" ]; then

JEMALLOC_LOCATION="${libjemall}/libjemalloc.so.1"

break

fi

done

if [ -z ${JEMALLOC_LOCATION} ]; then

printf "ERROR: Cannot find libjemalloc.so.1 library. Make sure you have libjemalloc1 on debian|ubuntu or jemalloc on centos package installed.\n\n";

exit 1

else

printf "INFO: jemalloc library needed for TokuDB found at ${JEMALLOC_LOCATION}\n\n";

fi

fi

# Check location for libHotBackup.so

if [ ${ENABLE_TOKUBACKUP} = 1 ]; then

printf "Checking location of TokuBackup library ...\n"

for libhotbackup in "${SCRIPT_PWD%/*}/lib" "/usr/lib64" "/usr/lib/x86_64-linux-gnu" "/usr/lib" "${SCRIPT_PWD%/*}/lib/mysql" "/usr/lib64/mysql" "/usr/lib/x86_64-linux-gnu/mysql" "/usr/lib/mysql"; do

if [ -r "${libhotbackup}/libHotBackup.so" ]; then

HOTBACKUP_LOCATION="${libhotbackup}/libHotBackup.so"

break

fi

done

if [ -z ${HOTBACKUP_LOCATION} ]; then

printf "ERROR: Cannot find libHotBackup.so library. Make sure you have TokuDB package installed.\n\n";

exit 1

else

printf "INFO: TokuBackup library found at ${HOTBACKUP_LOCATION}\n\n";

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 "Checking if Percona Server is running with jemalloc enabled...\n"

grep -qc jemalloc /proc/${PID_NUM}/environ || ldd $(which mysqld) | grep -qc jemalloc

JEMALLOC_STATUS=$?

if [ ${JEMALLOC_STATUS} = 1 ]; then

printf "ERROR: Percona Server is not running with jemalloc, please restart mysql service to enable it and then run this script...\n\n";

exit 1

else

printf "INFO: Percona Server is running with jemalloc enabled.\n\n";

fi

fi

# Check transparent huge pages status on the system

if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 ]; then

printf "Checking transparent huge pages status on the system...\n"

if [ -f /sys/kernel/mm/transparent_hugepage/enabled ]; then

CONTENT_TRANSHP=$(</sys/kernel/mm/transparent_hugepage/enabled)

STATUS_THP_SYSTEM=$(echo ${CONTENT_TRANSHP} | grep -cv '\[never\]')

fi

if [ ${STATUS_THP_SYSTEM} = 0 ]; then

printf "INFO: Transparent huge pages are currently disabled on the system.\n\n"

else

printf "INFO: Transparent huge pages are enabled (should be disabled).\n\n"

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 "" >> ${DEFAULTS_FILE}

fi

else

if [ ! -f ${DEFAULTS_FILE} ]; then

printf "ERROR: Specified defaults file cannot be found!\n\n"

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 "Checking if thp-setting=never option is already set in config file...\n"

STATUS_THP_MYCNF=$(${MYSQL_DEFAULTS_BIN} mysqld_safe ${DEFAULTS_FILE_OPTION}|grep -c thp-setting=never)

if [ ${STATUS_THP_MYCNF} = 0 ]; then

printf "INFO: Option thp-setting=never is not set in the config file.\n"

printf " (needed only if THP is not disabled permanently on the system)\n\n"

else

printf "INFO: Option thp-setting=never is set in the config file.\n\n"

fi

else

printf "Checking if THP_SETTING variable is set to never or madvise in ${SYSTEMD_ENV_FILE}...\n"

if [ -f ${SYSTEMD_ENV_FILE} ]; then

STATUS_THP_MYCNF=$(grep -c -e "THP_SETTING=never\|THP_SETTING=madvise" ${SYSTEMD_ENV_FILE})

else

STATUS_THP_MYCNF=0

fi

if [ ${STATUS_THP_MYCNF} = 0 ]; then

printf "INFO: Variable THP_SETTING is not set to never or madvise in ${SYSTEMD_ENV_FILE}.\n\n"

else

printf "INFO: Variable THP_SETTING is set in ${SYSTEMD_ENV_FILE}.\n\n"

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 "Checking if LD_PRELOAD variable is set for libjemalloc.so.1 in ${SYSTEMD_ENV_FILE}...\n"

if [ -f ${SYSTEMD_ENV_FILE} ]; then

STATUS_JEMALLOC_CONFIG=$(grep -c -e "LD_PRELOAD=.*libjemalloc.so.1" ${SYSTEMD_ENV_FILE})

else

STATUS_JEMALLOC_CONFIG=0

fi

if [ ${STATUS_JEMALLOC_CONFIG} = 0 ]; then

printf "INFO: Variable LD_PRELOAD for libjemalloc.so.1 is not set in ${SYSTEMD_ENV_FILE}.\n\n"

else

printf "INFO: Variable LD_PRELOAD for libjemalloc.so.1 is set in ${SYSTEMD_ENV_FILE}.\n\n"

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 "Checking if preload-hotbackup option is already set in config file...\n"

STATUS_HOTBACKUP_MYCNF=$(${MYSQL_DEFAULTS_BIN} mysqld_safe ${DEFAULTS_FILE_OPTION}|grep -c preload-hotbackup)

if [ ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then

printf "INFO: Option preload-hotbackup is not set in the config file.\n\n"

else

printf "INFO: Option preload-hotbackup is set in the config file.\n\n"

fi

else

printf "Checking if LD_PRELOAD variable is set for libHotBackup.so in ${SYSTEMD_ENV_FILE}...\n"

if [ -f ${SYSTEMD_ENV_FILE} ]; then

STATUS_HOTBACKUP_MYCNF=$(grep -c -e "LD_PRELOAD=.*libHotBackup.so" ${SYSTEMD_ENV_FILE})

else

STATUS_HOTBACKUP_MYCNF=0

fi

if [ ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then

printf "INFO: Variable LD_PRELOAD for libHotBackup.so is not set in ${SYSTEMD_ENV_FILE}.\n\n"

else

printf "INFO: Variable LD_PRELOAD for libHotBackup.so is set in ${SYSTEMD_ENV_FILE}.\n\n"

fi

fi

fi

# Check TokuDB engine plugin status

if [ ${ENABLE_TOKUDB} = 1 -o ${DISABLE_TOKUDB} = 1 ]; then

printf "Checking TokuDB engine plugin status...\n"

STATUS_TOKUDB_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "TokuDB")

if [ ${STATUS_TOKUDB_PLUGIN} = 0 ]; then

printf "INFO: TokuDB engine plugin is not installed.\n\n"

elif [ ${STATUS_TOKUDB_PLUGIN} -gt 6 ]; then

printf "INFO: TokuDB engine plugin is installed.\n\n"

else

printf "ERROR: TokuDB engine plugin is partially installed. Please cleanup manually.\n\n"

printf "For TokuDB requirements and manual steps for installation please visit this webpage:\n"

printf "http://www.percona.com/doc/percona-server/5.7/tokudb/tokudb_installation.html\n\n"

exit 1

fi

fi

# Check RocksDB engine plugin status

if [ ${ENABLE_ROCKSDB} = 1 -o ${DISABLE_ROCKSDB} = 1 ]; then

printf "Checking RocksDB engine plugin status...\n"

STATUS_ROCKSDB_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "ROCKSDB")

if [ ${STATUS_ROCKSDB_PLUGIN} = 0 ]; then

printf "INFO: RocksDB engine plugin is not installed.\n\n"

elif [ ${STATUS_ROCKSDB_PLUGIN} -gt 11 ]; then

printf "INFO: RocksDB engine plugin is installed.\n\n"

else

printf "ERROR: RocksDB engine plugin is partially installed. Please cleanup manually.\n\n"

exit 1

fi

fi

# Check TokuDB backup plugin status

if [ ${ENABLE_TOKUBACKUP} = 1 -o ${DISABLE_TOKUBACKUP} = 1 ]; then

printf "Checking TokuBackup plugin status...\n"

STATUS_HOTBACKUP_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "tokudb_backup")

if [ ${STATUS_HOTBACKUP_PLUGIN} = 0 ]; then

printf "INFO: TokuBackup plugin is not installed.\n\n"

else

printf "INFO: TokuBackup plugin is installed.\n\n"

fi

fi

# Check Audit Log plugin status

if [ ${ENABLE_AUDIT} = 1 -o ${DISABLE_AUDIT} = 1 ]; then

printf "Checking Audit Log plugin status...\n"

STATUS_AUDIT_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "audit_log")

if [ ${STATUS_AUDIT_PLUGIN} = 0 ]; then

printf "INFO: Audit Log plugin is not installed.\n\n"

else

printf "INFO: Audit Log plugin is installed.\n\n"

fi

fi

# Check PAM plugin status

if [ ${ENABLE_PAM} = 1 -o ${DISABLE_PAM} = 1 ]; then

printf "Checking PAM plugin status...\n"

STATUS_PAM_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "auth_pam#")

if [ ${STATUS_PAM_PLUGIN} = 0 ]; then

printf "INFO: PAM Authentication plugin is not installed.\n\n"

else

printf "INFO: PAM Authentication plugin is installed.\n\n"

fi

fi

# Check PAM compat plugin status

if [ ${ENABLE_PAM_COMPAT} = 1 -o ${DISABLE_PAM_COMPAT} = 1 ]; then

printf "Checking PAM compat plugin status...\n"

STATUS_PAM_COMPAT_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "auth_pam_compat#")

if [ ${STATUS_PAM_COMPAT_PLUGIN} = 0 ]; then

printf "INFO: PAM Compat Authentication plugin is not installed.\n\n"

else

printf "INFO: PAM Compat Authentication plugin is installed.\n\n"

fi

fi

# Check MySQL X plugin status

if [ ${ENABLE_MYSQLX} = 1 -o ${DISABLE_MYSQLX} = 1 ]; then

printf "Checking MySQL X plugin status...\n"

STATUS_MYSQLX_PLUGIN=$(echo "${LIST_PLUGINS}" | grep -c "mysqlx")

if [ ${STATUS_MYSQLX_PLUGIN} = 0 ]; then

printf "INFO: MySQL X plugin is not installed.\n\n"

else

printf "INFO: MySQL X plugin is installed.\n\n"

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 "Adding preload-hotbackup option into ${DEFAULTS_FILE}\n"

for MYCNF_SECTION in mysqld_safe MYSQLD_SAFE

do

STATUS_MYSQLD_SAFE=$(grep -c "^\[${MYCNF_SECTION}\]$" ${DEFAULTS_FILE})

if [ ${STATUS_MYSQLD_SAFE} != 0 ]; then

MYSQLD_SAFE_SECTION=${MYCNF_SECTION}

break

fi

done

if [ ${STATUS_MYSQLD_SAFE} = 0 ]; then

echo -e "\n[mysqld_safe]\npreload-hotbackup" >> ${DEFAULTS_FILE}

else

sed -i "/^\[${MYSQLD_SAFE_SECTION}\]$/a preload-hotbackup" ${DEFAULTS_FILE}

fi

if [ $? -eq 0 ]; then

printf "INFO: Successfully added preload-hotbackup option into ${DEFAULTS_FILE}\n";

printf "PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!\n\n";

exit 0

else

printf "ERROR: Failed to add preload-hotbackup option into ${DEFAULTS_FILE}\n\n";

exit 1

fi

fi

elif [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_JEMALLOC_CONFIG} = 0 ] || [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then

printf "Adding LD_PRELOAD variable into ${SYSTEMD_ENV_FILE}\n"

NEW_LD_PRELOAD=""

FILE_ADD=""

if [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_JEMALLOC_CONFIG} = 0 ] && [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then

NEW_LD_PRELOAD="${JEMALLOC_LOCATION} ${HOTBACKUP_LOCATION}"

FILE_ADD="libjemalloc.so.1 and libHotBackup.so"

elif [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_JEMALLOC_CONFIG} = 0 ]; then

NEW_LD_PRELOAD="${JEMALLOC_LOCATION}"

FILE_ADD="libjemalloc.so.1"

elif [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_MYCNF} = 0 ]; then

NEW_LD_PRELOAD="${HOTBACKUP_LOCATION}"

FILE_ADD="libHotBackup.so"

fi

# Add desired LD_PRELOAD into config file

if [ ! -f ${SYSTEMD_ENV_FILE} ]; then

echo "LD_PRELOAD=${NEW_LD_PRELOAD}" > ${SYSTEMD_ENV_FILE}

elif [ $(grep -c LD_PRELOAD ${SYSTEMD_ENV_FILE}) = 0 ]; then

echo "LD_PRELOAD=${NEW_LD_PRELOAD}" >> ${SYSTEMD_ENV_FILE}

else

sed -i '/^LD_PRELOAD=/ s:$: '"${NEW_LD_PRELOAD}"':' ${SYSTEMD_ENV_FILE}

fi

# Print status

if [ $? -eq 0 ]; then

printf "INFO: Successfully added LD_PRELOAD variable for ${FILE_ADD} into ${SYSTEMD_ENV_FILE}\n\n";

printf "PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!\n\n";

exit 0

else

printf "ERROR: Failed to add LD_PRELOAD variable for ${FILE_ADD} into ${SYSTEMD_ENV_FILE}\n\n";

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 "Checking if Percona Server is running with libHotBackup.so preloaded...\n"

STATUS_LIBHOTBACKUP=$(grep -c libHotBackup.so /proc/${PID_NUM}/environ)

if [ $STATUS_LIBHOTBACKUP = 0 ]; then

printf "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";

exit 1

else

printf "INFO: Percona Server is running with libHotBackup.so preloaded.\n\n";

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 "Disabling transparent huge pages for the current session...\n"

if test -f /sys/kernel/mm/transparent_hugepage/defrag; then

echo never > /sys/kernel/mm/transparent_hugepage/defrag

fi

if test -f /sys/kernel/mm/transparent_hugepage/enabled; then

echo never > /sys/kernel/mm/transparent_hugepage/enabled

fi

if [ $? -eq 0 ]; then

printf "INFO: Successfully disabled transparent huge pages for this session.\n\n"

else

printf "ERROR: Failed to disable transparent huge pages for this session.\n\n"

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 "Adding thp-setting=never option into ${DEFAULTS_FILE}\n"

for MYCNF_SECTION in mysqld_safe MYSQLD_SAFE

do

STATUS_MYSQLD_SAFE=$(grep -c "^\[${MYCNF_SECTION}\]$" ${DEFAULTS_FILE})

if [ ${STATUS_MYSQLD_SAFE} != 0 ]; then

MYSQLD_SAFE_SECTION=${MYCNF_SECTION}

break

fi

done

if [ ${STATUS_MYSQLD_SAFE} = 0 ]; then

echo -e "\n[mysqld_safe]\nthp-setting=never" >> ${DEFAULTS_FILE}

else

sed -i "/^\[${MYSQLD_SAFE_SECTION}\]$/a thp-setting=never" ${DEFAULTS_FILE}

fi

if [ $? -eq 0 ]; then

printf "INFO: Successfully added thp-setting=never option into ${DEFAULTS_FILE}\n\n";

else

printf "ERROR: Failed to add thp-setting=never option into ${DEFAULTS_FILE}\n\n";

exit 1

fi

else

printf "Adding THP_SETTING=never variable into ${SYSTEMD_ENV_FILE}\n"

echo -e "THP_SETTING=never" >> ${SYSTEMD_ENV_FILE}

if [ $? -eq 0 ]; then

printf "INFO: Successfully added THP_SETTING=never option into ${SYSTEMD_ENV_FILE}\n\n";

else

printf "ERROR: Failed to add THP_SETTING=never option into ${SYSTEMD_ENV_FILE}\n\n";

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 "Removing thp-setting=never option from ${DEFAULTS_FILE}\n"

sed -i '/^thp-setting=never$/d' ${DEFAULTS_FILE}

if [ $? -eq 0 ]; then

printf "INFO: Successfully removed thp-setting=never option from ${DEFAULTS_FILE}\n\n";

else

printf "ERROR: Failed to remove thp-setting=never option from ${DEFAULTS_FILE}\n\n";

exit 1

fi

else

printf "Removing THP_SETTING variable from ${SYSTEMD_ENV_FILE}\n"

sed -i '/^THP_SETTING=/d' ${SYSTEMD_ENV_FILE}

if [ $? -eq 0 ]; then

printf "INFO: Successfully removed THP_SETTING variable from ${SYSTEMD_ENV_FILE}\n\n";

else

printf "ERROR: Failed to remove THP_SETTING variable from ${SYSTEMD_ENV_FILE}\n\n";

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 "Removing preload-hotbackup option from ${DEFAULTS_FILE}\n"

sed -i '/^preload-hotbackup$/d' ${DEFAULTS_FILE}

if [ $? -eq 0 ]; then

printf "INFO: Successfully removed preload-hotbackup option from ${DEFAULTS_FILE}\n\n";

else

printf "ERROR: Failed to remove preload-hotbackup option from ${DEFAULTS_FILE}\n\n";

exit 1

fi

fi

elif [ ${DISABLE_TOKUDB} = 1 -o ${DISABLE_TOKUBACKUP} = 1 ]; then

printf "Removing LD_PRELOAD option from ${SYSTEMD_ENV_FILE}\n"

if [ ${DISABLE_TOKUDB} = 1 -a ${DISABLE_TOKUBACKUP} = 1 ]; then

sed -i '/^LD_PRELOAD/d' ${SYSTEMD_ENV_FILE}

FILE_REMOVE="libjemalloc.so.1 and libHotBackup.so"

else

NEW_LD_PRELOAD=""

if [ ${DISABLE_TOKUDB} = 1 ]; then

FILE_REMOVE="libjemalloc.so.1"

else

FILE_REMOVE="libHotBackup.so"

fi

for file in $(cat ${SYSTEMD_ENV_FILE}|awk -v var="${FILE_REMOVE}" -F ' ' '/LD_PRELOAD/{for(i=1;i<=NF;++i)if($i !~ var)print $i}'|sed 's/LD_PRELOAD=//')

do

NEW_LD_PRELOAD="${file} "

done

NEW_LD_PRELOAD=$(echo "LD_PRELOAD=${NEW_LD_PRELOAD}"|sed 's/[ ]*$//')

sed -i 's:^LD_PRELOAD=.*:'"${NEW_LD_PRELOAD}"':' ${SYSTEMD_ENV_FILE}

fi

if [ $? -eq 0 ]; then

printf "INFO: Successfully removed LD_PRELOAD option for ${FILE_REMOVE} from ${SYSTEMD_ENV_FILE}\n\n";

else

printf "ERROR: Failed to remove LD_PRELOAD option for ${FILE_REMOVE} from ${SYSTEMD_ENV_FILE}\n\n";

exit 1

fi

fi

# Install TokuDB engine plugin

if [ ${ENABLE_TOKUDB} = 1 -a ${STATUS_TOKUDB_PLUGIN} = 0 ]; then

printf "Installing TokuDB engine...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2>/dev/null<<EOFTOKUDBENABLE

INSTALL PLUGIN TokuDB SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_file_map SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_fractal_tree_info SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_fractal_tree_block_map SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_trx SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_locks SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_lock_waits SONAME 'ha_tokudb.so';

INSTALL PLUGIN TokuDB_background_job_status SONAME 'ha_tokudb.so';

EOFTOKUDBENABLE

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed TokuDB engine plugin.\n\n"

else

printf "ERROR: Failed to install TokuDB engine plugin. Please check error log.\n\n"

exit 1

fi

fi

# Install RocksDB engine plugin

if [ ${ENABLE_ROCKSDB} = 1 -a ${STATUS_ROCKSDB_PLUGIN} = 0 ]; then

printf "Installing RocksDB engine...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2>/dev/null<<EOFROCKSDBENABLE

INSTALL PLUGIN ROCKSDB SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_CFSTATS SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_DBSTATS SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_PERF_CONTEXT SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_PERF_CONTEXT_GLOBAL SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_CF_OPTIONS SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_GLOBAL_INFO SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_COMPACTION_HISTORY SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_COMPACTION_STATS SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_ACTIVE_COMPACTION_STATS SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_DDL SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_INDEX_FILE_MAP SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_LOCKS SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_TRX SONAME 'ha_rocksdb.so';

INSTALL PLUGIN ROCKSDB_DEADLOCK SONAME 'ha_rocksdb.so';

EOFROCKSDBENABLE

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed RocksDB engine plugin.\n\n"

else

printf "ERROR: Failed to install RocksDB engine plugin. Please check error log.\n\n"

exit 1

fi

fi

# Install Audit Log plugin

if [ ${ENABLE_AUDIT} = 1 -a ${STATUS_AUDIT_PLUGIN} = 0 ]; then

printf "Installing Audit Log plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "INSTALL PLUGIN audit_log SONAME 'audit_log.so';" 2>/dev/null

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed Audit Log plugin.\n\n"

else

printf "ERROR: Failed to install Audit Log plugin. Please check error log.\n\n"

exit 1

fi

fi

# Install PAM plugin

if [ ${ENABLE_PAM} = 1 -a ${STATUS_PAM_PLUGIN} = 0 ]; then

printf "Installing PAM Authentication plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "INSTALL PLUGIN auth_pam SONAME 'auth_pam.so';" 2>/dev/null

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed PAM Authentication plugin.\n\n"

else

printf "ERROR: Failed to install PAM Authentication plugin. Please check error log.\n\n"

exit 1

fi

fi

# Install PAM compat plugin

if [ ${ENABLE_PAM_COMPAT} = 1 -a ${STATUS_PAM_COMPAT_PLUGIN} = 0 ]; then

printf "Installing PAM Compat Authentication plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "INSTALL PLUGIN auth_pam_compat SONAME 'auth_pam_compat.so';" 2>/dev/null

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed PAM Compat Authentication plugin.\n\n"

else

printf "ERROR: Failed to install PAM Compat Authentication plugin. Please check error log.\n\n"

exit 1

fi

fi

# Install MySQL X plugin

if [ ${ENABLE_MYSQLX} = 1 -a ${STATUS_MYSQLX_PLUGIN} = 0 ]; then

printf "Installing MySQL X plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';" 2>/dev/null

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed MySQL X plugin.\n\n"

else

printf "ERROR: Failed to install MySQL X plugin. Please check error log.\n\n"

exit 1

fi

fi

# Install TokuDB backup plugin

if [ ${ENABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_PLUGIN} = 0 ]; then

printf "Installing TokuBackup plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2>/dev/null<<EOFTOKUBACKUPENABLE

INSTALL PLUGIN tokudb_backup SONAME 'tokudb_backup.so';

EOFTOKUBACKUPENABLE

if [ $? -eq 0 ]; then

printf "INFO: Successfully installed TokuBackup plugin.\n\n"

else

printf "ERROR: Failed to install TokuBackup plugin. Please check error log.\n\n"

exit 1

fi

fi

# Uninstall TokuDB backup plugin

if [ ${DISABLE_TOKUBACKUP} = 1 -a ${STATUS_HOTBACKUP_PLUGIN} = 1 ]; then

printf "Uninstalling TokuBackup plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} 2>/dev/null<<EOFTOKUBACKUPDISABLE

UNINSTALL PLUGIN tokudb_backup;

EOFTOKUBACKUPDISABLE

if [ $? -eq 0 ]; then

printf "INFO: Successfully uninstalled TokuBackup plugin.\n\n"

else

printf "ERROR: Failed to uninstall TokuBackup plugin. Please check error log.\n\n"

exit 1

fi

fi

# Uninstall TokuDB engine plugin

if [ ${DISABLE_TOKUDB} = 1 -a ${STATUS_TOKUDB_PLUGIN} -gt 0 ]; then

printf "Uninstalling TokuDB engine plugin...\n"

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 "${LIST_PLUGINS}" | grep -c "${plugin}#")

if [ ${SPECIFIC_PLUGIN_STATUS} -gt 0 ]; then

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "UNINSTALL PLUGIN ${plugin};" 2>/dev/null

if [ $? -ne 0 ]; then

printf "ERROR: Failed to uninstall TokuDB engine plugin. Please check error log.\n\n"

exit 1

fi

fi

done

printf "INFO: Successfully uninstalled TokuDB engine plugin.\n\n"

fi

# Uninstall RocksDB engine plugin

if [ ${DISABLE_ROCKSDB} = 1 -a ${STATUS_ROCKSDB_PLUGIN} -gt 0 ]; then

printf "Uninstalling RocksDB engine plugin...\n"

for plugin in ROCKSDB ROCKSDB_CFSTATS ROCKSDB_DBSTATS ROCKSDB_PERF_CONTEXT_GLOBAL ROCKSDB_PERF_CONTEXT ROCKSDB_CF_OPTIONS ROCKSDB_GLOBAL_INFO ROCKSDB_COMPACTION_HISTORY ROCKSDB_COMPACTION_STATS ROCKSDB_ACTIVE_COMPACTION_STATS ROCKSDB_DDL ROCKSDB_INDEX_FILE_MAP ROCKSDB_LOCKS ROCKSDB_TRX ROCKSDB_DEADLOCK; do

SPECIFIC_PLUGIN_STATUS=$(echo "${LIST_PLUGINS}" | grep -c "${plugin}#")

if [ ${SPECIFIC_PLUGIN_STATUS} -gt 0 ]; then

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "UNINSTALL PLUGIN ${plugin};" 2>/dev/null

if [ $? -ne 0 ]; then

printf "ERROR: Failed to uninstall RocksDB engine plugin. Please check error log.\n\n"

exit 1

fi

fi

done

printf "INFO: Successfully uninstalled RocksDB engine plugin.\n\n"

fi

# Uninstall Audit Log plugin

if [ ${DISABLE_AUDIT} = 1 -a ${STATUS_AUDIT_PLUGIN} -gt 0 ]; then

printf "Uninstalling Audit Log plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "UNINSTALL PLUGIN audit_log;" 2>/dev/null

if [ $? -ne 0 ]; then

printf "ERROR: Failed to uninstall Audit Log plugin. Please check error log.\n\n"

exit 1

else

printf "INFO: Successfully uninstalled Audit Log plugin.\n\n"

fi

fi

# Uninstall PAM plugin

if [ ${DISABLE_PAM} = 1 -a ${STATUS_PAM_PLUGIN} -gt 0 ]; then

printf "Uninstalling PAM Authentication plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "UNINSTALL PLUGIN auth_pam;" 2>/dev/null

if [ $? -ne 0 ]; then

printf "ERROR: Failed to uninstall PAM Authentication plugin. Please check error log.\n\n"

exit 1

else

printf "INFO: Successfully uninstalled PAM Authentication plugin.\n\n"

fi

fi

# Uninstall PAM compat plugin

if [ ${DISABLE_PAM_COMPAT} = 1 -a ${STATUS_PAM_COMPAT_PLUGIN} -gt 0 ]; then

printf "Uninstalling PAM Compat Authentication plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "UNINSTALL PLUGIN auth_pam_compat;" 2>/dev/null

if [ $? -ne 0 ]; then

printf "ERROR: Failed to uninstall PAM Compat Authentication plugin. Please check error log.\n\n"

exit 1

else

printf "INFO: Successfully uninstalled PAM Compat Authentication plugin.\n\n"

fi

fi

# Uninstall MySQL X plugin

if [ ${DISABLE_MYSQLX} = 1 -a ${STATUS_MYSQLX_PLUGIN} -gt 0 ]; then

printf "Uninstalling MySQL X plugin...\n"

${MYSQL_CLIENT_BIN} -u ${USER} ${PASSWORD} ${SOCKET} ${HOST} ${PORT} -e "UNINSTALL PLUGIN mysqlx;" 2>/dev/null

if [ $? -ne 0 ]; then

printf "ERROR: Failed to uninstall MySQL X plugin. Please check error log.\n\n"

exit 1

else

printf "INFO: Successfully uninstalled MySQL X plugin.\n\n"

fi

fi