#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
https://downloads.mariadb.org/mariadb/repositories/#mirror=osuosl

#You should get 
#start copy paste here
# MariaDB 10.0 CentOS repository list - created 2016-08-13 17:06 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[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.