• Contact
  • Contact Us
  • Disclamer
  • Home 1
  • Home 2
  • Home 3
  • Privacy Policy
Wednesday, July 2, 2025
How VPS - How to use/setup VPS
  • Login
  • Home
  • Management guides
    • Web servers software
      • Directadmin
      • Hocvps Script
      • Centmin Mod
      • CWP
      • Kloxo-MR
      • Plesk
    • Control Panels
    • Securing VPS/Servers
      • SSL Certificates
      • Upgrading
      • Authentication
  • Operating System
    • CentOS
    • Fedora
    • Debian
    • Linux
    • Arch
    • BSD
    • CoreOS
  • Reviews
  • Coupon
    • Domain Coupon
    • Hosting Coupon
No Result
View All Result
  • Home
  • Management guides
    • Web servers software
      • Directadmin
      • Hocvps Script
      • Centmin Mod
      • CWP
      • Kloxo-MR
      • Plesk
    • Control Panels
    • Securing VPS/Servers
      • SSL Certificates
      • Upgrading
      • Authentication
  • Operating System
    • CentOS
    • Fedora
    • Debian
    • Linux
    • Arch
    • BSD
    • CoreOS
  • Reviews
  • Coupon
    • Domain Coupon
    • Hosting Coupon
No Result
View All Result
How VPS - How to use/setup VPS
No Result
View All Result
Home Operating System CentOS

Plesk: Upgrade MariaDB From Version 5.50 to 10.2 on CentOS 7

How VPS by How VPS
October 1, 2019
in CentOS
0
0
SHARES
24
VIEWS
Share on FacebookShare on Twitter

Contents

  1. Requirements
  2. Performing the upgrade
  3. Want to contribute?


This article was written for Plesk 12.5 and Plesk Onyx 17.x. In these versions, Plesk ships with MariaDB v5.50. The disadvantage of this MariaDB version is that the FULLTEXT index is not allowed in an InnoDB database. This works only with v10 and up. So today, I will show you a quick way to upgrade MariaDB on Plesk to the latest stable version.

Requirements

  • Plesk 12.5 or Plesk Onyx 17.x already installed.
  • You need SSH root access.

Make sure you’ve made a full backup/snapshot of your server before starting this tutorial.

Performing the upgrade

If WatchDog is enabled on Plesk, please deactivate it before proceeding!

Login via SSH as root to your server.

To install MariaDB 10.2, we need to add the MariaDB repository that hosts version 10 of MariaDB. This can be done with the following code generator individually for your server. Please visit: downloads.mariadb.org and select the distro, release and version that you want to install. In our case, it will look like this:

Plesk: Upgrade MariaDB From Version 5.50 to 10.2 on CentOS 7

Copy your custom repository and paste it using vim into a file under /etc/yum.repos.d/. I recommend naming the file MariaDB.repo to remain consistent with the other repository files.

Stop the MariaDB server. Please keep in mind that everything depending on MariaDB will stop functioning until you complete the upgrade.

systemctl stop mariadb

If it exists, remove the old MariaDB benchmark tool.

yum remove mariadb-bench

Start a server update.

yum update

Refresh symlinks.

systemctl enable mariadb

Perform the upgrade.

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

Restart your server. The upgrade is complete!

Now, login back into your MySQL shell:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

… then type status to check your installed version. You will see output similar to the following text.

Plesk: Upgrade MariaDB From Version 5.50 to 10.2 on CentOS 7

If you had WatchDog disabled for this upgrade operation, now is the time to re-enable it.

Want to contribute?

You could earn up to $300 by adding new articles

Submit your article
Suggest an update
Request an article
Previous Post

How to Install and Configure Ansible on CentOS 7 for Use With Windows Server

Next Post

Correcting Network Configuration After Snapshot Restore

Next Post

Correcting Network Configuration After Snapshot Restore

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

No Result
View All Result

Recent Post

Install Imagemagick on CentOS
CentOS

Install Imagemagick on CentOS

by How VPS
June 28, 2023
0

This is how I installed Imagemagick on a vanilla CentOS server Start off by installing the prerequisites yum install php-pear...

Read more
how to Check phpinfo

How to Check phpinfo of Hosting or VPS?

June 28, 2023
Failed to download metadata for repo 'appstream' on Centos 8

How to fix error: Failed to download metadata for repo ‘appstream’ on Centos 8

February 25, 2022
How to Fix MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"?

How to Fix MySQL Error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed”?

November 17, 2020
How to optimize Mysql or MariaDB

How to optimize Mysql or MariaDB

November 3, 2020

Recent News

  • Install Imagemagick on CentOS
  • How to Check phpinfo of Hosting or VPS?
  • How to fix error: Failed to download metadata for repo ‘appstream’ on Centos 8

Category

  • Arch
  • Authentication
  • Backups
  • BSD
  • Centmin Mod
  • CentOS
  • Control Panels
  • CoreOS
  • CWP
  • Debian
  • Directadmin
  • Encryption
  • Fedora
  • Firewalls
  • Hocvps Script
  • Hosting providers
  • Kloxo-MR
  • Linux
  • Mitigations
  • Operating System
  • Plesk
  • Reviews
  • Securing VPS/Servers
  • Security Patches
  • SSL Certificates
  • Uncategorized
  • Upgrading
  • VPS/Servers management guides
  • Vulnerability Detection
  • Web servers software
  • Webhosting Control Panel
  • About
  • Advertise
  • Careers
  • Contact

© 2025 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Management guides
    • Web servers software
      • Directadmin
      • Hocvps Script
      • Centmin Mod
      • CWP
      • Kloxo-MR
      • Plesk
    • Control Panels
    • Securing VPS/Servers
      • SSL Certificates
      • Upgrading
      • Authentication
  • Operating System
    • CentOS
    • Fedora
    • Debian
    • Linux
    • Arch
    • BSD
    • CoreOS
  • Reviews
  • Coupon
    • Domain Coupon
    • Hosting Coupon

© 2025 JNews - Premium WordPress news & magazine theme by Jegtheme.

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In