Remote MySQL


I am working on setting up two servers, one to handle mysql load and the other to run everything else,

Is it possible to use virtualmin (commercial version) in such installation where whenever users add mysql database it gets setup on the remote mysql database and other things on the machine hosting virtualmin


If virtualmin doesnt mess with on-disk mysql files, then it’s simple. You can emulate mysql’s socket with socat (google for it), as for the TCP/IP part you can redirect it from your firewall or make a tunnel (ssh comes to mind, but not only).