Resolved MariaDB 5.5 Upgrade possible on active server?

[speedbird]

I read a few MariaDB 5.5 to 10 upgrade posts here but I'm not quite sure if I understood it correctly...

Are you guys telling me, there is no way to upgrade from 5.5 to 10 when Plesk is already installed? I need to upgrade it to the latest version because I need MySQL 5.6 compatibility but I can't simply delete Plesk since the server is in use.

Is there really no way to upgrade? Also why is there MariaDB in the first place? With default MySQL I could simply do the upgrade from 5.5 to 5.6 without a problem.

Any solutions? Not being able to update the database software is a serious problem!

Thanks guys!

 

[Lloyd_mcse]

Hi speedbird
you can upgrade from MariaDB 5.5 to MariaDB 10 (or 10.1 though not officially supported by Plesk) without issue, you may however need to add the repository from mariadb themselves if your OS doesn't include it....

https://downloads.mariadb.org/mariadb/repositories/#mirror=digitalocean-lon

Kind regards

Lloyd

 

[speedbird]

Hi Lloyd,
thanks for your reply... I was referring to this thread:
https://talk.plesk.com/threads/ppp-...mariadb-5-5-with-10.334758/page-2#post-799245

Here it is said, that an in place upgrade won't work but break things instead. So you're sure that it is possible to do so on an already populated system?

Do you have detailed instructions for the correct process? Thanks.

 

[Lloyd_mcse]

Hi speedbird
no it won't break anything in my experience.
On Ubuntu (going from MySQL 5.5 to MariaDB x.x) you get a dpkg error, but that's solved with 3 commands.
What OS are you using? And I'll post some instructions for you, though they have pretty good instructions at the above link too.
Regards

Lloyd

 

[speedbird]

I'm on CentOS7. Thanks in advance!

 

[Lloyd_mcse]

First create the file (I'll use vi)...

# vi /etc/yum.repos.d/MariaDB-10.repo

Adding...

# MariaDB 10.0 CentOS repository list - created 2016-05-23 17:40 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

save the file, stop Watchdog monitoring of MySQL, and then stop the current mariadb process...

# service mariadb stop

And install the latest version...

#  yum install MariaDB-server MariaDB-client

I hope that helps
Regards

Lloyd

 

[speedbird]

Thanks a lot! That helps