More than one remote MySQL servers

Hi all,

Is there a way to setup more than one remote MySQL servers and access them via virtualmin?

Thanks

Howdy,

What sort of setup did you have in mind… where you hoping to have a cluster of MySQL servers, all of which had the same data on them?

Or are you hoping for a group of unique MySQL servers, each with their own set of databases on them?

-Eric

Hi Eric,

I’m gonna implement the 2nd scenario, that is a group of unique MySQL servers, each with their own set of databases on them.

Howdy,

Yeah, you can do that – but Virtualmin wouldn’t be able to set that up for you. Virtualmin only knows how to setup and communicate with one MySQL server.

You could, however, configure it manually. You could configure MySQL on your various remote servers, and setup your databases and permissions – and then just configure your various websites to access the correct remote MySQL server.

-Eric

I know how to do it manually, I was looking for an easier way to automate this via virtualmin in order to avoid creating users manually on db servers.

Thanks