Mysql – How to upgrade MySQL 5.6 to MariaDB

freebsdmariadbMySQLupgrade

We are using MySQL 5.6 on a productive Server which we want to migrate to MariaDB. Many reasons – but the main reason is the way the Master <-> Master Replication on MariaDB is working.

There are many Drop in REplacement Guides regarding Crossgrade from MySQL 5.5 to Mariadb (which also worked in our tests), BUT in our tests the mariadb drop in replacement did not work properly when executed on an MySQL 5.6 based Machine.

Is there any Hint on how this could work?

Bonus Point for Hints how this is done on Freebsd 10.0

Best Answer

Drop-in replacement for MySQL-5.6 is MariaDB-10.0.x, not the 5.5 release. And even then I'm not sure all features of Mysql already ported to the MariaDB.

At the time current version of databases/mariadb100-server is 10.0.17. You can replace ports this way:

pkg delete -f mysql56-server
pkg delete -f mysql56-client
make -C /usr/ports/databases/mariadb100-server install clean

I hope you'll try all that on the test machine first.

LATEST VERSION

To install the latest version as of today (MySQL 5.6.10) run this:

HOWMANYBITS=64
WHATOS=5
BINARY_VERSION=000
if [ ${HOWMANYBITS} -eq 32 ] ; then BINARY_VERSION=i386   ; fi
if [ ${HOWMANYBITS} -eq 64 ] ; then BINARY_VERSION=x86_64 ; fi
MYSQL_RELEASE=`curl -L http://www.mysql.com/downloads 2> /dev/null | grep 'Current Generally Available Release' | grep 'MySQL Community Server' | sed 's/.*Available Release://' | sed 's/)/ /g' | awk '{print $1}'`
MAJOR_RELEASE="`echo ${MYSQL_RELEASE} | sed 's/\./ /g' | awk '{print $1}'`.`echo ${MYSQL_RELEASE} | sed 's/\./ /g' | awk '{print $2}'`"
OS_VERSION=000
if [ ${WHATOS} -eq 0 ] ; then OS_VERSION=linux2.6 ; fi
if [ ${WHATOS} -eq 5 ] ; then OS_VERSION=rhel5    ; fi
if [ ${WHATOS} -eq 6 ] ; then OS_VERSION=el6    ; fi
RELEASE_TAG=1
DEVEL__RPM=http://www.mysql.com/get/Downloads/MySQL-${MAJOR_RELEASE}/MySQL-devel-${MYSQL_RELEASE}-${RELEASE_TAG}.${OS_VERSION}.${BINARY_VERSION}.rpm/from/http://mysql.mirrors.pair.com/
SHARD2_RPM=http://www.mysql.com/get/Downloads/MySQL-${MAJOR_RELEASE}/MySQL-shared-compat-${MYSQL_RELEASE}-${RELEASE_TAG}.${OS_VERSION}.${BINARY_VERSION}.rpm/from/http://mysql.mirrors.pair.com/
SHARED_RPM=http://www.mysql.com/get/Downloads/MySQL-${MAJOR_RELEASE}/MySQL-shared-${MYSQL_RELEASE}-${RELEASE_TAG}.${OS_VERSION}.${BINARY_VERSION}.rpm/from/http://mysql.mirrors.pair.com/
CLIENT_RPM=http://www.mysql.com/get/Downloads/MySQL-${MAJOR_RELEASE}/MySQL-client-${MYSQL_RELEASE}-${RELEASE_TAG}.${OS_VERSION}.${BINARY_VERSION}.rpm/from/http://mysql.mirrors.pair.com/
SERVER_RPM=http://www.mysql.com/get/Downloads/MySQL-${MAJOR_RELEASE}/MySQL-server-${MYSQL_RELEASE}-${RELEASE_TAG}.${OS_VERSION}.${BINARY_VERSION}.rpm/from/http://mysql.mirrors.pair.com/
PERL_LOCATION=ftp://ftp.de.netclusive.de/pub/parallels/Plesk/Expand/2.3.1/packages
PERL_FILE=perl-DBI-1.53-2.fc7.x86_64.rpm
PERL_URL=${PERL_LOCATION}/${PERL_FILE}
cd
MYSQL_INSTALL_FOLDER=MySQL_${MYSQL_RELEASE}_Install
rm -rf ${MYSQL_INSTALL_FOLDER}
mkdir ${MYSQL_INSTALL_FOLDER}
cd ${MYSQL_INSTALL_FOLDER}
wget ${PERL_URL}
wget ${DEVEL__RPM}
wget ${SHARD2_RPM}
wget ${SHARED_RPM}
wget ${CLIENT_RPM}
wget ${SERVER_RPM}
ls -lSr *.rpm
for RPM in `ls -lSr *.rpm | awk '{print $9}'` ; do rpm -Uvh --force ${RPM} ; done

