688
edits
Changes
From SME Server
Jump to navigationJump to searchUpgrade from 5.5.34 to 10.0.12
MariaDB or MySQL can both be installed in an alongside or side-by-side configuration, but MariaDB maintains binary executables compatible with CentOS 5 & 6 and MySQL does not (at least, I could not find any).
MariaDB or MySQL can both be installed in an alongside or side-by-side configuration, but MariaDB maintains binary executables compatible with CentOS 5 & 6 and MySQL does not (at least, I could not find any).
===Installation===
===Install===
These installation notes are taken from https://mariadb.com/kb/en/installing-mariadb-alongside-mysql/
These installation notes are taken from https://mariadb.com/kb/en/installing-mariadb-alongside-mysql/
mysql -e "SELECT VERSION();" --socket=/opt/mariadb-data/mariadb.sock
mysql -e "SELECT VERSION();" --socket=/opt/mariadb-data/mariadb.sock
</nowiki>
</nowiki>
===Upgrade===
====Upgrade to Mariadb v10.0.12====
<nowiki>#
# updating mariadb side-by-side
#
# Download the latest release and extract it into /opt/mariadb-x.y.z-linux-i686
RELEASE=10.0.12
mkdir -p ~/addons/mariadb
cd ~/addons/mariadb/
wget https://downloads.mariadb.org/f/mariadb-$RELEASE/bintar-centos5-x86/mariadb-$RELEASE-linux-i686.tar.gz
cd /opt
tar zxvf ~/addons/mariadb-$RELEASE-linux-i686.tar.gz
#
# install libaio (new mariadb dependency, available from the 'base' repository)
yum install libaio
#
# stop mariadb
/etc/init.d/mariadb stop
#
# link /opt/mariadb to the new version
rm mariadb
ln -s mariadb-$RELEASE-linux-i686 mariadb
#
# restart mariadb
/etc/init.d/mariadb start
</nowiki>
====Verify the new version====
mysql -e "SELECT VERSION();" --socket=/opt/mariadb-data/mariadb.sock
===Gotchas===
===Gotchas===
