Migrating Plesk to MariaDB 10.1 is fairly simple, currently Plesk officially supports up to MariaDB 10 and MySQL 5.6 (since writing 10.1 is now supported), so this is “use at your own risk”. I’ve run Plesk with MariaDB 10.1 on various operating systems, here I’ll show you how to install on Ubuntu 14 LTS from the MariaDB repository…
Please Note: An in place upgrade like this does not work on Ubuntu 16, you need to install MariaDB prior to installing Plesk, though I will be coming back to this issue when I have time.
Preparation
1. Import the key
|
1 |
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db |
2. Add the repository
|
1 |
add-apt-repository 'deb [arch=amd64,i386] http://lon1.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu trusty main' |
3. Now update apt…
|
1 |
apt-get update |
4. Stop the current MySQL/MariaDB process (if you use WatchDog to monitor MySQL/MariaDB stop monitoring first)
|
1 |
/opt/psa/admin/bin/modules/watchdog/wd --unmonit-service=mysql |
And
|
1 |
service mysql stop |
Installation
5. Install like so…
|
1 2 |
env DEBIAN_FRONTEND=noninteractive apt-get -o OrderList::Score::Immediate=1000 \ install libjemalloc1 galera-3 libmysqlclient18 libmariadbclient18 mariadb-common mariadb-client-core-10.1 mariadb-client-10.1 mariadb-server mariadb-server-core-10.1 mariadb-server-10.1 |
If prompted to set a password, leave blank to keep your current, and you should over write the my.cnf file with the latest version to make sure you get all the optimizations added for MariaDB, especially if you are coming from MySQL.
Final Stage
6. Now you can start the MySQL service and start Watchdog monitoring…
Stop the current MySQL/MariaDB process (if you use WatchDog to monitor MySQL/MariaDB stop monitoring first)
|
1 |
/opt/psa/admin/bin/modules/watchdog/wd --monit-service=mysql |
And
|
1 |
service mysql start |
Should you have any problems, please see the notes at the bottom of my post on Migrating Plesk to MariaDB