SPECIFIC VERSION

To install a specific version, set the following:

MYSQL_VERSION (5.5, 5.1, 5.0)
MYSQL_VERSION_RELNUM

For example to get MySQL 5.1.66, run this:

MYSQL_VERSION=5.1
MYSQL_VERSION_RELNUM=66
MYSQL_VERSION_RELEASE=${MYSQL_VERSION}.${MYSQL_VERSION_RELNUM}
REDHAT_RELEASE=5
BINARY_VERSION=x86_64
PERL_LOCATION=ftp://ftp.de.netclusive.de/pub/parallels/Plesk/Expand/2.3.1/packages
PERL_FILE=perl-DBI-1.53-2.fc7.x86_64.rpm
PERL_URL=${PERL_LOCATION}/${PERL_FILE}
MYSQL_MIRROR=http://mysql.mirrors.pair.com/
MYSQL_MIRROR=http://mirror.trouble-free.net/mysql_mirror/
MYSQL_MIRROR=http:http://mysql.he.net/
MYSQL_MIRROR_INDEX=1
MYSQL_SHARE2_LIB=MySQL-shared-compat-${MYSQL_VERSION_RELEASE}-${MYSQL_MIRROR_INDEX}.rhel${REDHAT_RELEASE}.${BINARY_VERSION}.rpm
MYSQL_SHARED_LIB=MySQL-shared-community-${MYSQL_VERSION_RELEASE}-${MYSQL_MIRROR_INDEX}.rhel${REDHAT_RELEASE}.${BINARY_VERSION}.rpm
MYSQL_DEVEL__LIB=MySQL-devel-community-${MYSQL_VERSION_RELEASE}-${MYSQL_MIRROR_INDEX}.rhel${REDHAT_RELEASE}.${BINARY_VERSION}.rpm
MYSQL_CLIENT_LIB=MySQL-client-community-${MYSQL_VERSION_RELEASE}-${MYSQL_MIRROR_INDEX}.rhel${REDHAT_RELEASE}.${BINARY_VERSION}.rpm
MYSQL_SERVER_LIB=MySQL-server-community-${MYSQL_VERSION_RELEASE}-${MYSQL_MIRROR_INDEX}.rhel${REDHAT_RELEASE}.${BINARY_VERSION}.rpm
MYSQL_SHARE2_URL="http://dev.mysql.com/get/Downloads/MySQL-${MYSQL_VERSION}/${MYSQL_SHARE2_LIB}/from/${MYSQL_MIRROR}"
MYSQL_SHARED_URL="http://dev.mysql.com/get/Downloads/MySQL-${MYSQL_VERSION}/${MYSQL_SHARED_LIB}/from/${MYSQL_MIRROR}"
MYSQL_CLIENT_URL="http://dev.mysql.com/get/Downloads/MySQL-${MYSQL_VERSION}/${MYSQL_CLIENT_LIB}/from/${MYSQL_MIRROR}"
MYSQL_DEVEL__URL="http://dev.mysql.com/get/Downloads/MySQL-${MYSQL_VERSION}/${MYSQL_DEVEL__LIB}/from/${MYSQL_MIRROR}"
MYSQL_SERVER_URL="http://dev.mysql.com/get/Downloads/MySQL-${MYSQL_VERSION}/${MYSQL_SERVER_LIB}/from/${MYSQL_MIRROR}"
cd
MYSQL_INSTALL_FOLDER=MySQL_${MYSQL_VERSION_RELEASE}_Install
rm -rf ${MYSQL_INSTALL_FOLDER}
mkdir ${MYSQL_INSTALL_FOLDER}
cd ${MYSQL_INSTALL_FOLDER}
wget ${PERL_URL}
wget ${MYSQL_SHARE2_URL}
wget ${MYSQL_SHARED_URL}
wget ${MYSQL_DEVEL__URL}
wget ${MYSQL_CLIENT_URL}
wget ${MYSQL_SERVER_URL}
pwd
ls -l
for RPM in `ls -lSr *.rpm | awk '{print $9}'` ; do rpm -Uvh --force ${RPM} ; done

REPOSITORIES WITH OLDER VERSIONS

If these do not help, you can bum off of other repositories

SkySQL Archives
Percona Binaries

You will have to script these yourself.

Best Answer

Related Solutions

Mysql – Is replication from MySQL 5.5 master to a 5.1 slave possible

Mysql – How to install specific version of MySQL

LATEST VERSION

SPECIFIC VERSION

REPOSITORIES WITH OLDER VERSIONS

Related Topic