Moving Databases to a seperate machine

[hiddenmagic]

Good Day Everyone,

I have a single web server that has been running Vesta for over a year now. The client list has grown, and it's served us well. We're very happy with VestaCP, and don't intend on using anything else. However, as our business has grown we've thrown more and more clients on this single machine. We're starting to worry about redundancy, and backup machines.

I now have several servers with which I would like to distribute the load of the entire system. Adding a seperate database host was very simple. However, my question is how do I move the databases off the single server and to our new MYSQL machine?

I've removed the public IP from the MYSQL server and it connects just fine with the Vesta server. I tested it with a single MYSQL Dump and a site that rests on the old server, and it was seamless.

However, even with all the great Vesta scripts I can't seem to find anything that will allow me to migrate all of the databases from one machine to another.I see it's possible to create new ones on the new machine, but that's not what I'm looking to do.

Any feedback would be great.

Running Ubuntu 14.04 TT on each server

[mazga]

Hi!

I´m new to VestaCP, i know Vestacp isn´t multi server but is there a easy way to use another physical SQL Server (MySQL or MariaDB) instead of localhost installation? Because of my SQL load now i cant put them onto same server (older harware HP G5)

thx!

[skurudo]

However, even with all the great Vesta scripts I can't seem to find anything that will allow me to migrate all of the databases from one machine to another.I see it's possible to create new ones on the new machine, but that's not what I'm looking to do.

Mysql Master-Master = 2 mysql on different servers or manual mirgarion ;-(

[skurudo]

I´m new to VestaCP, i know Vestacp isn´t multi server but is there a easy way to use another physical SQL Server (MySQL or MariaDB) instead of localhost installation? Because of my SQL load now i cant put them onto same server (older harware HP G5)

You can add different host for database, like this:

Code: Select all

$ v-add-database-host
Error: not enought arguments
Usage: v-add-database-host TYPE HOST DBUSER DBPASS [MAX_DB] [CHARSETS] [TPL]

[mazga]

thx4answer, must be VestaCP installed on mysql only server or can it be any mysql/maria db server?

[skurudo]

must be VestaCP installed on mysql only server or can it be any mysql/maria db server?

VestaCP install mysql (for now), variations with MariaDB will be later (I hope),
but you can change mysql to mariadb - there is no harm with this update.
As different localhost (local and remote), I hope, will be work good.

PS: One thing, that bothers me, mysql + mariadb in cluster.. it's not your case, I think.