Separate MySQL VPS

Hello I currently use easyengine for my wordpress site. Due to traffic increases I want to migrate my database to another VPS, I want to keep the exisitng easy engine VPS running but I want to disable MySQL on it and instead have the original VPS remotely connect to the new database VPS. What is the best way to go about this?

Hello ralatair, the tutorial is available here : You can install the latest MariaDB release v10.2 on your database server :

For Debian 8 Jessie :

apt-get install software-properties-common
apt-key adv --recv-keys --keyserver 0xcbcb082a1bb943db
add-apt-repository 'deb [arch=amd64,i386,ppc64el] jessie main'
For Ubuntu 16.04 LTS Xenial :

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp:// 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] xenial main'

## install mariadb
apt update
apt install mariadb-server

Then run the command mysql_secure_installation To disable mysql on your current server :

systemctl stop mysql
systemctl disable mysql

Hi thanks for your help and resources. How do I go about moving the data in the database to my new MariaDB server?

The easiest is to dump your database :

mysqldump -u yourdatabaseuser -p database_name >  dump.sql

And to move the file with rsync or scp. Then you can import it with :

mysql -u yourdatabaseuser -p database_name < dump.sql

Also, if you’ve installed PHPMyAdmin, you can export it from there

After you’ve migrated, you need to change the host parameter in the wp-config.php files of your sites