1. It is assumed you already have your second server up and running.
2. On the first server run following command
v-add-database-host mysql new-server.com root password
3. To make sure database has been added run following command
- how to find size of the database via mysql console
- How to disable MySQL Strict Mode?
- change / reset root password in mysql
- How to replace MySQL with Percona Server on Debian or Ubuntu
- howto upgrade mariadb 10.x to 10.3.x on Centos 7