The following tutorial discusses upgrading PHP and MariaDb whilst updating to the latest version of SVM. The following video details step by step, with a copy of the instructions below;
https://www.youtube.com/watch?v=GoZcFx_wQFc
Backup Existing Databases;
mysqldump ca | gzip > ca.sql.gz
mysqldump ca_CstID | gzip > ca_CstID.sql.gz (Replace CstID with Customer Number)
mysqldump --all-databases | gzip > complete.sql.gz
Perform the PHP Upgrade;
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
yum install -y yum-utils
yum-config-manager --enable remi-php72
yum update -y (commit changes)
Perform the MariaDb Upgrade;
systemctl stop mariadb
yum remove mariadb-server mariadb mariadb-libs (This will remove SVM/CSI RPM)
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadbserver-version="mariadb-10.3"
yum update -y (to commit the changes to the MariaDB Repo)
yum clean all
Install SVM Pre-requisites;
yum -y install curl httpd MariaDB-server MariaDB-client ntp perl-Compress-Zlib php php-gd php-ldap php-mysqlnd php-pecl-zip php-xml rpm-build policycoreutils-python haproxy yum-cron
Sample entry for /etc/my.cnf
The following is based on 16Gb RAM and 3,500 hosts. Please consult with Flexera Support for the correct settings for your environment. There are other files that need to be modified, the requirement is the ‘[mysqld]’ statement and the ‘sql_mode’ setting.
[mysqld]
sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_autoinc_lock_mode = 2
innodb_flush_method = O_DIRECT
innodb_buffer_pool_size = 2G
table_open_cache = 4500
max_heap_table_size = 32M
tmp_table_size = 32M
key_buffer_size = 150M
max_connections = 1200
open_files_limit = 7000
thread_cache_size = 130
query_cache_size = 100M
query_cache_type= ON
query_cache_limit= 512K
# innodb_force_recovery=1
innodb_purge_threads=0
