Recommended Posts

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

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.

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)

  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.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Ah so it's not in the .ISO it's self but it changes the definition in the OOBE update during setup?
    • They always have. This just updates what's included out of the box during the initial install.
    • So basically their prebuilding it into the ISOs?
    • Microsoft shares Defender anti-virus update for new Windows 11/10 ISOs by Sayan Sen Following the one for Lumma last month, Microsoft has also published a new Defender update for Windows 11/10/Server installation images this month. This update package is necessary as a Windows installation image may contain old, outdated anti-malware definitions and software binaries. Aside from better security, these updates can also provide improved performance benefits in some cases. When a new Windows installation is set up, there may be a temporary security risk due to outdated Microsoft Defender protection in the OS installation images. This happens because the antimalware software included in these images might not be up to date. Thus Microsoft says that these updated definitions essentially help close this protection gap. Microsoft delivered the latest security definitions for Windows images via security intelligence update version 1.431.54.0. The Defender package version is also the same. It applies to Windows 11, Windows 10 (Enterprise, Pro, and Home editions), Windows Server 2022, Windows Server 2019, and Windows Server 2016. Microsoft writes: From Microsoft's security bulletin, we learn that the security intelligence update version 1.431.54.0 was released this past week adds threat detections for various backdoor exploits, trojans, among others. For those wondering, the latest intelligence update is version 1.431.155.0 at the time of writing.
    • “In other news about OneDrive frustration, Microsoft recently locked out a user who was attempting to move a bunch of important data from old hard drives to OneDrive.” - It was probably CSMA..
  • Recent Achievements

    • One Month Later
      SekTheFirst earned a badge
      One Month Later
    • First Post
      zayanhani earned a badge
      First Post
    • First Post
      HarryTaylor earned a badge
      First Post
    • One Year In
      Eternal Tech earned a badge
      One Year In
    • One Month Later
      Eternal Tech earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      650
    2. 2
      ATLien_0
      231
    3. 3
      Michael Scrip
      224
    4. 4
      Steven P.
      141
    5. 5
      +FloatingFatMan
      139
  • Tell a friend

    Love Neowin? Tell a friend!