Facebook
Twitter-
Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
-
The BIND DNS server has already been deprecated and removed from Plesk for Windows.
If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release. -
The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
anyone installed maridb?
- Thread starter Ademi
- Start date
OK. Here's the guide to switching to MariaDB on RedHat/CentOS. Since I'm very lazy, I won't be detailing each step or explaining its purpose.
1) Back up ALL your databases. If you don't want to back up all of them, back up only essential ones:
# mysqldump -uadmin -p`< /etc/psa/.psa.shadow ` --databases mysql psa apsc | gzip > /root/mysql.mysql-psa-apsc.dump.sql.gz
2) Set up repositories. Go to https://downloads.mariadb.org/mariadb/repositories/ and follow wizard instructions. On step 3 "Choose a Version" choose 5.5.
3) Disable WatchDog module in Panel if you have one. Disable any other custom monitoring services that may resurrect MySQL daemon if you have any.
4) # service mysqld stop
5) Remove mysql-server package (first check that # rpm -q --whatprovides mysql-server actually outputs a package!):
# rpm -e --nodeps `rpm -q --whatprovides mysql-server`
6) Remove leftovers and install MariaDB in their place:
# yum shell
> remove mysql mysql-server plesk-mysql
> install MariaDB-server MariaDB-client MariaDB-compat MariaDB-shared
> run
Total download size: 58 M
Is this ok [y/N]: y
Importing GPG key 0x1BB943DB "Daniel Bartholomew (Monty Program signing key) <dbart@askmonty.org>" from https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Is this ok [y/N]: y
> exit
7) Optionally update configuration file:
# [ -f /etc/my.cnf.rpmnew ] && mv /etc/my.cnf.rpmnew /etc/my.cnf
8) # service mysql start
9) # mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `
10) Enable WatchDog and any other service disabled on step 3.
11) If you experience MySQL errors (especially related to InnoDB), restore backup made on step 1:
# zcat /root/mysql.mysql-psa-apsc.dump.sql.gz | mysql -uadmin -p`< /etc/psa/.psa.shadow `
12) Tell Plesk that you changed MySQL version:
# plesk sbin packagemng --set-dirty-flag
That's it!
1) Back up ALL your databases. If you don't want to back up all of them, back up only essential ones:
# mysqldump -uadmin -p`< /etc/psa/.psa.shadow ` --databases mysql psa apsc | gzip > /root/mysql.mysql-psa-apsc.dump.sql.gz
2) Set up repositories. Go to https://downloads.mariadb.org/mariadb/repositories/ and follow wizard instructions. On step 3 "Choose a Version" choose 5.5.
3) Disable WatchDog module in Panel if you have one. Disable any other custom monitoring services that may resurrect MySQL daemon if you have any.
4) # service mysqld stop
5) Remove mysql-server package (first check that # rpm -q --whatprovides mysql-server actually outputs a package!):
# rpm -e --nodeps `rpm -q --whatprovides mysql-server`
6) Remove leftovers and install MariaDB in their place:
# yum shell
> remove mysql mysql-server plesk-mysql
> install MariaDB-server MariaDB-client MariaDB-compat MariaDB-shared
> run
Total download size: 58 M
Is this ok [y/N]: y
Importing GPG key 0x1BB943DB "Daniel Bartholomew (Monty Program signing key) <dbart@askmonty.org>" from https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Is this ok [y/N]: y
> exit
7) Optionally update configuration file:
# [ -f /etc/my.cnf.rpmnew ] && mv /etc/my.cnf.rpmnew /etc/my.cnf
8) # service mysql start
9) # mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `
10) Enable WatchDog and any other service disabled on step 3.
11) If you experience MySQL errors (especially related to InnoDB), restore backup made on step 1:
# zcat /root/mysql.mysql-psa-apsc.dump.sql.gz | mysql -uadmin -p`< /etc/psa/.psa.shadow `
12) Tell Plesk that you changed MySQL version:
# plesk sbin packagemng --set-dirty-flag
That's it!
Bernabé_Pelús_Femenía
New Pleskian
Hello everyone,
Thank you very much for your explanation, it has served me very helpful to replace MariaDB MySQL in Plesk
Currently I have Plesk 12.0.18 + CentOS 6.5 and I followed the manual. Everything went perfect and I could replace MariaDB MySQL, but I have a problem with Plesk updates. Do not allow me to update.
I asked to have installed the component "MySQL server support." and I can not update anything.
I do not quite understand why the requests have Plesk installed component "MySQL server support." Because I upgraded to MariaDB.
Someone you this problem occurred?
How I can fix to receive Plesk updates with MariaDB? There is a patch to correct it?
Thank you very much for your help
regards
Thank you very much for your explanation, it has served me very helpful to replace MariaDB MySQL in Plesk
Currently I have Plesk 12.0.18 + CentOS 6.5 and I followed the manual. Everything went perfect and I could replace MariaDB MySQL, but I have a problem with Plesk updates. Do not allow me to update.
I asked to have installed the component "MySQL server support." and I can not update anything.
I do not quite understand why the requests have Plesk installed component "MySQL server support." Because I upgraded to MariaDB.
Someone you this problem occurred?
How I can fix to receive Plesk updates with MariaDB? There is a patch to correct it?
Thank you very much for your help
regards
