[SOLVED] Moving from MySQL to MariaDB

General support questions
Post Reply
linker3000
Posts: 6
Joined: 2007/07/13 08:12:45
Location: West Sussex, UK

[SOLVED] Moving from MySQL to MariaDB

Post by linker3000 » 2013/11/17 22:25:10

Hi Everyone,

I'd like to move a well-established (but not mission-critical) CentOS 6.4 installation to MariaDB but if I start to follow many of the boilerplate, yum-based guides (with the line 'yum remove mysql*' on the 'net, I am faced with confirming that a slew of dependencies will be removed - From Squirrelmail to Tomcat6 and Postfix.

Can anyone comment from experience about just using rpm -e with the nodeps option to remove the mysql bits and then sliding MariaDB into place as I can't find much about taking this route.

Thanks
Last edited by linker3000 on 2013/11/19 11:50:21, edited 1 time in total.

linker3000
Posts: 6
Joined: 2007/07/13 08:12:45
Location: West Sussex, UK

[SOLVED] Moving from MySQL to MariaDB

Post by linker3000 » 2013/11/18 17:32:45

For reference, everything seems to have worked smoothly. YMMV and 'at your own risk' etc...on my 64-bit system I did the following:

Add the MariaDB repository

Code: Select all

vi /etc/yum.repos.d/MariaDB.repo

Code: Select all

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64
gpgcheck = 1
enabled = 1
Get the MariaDB repo key

Code: Select all

rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Remove MySQL

Code: Select all

service mysqld stop
rpm -e --nodeps mysql mysql-libs mysql-client mysql-server
Edit: First draft omitted 'mysql' so added it to the line above

Install MariaDB (I got 404 errors first time around so I did the yum clean and tried again)

Code: Select all

yum clean all
yum install MariaDB-server MariaDB-client MariaDB-common MariaDB-compat MariaDB-shared
Fire up MariaDB

Code: Select all

service mysql start
service httpd restart
Next day snag: Overnight mysqldump showing an error: 'Couldn't execute 'show events'. Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)'

After a quick Web search, I ran the following:

Code: Select all

mysql_upgrade -u root -h localhost -p --verbose
service mysql restart
And the backup script ran OK
Last edited by linker3000 on 2013/11/19 12:10:26, edited 4 times in total.

User avatar
TrevorH
Forum Moderator
Posts: 29171
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Moving to MariaDB - dependency hell

Post by TrevorH » 2013/11/18 21:45:26

What does `yum check` say now?
CentOS 6 will die in November 2020 - migrate sooner rather than later!
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 is dead, do not use it.
Full time Geek, part time moderator. Use the FAQ Luke

linker3000
Posts: 6
Joined: 2007/07/13 08:12:45
Location: West Sussex, UK

[SOLVED] Moving from MySQL to MariaDB

Post by linker3000 » 2013/11/19 09:43:33

TrevorH wrote:What does `yum check` say now?
Hi TrevorH,

After about 45 minutes it comes back with no output.
Last edited by linker3000 on 2013/11/19 11:51:15, edited 1 time in total.

User avatar
TrevorH
Forum Moderator
Posts: 29171
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Moving to MariaDB - dependency hell

Post by TrevorH » 2013/11/19 10:51:52

Ok, good, I wasn't sure if the mariadb packages supplied the dependencies required by other packages and `yum check` would have told you that there were missing deps if not.
CentOS 6 will die in November 2020 - migrate sooner rather than later!
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 is dead, do not use it.
Full time Geek, part time moderator. Use the FAQ Luke

asawyer13
Posts: 5
Joined: 2010/04/06 00:48:28

Re: [SOLVED] Moving from MySQL to MariaDB

Post by asawyer13 » 2014/01/12 11:08:18

I am using Plesk 11 which doesn't play well with MariaDB. Can I install both MySQL and MariaDB so I can continue using Plesk?
I understand MariaDB would have to be on a different port like 3307.

asawyer13
Posts: 5
Joined: 2010/04/06 00:48:28

Re: [SOLVED] Moving from MySQL to MariaDB

Post by asawyer13 » 2014/01/12 12:58:25

I was able to upgrade my Plesk to 11.5 so I am good.
Thanks

Post Reply

Return to “CentOS 6 - General Support”