All:
I could not find a solid guide on how to upgrade Interworx 5.X Mysql to MariaDB 10.x. So a few caviots MariaDB 10 is not supported currently by Interworx OR Me for that matter. BACKUP YOUR SYSTEM AND DB’S. I warned you. Try this on a test box. Dont have a test box…well buckle your seet belt here we go. I will attach the guide and copy and paste it here. Feel free to improve of change it. Please post improvement and success here…
#Interworx 5.x #Mysql to MariaBD 10.x guide
#CENTOS 7.x
#Brent Dacus 2016
#NOTES Depending on your installed server you may need to substitute maria for mysql or vise versa.
#BACKUP YOUR DB’s NOW…
#Lets do a on the system update. You should be good here but if your Naughty well here we go.
yum update -y
#need to backup config will need later.
mv /etc/my.cnf /etc/my.cnf.bak
#stop server
systemctl stop mysql OR systemctl stop mariadb
yum remove mariadb mariadb-server mariadb-libs mariadb-devel
#It should not tell you it will NOT remove dependancies!!! found it might want to
#remove net-snmp and php-snmp. I let it remove them and then reinstalled.
#Option: You could use:
rpm -e mariadb mariadb-server mariadb-libs mariadb-devel --nodeps
yum clean all
#Add new repo for MariaDB 10. you can get this on the repos generator here.
#Go her in your browser an follow the prompts
#You should get
#start copy paste here
MariaDB 10.0 CentOS repository list - created 2016-08-13 17:06 UTC
Download MariaDB Server - MariaDB.org
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
#End copy paste here.
#from cd /etc/yum.repos.d
nano mariadb10.repo
#Paste in the above repo info and save.
#Dont be tempted to run the Install command on the MariaDB website yet…
#This will update and existing items after adding the new repo.
yum update -y
#Now run. Almost there!!!
yum install MariaDB-client.x86_64 MariaDB-server.x86_64 MariaDB-common.x86_64 MariaDB-devel.x86_64 MariaDB-shared.x86_64
#Under Installed you should see only entries like “10.1.16-1.el7.centos”
yum list maria*
#Now run
systemctl start mariadb
#or
systemctl start mysql
#either should work
#Now we need to upgrade the mysql system db
mysql_upgrade --verbose -uroot -p
#Enter your Mysql root password when asked.
systemctl restart mariadb
systemctl status mariadb
#In “status” Shouldn’t se any errors
#just to be sure we are all enabled
systemctl enable mariadb
#Replace the New my.cnf with the Interworks one. We will backup the new one as well.
#Should be fine but you might want compare them.
mv /etc/my.cnf /etc/my.cnf.mdb10
mv /etc/my.cnf.bak /etc/my.cnf
systemctl restart mariadb
systemctl status mariadb
#WHEW YOU did it!!!
#login to Nodeworx and check Overview and PhpMyAdmin
#In Overview you will see the wrong Version listes as 5.5.5
#In PhpMyAdmin you should the correct Server version.
Interworx MariaDB 10 Upgrade.txt (2.55 KB)