#!/bin/sh

mkdir mariadb
cd mariadb

echo "Downloading necessary RPM of 10.2.18 and 10.2.27" 
wget http://ftp.hosteurope.de/mirror/archive.mariadb.org//mariadb-10.2.18/yum/centos74-amd64/rpms/MariaDB-10.2.18-centos73-x86_64-client.rpm
wget http://ftp.hosteurope.de/mirror/archive.mariadb.org//mariadb-10.2.18/yum/centos74-amd64/rpms/MariaDB-10.2.18-centos73-x86_64-server.rpm
wget http://mirror.netinch.com/pub/mariadb//mariadb-10.2.27/yum/centos74-amd64/rpms/MariaDB-client-10.2.27-1.el7.centos.x86_64.rpm
wget http://mirror.netinch.com/pub/mariadb//mariadb-10.2.27/yum/centos74-amd64/rpms/MariaDB-server-10.2.27-1.el7.centos.x86_64.rpm

echo "Installing MariaDB-client,server 10.2.18"

rpm -i MariaDB-10.2.18-centos73-x86_64-client.rpm
rpm -i MariaDB-10.2.18-centos73-x86_64-server.rpm

echo "Initiating service"
systemctl start mariadb
systemctl enable mariadb

mysql -e "show global variables like 'gtid%';"

echo "removing MariaDB Instance 10.2.18"
rpm -e MariaDB-server
rpm -e MariaDB-client
rm -f /var/log/mariadb
rm -f /var/log/mariadb/mariadb.log.rpmsave
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
rm -rf /usr/share/mysql

echo "Installing MariaDB-client,server 10.2.27"
rpm -i MariaDB-client-10.2.27-1.el7.centos.x86_64.rpm
rpm -i MariaDB-server-10.2.27-1.el7.centos.x86_64.rpm

echo "Initiating service"
systemctl start mariadb
systemctl enable mariadb

echo "Lisiting of all files"
ls /usr/lib/mysql

mysql -e "show global variables like 'gtid%';"

echo "removing MariaDB Instance 10.2.18"
rpm -e MariaDB-server
rpm -e MariaDB-client
rm -f /var/log/mariadb
rm -f /var/log/mariadb/mariadb.log.rpmsave
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
rm -rf /usr/share/mysql