Resolved [PPP-18000] Plesk 12.5.30 - Easy way to replace MariaDB 5.5 with 10 ?

[Reqlez]

Hi.


I have a fresh install of Plesk 12.5.30 on centOS7.1

Is there a quick and easy way to switch over to MariaDB 10 since its now supported without re-installing Plesk ?

 

[UFHH01]

Hi Reqlez,

there are quite a few ( good ) tutorials on the web, which you might be interested in:

http://lmgtfy.com/?q="CentOS+7"+"MariaDB"+"upgrade"+"5.5"+"10"​

 

[Reqlez]

yea but will that break Plesk ? i haven't see anything with somebody upgrading 5.5 to 10 with Plesk 12.5 all i heard is "will break things unless you upgrade before installing plesk"

or even better: once i upgrade, will Plesk install updates to MariaDB 10 ?

 

[UFHH01]

Hi Reqlez,

IF you upgrade to a supported version of your database software, then you should not experience any issues with that upgrade. You might have to use the command

mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `​

after upgrading, as stated at: Database Server ( online documentation: Advanced Administration Guide, Plesk 12.5 for Linux )

... and always make sure to have a complete backup ( as well described in the documentation! ), so you can restore your previous state.

You could as well describe your experience and work-arounds here, so that other users may profit from you.

 

[Reqlez]

Hi.

Thanks for your tips. I will take an image of the VM and will attempt the procedure and report back.

 

[Reqlez]

Hi Reqlez,

IF you upgrade to a supported version of your database software, then you should not experience any issues with that upgrade. You might have to use the command

mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `​

after upgrading, as stated at: Database Server ( online documentation: Advanced Administration Guide, Plesk 12.5 for Linux )

... and always make sure to have a complete backup ( as well described in the documentation! ), so you can restore your previous state.

You could as well describe your experience and work-arounds here, so that other users may profit from you.

So i added MariaDB 10.0 repo from here: MariaDB repository generator

Then I did:

systemctl stop mariadb
yum -y install MariaDB-server MariaDB-client
systemctl start mariadb
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

stuff seems to be working okay ... I guess we shall see


SO i'm assuming i can backup whole database using xtrabackup utility from percona since everything is running on InnoDB ? is that a safe assumption ?

 

[mizar]

Also check this thread about Plesk 12.5 on CentOS7 + MariaDB 10 http://talk.plesk.com/threads/plesk-12-5-with-mariadb-10.334703/

 

[Reqlez]

Also check this thread about Plesk 12.5 on CentOS7 + MariaDB 10 http://talk.plesk.com/threads/plesk-12-5-with-mariadb-10.334703/

I will do that, but how about watchdog ? and how to get watchdog working properly ?

Oct 1 23:09:27 http01 monit: 'mysql' failed to start

Oct 1 23:09:28 http01 monit: 'mysql' process is not running

Oct 1 23:09:28 http01 monit: 'mysql' trying to restart

Oct 1 23:09:28 http01 monit: 'mysql' start: /usr/sbin/service

Oct 1 23:09:28 http01 monit: Redirecting to /bin/systemctl start mariadb.service

Oct 1 23:09:28 http01 monit: Failed to issue method call: Unit mariadb.service failed to load: No such file or directory.


also found:

Oct 2 00:56:33 http01 systemd: Cannot add dependency job for unit mariadb.service, ignoring: Unit mariadb.service failed to load: No such file or directory.

 

[Reqlez]

okay something keeps rebooting my MariaDB server... pretty sure its watch dog so i disabled monitoring for now

EDIT:

okay, see other post http://talk.plesk.com/threads/plesk-12-5-with-mariadb-10.334703/#post-787167 for watchdog fix

 

[bulent]

Hello,
I plan to build new server and experimenting with plesk 12.5 on CentOS7.1 with MarisDB 10.

So what I did is:
1. Install clean Centos 7.1 (Core)
2. yum update
3. add Mariadb 10 repo to the repo list

vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list - created 2015-10-12 20:25 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

sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

