Ferret Posted April 30, 2012 Share Posted April 30, 2012 Hello chaps, Hopefully you can help me here :) I've got myself a dedicated Win Server 2008 box running my web server and SQL server for my forum (Got it nice and cheap considering the specs ;)). Anyway, I also have another dedicated Win Server 2003 box sat idling that i'm paying for, that i'd like to utilize. Both boxes are in different locations, but I would like to share the load between the 2 - So if one goes offline, the other box can take the load. A duplication, but with different OS's. This must be possible, but whats the best way of going about this ? I would like to have the Win Server 2008 box take 90% (atleast) of the load if possible as it has far high specs and a better pipe to it. With the secondary server just taking the lightest load possible. Thanks, Ferret ! Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/ Share on other sites More sharing options...
Ferret Posted May 2, 2012 Author Share Posted May 2, 2012 Please..... I'm sure someone knows how to get this kinda setup going. Thanks :) Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594838697 Share on other sites More sharing options...
remixedcat Posted May 2, 2012 Share Posted May 2, 2012 Ever look into hardware load balancers?? That and VMWare cloud can do it as well. Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594838701 Share on other sites More sharing options...
pupdawg21 Posted May 2, 2012 Share Posted May 2, 2012 An easy simple way but not resilient to outages or necessarily fully balanced would be to just use DNS. Configure the entire site on both servers and put in entries for your domain containing the public IPs of both Hosted servers. This way traffic would round robin between the (2) servers based solely on whichever IP is served first to the client. However, when one goes down a user might inadvertantly be sent to the server that's down on their 1st attempt. Not ideal but it would make both servers be utilized but not at the 90% / 10% ratio that you desire. You would need to work out a way to keep the database data in sync between the (2) mysql instances. Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594838741 Share on other sites More sharing options...
hjf288 Posted May 2, 2012 Share Posted May 2, 2012 HaProxy? Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594838765 Share on other sites More sharing options...
mbowman Posted May 2, 2012 Share Posted May 2, 2012 How much lag would be behind having one server as the database server and the other as the web server seeing as they're at different locations? Maybe if you have lots of images you could use the 2003 server for hosting these images? Simple ways of reducing the loads. Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594839473 Share on other sites More sharing options...
The_Decryptor Veteran Posted May 2, 2012 Veteran Share Posted May 2, 2012 If they're in different locations, how are you sharing SQL access? Are you pointing them at the same physical server, or are you doing replication or such over the net? If they were in the same location you could use something like nginx to proxy access to the servers (And have it serve static content, leaving the main servers to handle dynamic content) Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594839479 Share on other sites More sharing options...
Ferret Posted May 5, 2012 Author Share Posted May 5, 2012 On 02/05/2012 at 11:28, The_Decryptor said: If they're in different locations, how are you sharing SQL access? Are you pointing them at the same physical server, or are you doing replication or such over the net? I'm going for replication over the net for the SQL. What I might try is what pupdawg21 suggested. It's not the ideal situation is I was hoping for, but it's better than nothing :) Thanks chaps. Link to comment https://www.neowin.net/forum/topic/1073859-web-servermysql-load-balancing/#findComment-594846483 Share on other sites More sharing options...
Recommended Posts