How to run MySQL server on another machine

Whats the best way to run a MySQL server on another machine; I use the script installers; I like having the backups all in one; but I’m thing on running off a SSD; they don’t have high capacity drives out I can afford yet; so I was thing maybe I could run the MySQL server off a dedicated MySQL server, it should be faster; and then move the email off on another server and maybe have the files on another drive. Is any of this possible in VM now? I don’t see how to do it.

If it is can you point me to some documentation?

Thanks

Howdy,

That is indeed possible!

The docs here certainly need to be improved, but this should get you started:

http://www.virtualmin.com/documentation/id%2Crunning_mysql_on_a_remote_system