These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for More than one remote MySQL servers on the new forum.
Web Hosting and Cloud Computing Control Panels
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