On many web servers running Plesk, Centos runs in the 7 version, which is a free version of the professional RedHat 7 operating system. In Germany Plesk is often used as a management interface.
Centos7 brings the database server MariaDB 5.5 with what about mysql, 5.5 corresponds to how it is from the MySQL comparison evident. Unfortunately, everything is a little bit dusty, but of course it also runs flawlessly with current content management systems.
MariaDB 5.5 on MariaDB 10.2
New versions bring many features and more speed, so it often makes sense to replace the old software products that come with the operating system. In this example, we update MariaDB5.5 on 10.2, which corresponds to mysql5.7.
If the server is already productive with Plesk, then the database server can only be replaced in maintenance mode and a database backup can be created beforehand. Best snapshot of the whole machine.
To do this, just pause the Plesk services:
service psa stopall
and for security the database server once again:
service mariadb stop
Then the upgrade can be done with a few small commands.
First we have to create a suitable repository, so that the whole is also updated. Please create the following file with an editor:
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
The mariadb server already installed can then be replaced. I advise you to upgrade from the 5.5 version to 10.2 first and only then switch to 10.3. For 10.3, an entry in /etc/my.cnf should be added.
rpm -e --nodeps mariadb-bench #evtl vorhandenen mariadb-bench entfernen
yum install MariaDB client MariaDB server Update #MariaDB Server
If there are problems with this step, the MariaDB server can also use the command:
rpm -e MariaDB-server –nodeps; yum -y install MariaDB-server #alternative reinstallation
Fully removed and reinstalled. This can happen if another MariaDB version is already installed or dependencies prevent an update. Then the MariaDB packages have to be updated
yum -y update MariaDB *
That's it. Now just restart the database server.
service mariadb start
What is still missing is an update of the whole tables. To do this, simply upgrade the database server by running the following command:
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
Now restart the Plesk services and everything is already running with the current MariaDB version 10.2.
service psa startall
Please always remember to create regular backups. Customers who use age-old forums or content management systems may get problems with current database versions.
Please just write a comment, if that worked well for you.