Moogsoft Onprem Offline Tarball Pre-installation

Create a directory for the downloaded files. You will collect the downloaded files in this directory and then move these files to the working directory.

mkdir preinstall_files
cd preinstall_files

Download Percona dependencies (including haproxy):

dnf download 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 emacs-filesystem less openssh-clients iproute iproute-tc numactl-libs logrotate pkg-config mkfontdir --downloadonly --downloaddir=. --forcearch=x86_64 --exclude=*.i686

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)
curl -s -L -O ${REPO_URL}/${RPM_FILE}

Download Percona files:

curl -L -O https://downloads.percona.com/downloads/Percona-XtraDB-Cluster-80/Percona-XtraDB-Cluster-8.0.35/binary/tarball/Percona-XtraDB-Cluster_8.0.35-27.1_Linux.x86_64.glibc2.17.tar.gz;

curl -L -O https://downloads.percona.com/downloads/Percona-XtraBackup-8.0/Percona-XtraBackup-8.0.35-30/binary/tarball/percona-xtrabackup-8.0.35-30-Linux-x86_64.glibc2.17.tar.gz;

Download the Percona installer script and Moogsoft Onprem installer files. Substitute your "speedy" Yum repo user credentials in the following commands, or download the files in a web browser then copy them to the applicable server):

curl -L -O "https://<username>:<password>@speedy.moogsoft.com/v9/install_percona_nodes_tarball.sh"
curl -L -O "https://<username>:<password>@speedy.moogsoft.com/v9/installer/moogsoft-enterprise-9.1.0.tgz.sig"
curl -L -O "https://<username>:<password>@speedy.moogsoft.com/v9/installer/moogsoft-enterprise-9.1.0.tgz"

Compress the downloaded files in the preinstall_files directory:

cd ..
tar -czvf preinstall_files9.1.0.tgz preinstall_files

Copy preinstall_files9.1.0.tgz to each Moogsoft Onprem server's working directory.

Download some non-Percona dependency RPMs:

LIBAIO_RPM=$(curl http://vault.centos.org/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)
curl -s -L -O --connect-timeout 10 --retry 5 --retry-delay 1 --retry-max-time 45 http://vault.centos.org/8-stream/BaseOS/x86_64/os/Packages/${LIBAIO_RPM}

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://vault.centos.org/8-stream/BaseOS/x86_64/os/Packages/$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-.*x86_64.rpm" | grep -v devel | sed -e 's/.*href="//' -e 's/.rpm.*/.rpm/' | 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}
done

Copy the libaio, libquadmath, libgfortran, and compat-libgfortran RPMs to the install server's working directory

On the install server, extract the preinstall_files.tgz file and install all the dependency RPMs:

tar -xf preinstall_files9.1.0.tgz
yum install preinstall_files/*.rpm

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