Moogsoft Onprem Online Tarball Pre-installation

Install all the Percona MySQL dependency RPMs by running the following command (This step requires root privileges):

yum -y install haproxy perl-Carp perl-constant perl-Data-Dumper perl-DBD-SQLite perl-DBI perl-Encode perl-Errno perl-Exporter perl-File-Path perl-File-Temp perl-Getopt-Long perl-HTTP-Tiny perl-interpreter perl-IO perl-libs perl-macros perl-Math-BigInt perl-Math-Complex perl-MIME-Base64 perl-parent perl-PathTools perl-Pod-Escapes perl-podlators perl-Pod-Perldoc perl-Pod-Simple perl-Pod-Usage perl-Scalar-List-Utils perl-Socket perl-Storable perl-Term-ANSIColor perl-Term-Cap perl-Text-ParseWords perl-threads perl-threads-shared perl-Time-Local perl-Unicode-Normalize rsync lsof make ncurses-compat-libs perl-URI perl-libnet perl-IO-Socket-IP perl-Digest-MD5 perl-Digest perl-Error perl-Git perl-TermReadKey git git-core git-core-doc xinetd libev mariadb-connector-c mariadb-connector-c-config python2 python2-libs python2-pip-wheel python2-setuptools-wheel python2-pip python2-setuptools perl-IO-Socket-SSL perl-Net-SSLeay perl-DBD-MySQL perl-Mozilla-CA perl-Text-Tabs+Wrap socat pkg-config mkfontdir logrotate

REPO_URL=https://repo.percona.com/yum/release/8/RPMS/x86_64;
RPM_FILE=$(curl -s -L ${REPO_URL} 2>/dev/null | egrep ">qpress-[0-9]+" | sed "s/.*\(qpress.*.rpm\).*/\1/" | tail -n 1)
yum -y install ${REPO_URL}/${RPM_FILE}

Install Kernel Asynchronous I/O (AIO) Support for Linux. For example (run the whole codeblock as one command):

LIBAIO_RPM=$(curl http://mirror.centos.org/centos/8-stream/BaseOS/x86_64/os/Packages/ 2>/dev/null | egrep '>libaio-[0-9].*x86_64' | sed -E 's/.*(libaio-.*.rpm).*/\1/' | tail -n 1)

mkdir -p ~/install/libraries/ && cd ~/install/libraries/;
curl -s -L -O --connect-timeout 10 --retry 5 --retry-delay 1 --retry-max-time 45 http://mirror.centos.org/centos/8-stream/BaseOS/x86_64/os/Packages/${LIBAIO_RPM}
rpm2cpio ./${LIBAIO_RPM} | cpio -idmv && \
rm -f ./${LIBAIO_RPM} && \
rm -f ~/install/libraries/usr/lib64/libaio.so.1 && \
ln -s ~/install/libraries/usr/lib64/libaio.so.1.0.1 ~/install/libraries/usr/lib64/libaio.so.1

source ~/.bashrc

cd -

Install libquadmath and libgfortran. For example:

cd ~/install/libraries/

LIBQUADMATH_RPM=$(curl -L http://vault.centos.org/8-stream/BaseOS/x86_64/os/Packages/ 2>/dev/null | egrep '>libquadmath-[0-9].*x86_64' | sed -E 's/.*(libquadmath-.*.rpm).*/\1/' | tail -n 1)
LIBGFORTRAN_RPM=$(curl -L http://vault.centos.org/8-stream/BaseOS/x86_64/os/Packages/ 2>/dev/null | egrep '>libgfortran-[0-9].*x86_64' | sed -E 's/.*(libgfortran-.*.rpm).*/\1/' | tail -n 1)
for PACKAGE in "${LIBQUADMATH_RPM}" "${LIBGFORTRAN_RPM}";
do
	curl -s -L -O --connect-timeout 10 --retry 5 --retry-delay 1 --retry-max-time 45 http://mirror.centos.org/centos/8-stream/BaseOS/x86_64/os/Packages/$PACKAGE
	rpm2cpio $PACKAGE | cpio -idmv && \
	rm -f $PACKAGE
done

COMPAT_LIBGFORTRAN_RPM=$(curl -L http://vault.centos.org/8-stream/AppStream/x86_64/os/Packages/ 2>/dev/null | egrep '>compat-libgfortran-48-[0-9].*x86_64' | sed -E 's/.*(compat-libgfortran-48-.*.rpm).*/\1/' | tail -n 1)
for PACKAGE in "${COMPAT_LIBGFORTRAN_RPM}";
do
	curl -s -L -O --connect-timeout 10 --retry 5 --retry-delay 1 --retry-max-time 45 http://vault.centos.org/8-stream/AppStream/x86_64/os/Packages/${PACKAGE}
	rpm2cpio ${PACKAGE} | cpio -idmv && \
	rm -f ${PACKAGE}
done

echo "export LD_LIBRARY_PATH=$(pwd)/usr/lib64:\$LD_LIBRARY_PATH" >> ~/.bashrc
source ~/.bashrc

cd -

Download the Percona database installer on all servers that will house a database node. The script configures multiple nodes to run as a cluster. A single node is also supported. Substitute your "speedy" Yum repo user credentials:

cat > aiops_repo.sh << _EOF_
#!/bin/bash
clear
echo "Please provide access credentials for the 'speedy' yum repository in order to run the Percona setup script"
echo
read -p "AIOps Repository Username: " AIOPS_USER
export AIOPS_USER
read -p "AIOps Repository Password: " -s AIOPS_PASS
export AIOPS_PASS
curl -L -O https://\$AIOPS_USER:\$AIOPS_PASS@speedy.moogsoft.com/v9/install_percona_nodes_tarball.sh 2>/dev/null
echo
_EOF_
bash aiops_repo.sh

Execute the .bashrc file:

source ~/.bashrc

Run the following command to set the vm.swappiness system property to the needed value:

echo 'vm.swappiness=1' >> /etc/sysctl.conf;

Then apply the new property value using this command (requires root/sudo permissions):

sudo sysctl -p