4. Install Plesk
wget autoinstall.plesk.com/plesk-installer
chmod +x plesk-installer
./plesk-installer

Now automatically Plesk 12.5 installed MariaDB10 and everything seems to work fine, except in Plesk Add remove component page, it shows that there is no MySQL installed and when I try to install it says it's already installed.

Is it somesort of a bug?

 

[mizar]

Now automatically Plesk 12.5 installed MariaDB10 and everything seems to work fine, except in Plesk Add remove component page, it shows that there is no MySQL installed and when I try to install it says it's already installed.

Is it somesort of a bug?

Yes, this is a bug, it's ID in our internal tracker - PPP-18000

 

[Reqlez]

So that bug is preventing me from updating to Update 6 of Plesk 12.5 ... any workaround to install Version 6 or fix plesk so it knows mariaDB 10 is installed ?

 

[mizar]

So that bug is preventing me from updating to Update 6 of Plesk 12.5 ... any workaround to install Version 6 or fix plesk so it knows mariaDB 10 is installed ?

Do you mean issue with watchdog or about Add/Remove components?

 

[Reqlez]

The issue with the fact that Maria DB10 is not being detected. So I cannot update because it keeps saying "MySQL is missing" and it's a pre requisite for installing Update 6

 

[mizar]

The issue with the fact that Maria DB10 is not being detected. So I cannot update because it keeps saying "MySQL is missing" and it's a pre requisite for installing Update 6

This issue is resolved in scope of Plesk 12.5.30 MU#7 - please check that autoupdater now detects your MariaDB.

 

[Anshuman Saxena]

Plesk 12.5.30 MU#7
After fresh install with MariaDB-common-10.1.8-1.el7.
It shows Component updates are available and in that MySQL is present and after updating the component 'MySQL' it shows all operations are done.
And then again it show components are available and same MySQL is checked and it stay this way after updating it again.

Note its a custom install with NO DNS and Mail services

What could be wrong in this?

 

[mizar]

Plesk 12.5.30 MU#7
After fresh install with MariaDB-common-10.1.8-1.el7.
It shows Component updates are available and in that MySQL is present and after updating the component 'MySQL' it shows all operations are done.
And then again it show components are available and same MySQL is checked and it stay this way after updating it again.

Note its a custom install with NO DNS and Mail services

What could be wrong in this?

Could you provide output of command rpm -qa | grep -i "mysql\|mariadb"

 

[Anshuman Saxena]

MariaDB-common-10.1.8-1.el7.centos.x86_64
MariaDB-client-10.1.8-1.el7.centos.x86_64
sw-mariadb-client-1.0.0-centos7.15072015.x86_64
plesk-mysql-server-12.5.30-cos7.build1205150826.19.x86_64
plesk-php56-mysql-5.6.14-centos7.15100513.x86_64
plesk-mysql-connector-odbc-5.2.7-centos7.15072015.x86_64
php-mysql-5.4.16-36.el7_1.x86_64
MariaDB-server-10.1.8-1.el7.centos.x86_64
MariaDB-shared-10.1.8-1.el7.centos.x86_64

Note: Its a Test server and I can Provide login details if needed

 

[mizar]

MariaDB-common-10.1.8-1.el7.centos.x86_64
MariaDB-client-10.1.8-1.el7.centos.x86_64
sw-mariadb-client-1.0.0-centos7.15072015.x86_64
plesk-mysql-server-12.5.30-cos7.build1205150826.19.x86_64
plesk-php56-mysql-5.6.14-centos7.15100513.x86_64
plesk-mysql-connector-odbc-5.2.7-centos7.15072015.x86_64
php-mysql-5.4.16-36.el7_1.x86_64
MariaDB-server-10.1.8-1.el7.centos.x86_64
MariaDB-shared-10.1.8-1.el7.centos.x86_64

Note: Its a Test server and I can Provide login details if needed

Thanks, but /var/log/plesk/install/autoinstaller.log would be enough, may be in PM

 

[Anshuman Saxena]

Done