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 How to configure Virtualmin for a MySQL server on a separate host. on the new forum.
Web Hosting and Cloud Computing Control Panels
Hey,
I used the following page to setup a dedicated SQL host:-
https://www.virtualmin.com/documentation/id,running_mysql_on_a_remote_sy...
Just to know if two servers are not hosted in same DC there will be no real advantage and the loading time will go up. How much? Depends on the connection between the two servers.
- I often come to the conclusion that my brain has too many tabs open. -
Failing at desktop publishing & graphic design since 1994.
I would have to disagree with this statement in regards to it offering no real advantage. It all depends on why you are placing the database on a dedicated server.
It could be that you have a real powerful server you intend to use as the database back-end which can provide a real performance boost in place of running it on the same hardware as the web server.
Yes if the two DC's have a crap connection and located a fair distance apart you won't see a "speed" benefit in regards to the requests going from the web server -> database server and then back.
Regardless of the connection speed of each DC it will never be as fast as two servers sitting in same DC. To offload the server and moving the DB to another server is something i didnt questioned.
But with today quality of SSD DC edition and raid 10, the DB need to be huge and the website to have daily visits measured in tens of thousands to get any real benefits. Not knowing what is the situation with OP is hard to talk what is the best solution. Only thing i can be sure is the lost of speed in case two servers doesnt sit in same DC.
- I often come to the conclusion that my brain has too many tabs open. -
Failing at desktop publishing & graphic design since 1994.