3,704
edits
Changes
Jump to navigation
Jump to search
mLine 1:
Line 1: + + + Line 6:
Line 9: − + − + Line 164:
Line 167: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Line 247:
Line 279: + + +
Add link to scl
{{Level|Medium}}
{{Note box|For SME Server 9.x (64-bit), we advise you to use [http://wiki.contribs.org/Software_collections Software Collections]}}
==Install MariaDB alongside MySQL==
==Install MariaDB alongside MySQL==
MariaDB is a drop in replacement for MySQL, but you can also install it alongside MySQL.
MariaDB is a drop in replacement for MySQL, but you can also install it alongside MySQL.
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/
IMPORTANT: Do not use yum for an 'alongside' ('side-by-side') installation of mariadb.
{{warning box|IMPORTANT: Do not use yum for an 'alongside' ('side-by-side') installation of mariadb.}}
====Create service account====
====Create service account====
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===
CONNECT=--socket=/opt/mariadb-data/mariadb.sock
CONNECT=--socket=/opt/mariadb-data/mariadb.sock
mysql $CONNECT < <dbname>.dump</nowiki>
mysql $CONNECT < <dbname>.dump</nowiki>
[[Category:Howto]]