Moving Databases to a seperate machine
Posted: Sun Jul 05, 2015 12:37 am
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
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