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)

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

    • "Samsung is shutting down yet another app used by millions" I will fix the clickbait title for you, free-of-charge: "Samsung shutting down it's Max VPN app"
    • Microsoft brings Planner Agent to all Microsoft 365 Copilot users by Ivan Jenic Image: Microsoft Microsoft has announced that Planner Agent in Microsoft 365 Copilot is now generally available to all users with a Microsoft 365 Copilot license. Planner Agent is the latest addition in the string of AI features that Microsoft is implementing across virtually all of its products. The agent lets you manage tasks through natural language prompts directly inside Microsoft 365 Copilot. You can create and update tasks, check priorities, and get insights about current entries without leaving the chat interface. The general availability release comes with a handful of new additions on top of what was available during the initial rollout. A new plan picker lets you search and filter your plans by name, then update task names, statuses, due dates, or priorities through the agent. There's also a goals bucket now, which lets you group tasks under specific goals. This builds on the Goals view, a feature that was introduced as part of the broader Planner refresh that rolled out earlier. Image: Microsoft | Planner Agent in Microsoft 365 Copilot All AI-generated plans and tasks are created in draft mode by default, so you can review and approve changes before anything goes through. This is actually a thoughtful safety feature, because trusting AI to handle all your tasks without a human in the loop is usually a recipe for disaster. Having tasks initially saved as drafts is the best possible middle ground. Microsoft also says that not all tasks are executed equally. Simple tasks get processed quickly, while more complex ones, like building a plan from a Word, Excel, or PowerPoint file, are handed to a more capable model. Microsoft says this approach delivers the best performance, but it could also help with usage management, as you won't have to waste tokens on performing simple tasks. Planner Agent is available now across Teams, Loop, SharePoint, and other Microsoft 365 apps for anyone on a Microsoft 365 Copilot subscription.
    • To be clear I'm anti trump, the bigger point is why review this game at all?
    • Trillion dollar Microsoft has to reduce spending by hurting more people. Good job Microsoft. Good Job Asha.
    • That's a shame. The big Xbox reset when Phil and Sarah left and then Asha came on and brought a new team of executives, and all the layoffs last year and saying that the ABK merger wouldn't result in redundancies I am surprised they are calling for yet another reset and yet more layoffs.
  • Recent Achievements

    • First Post
      Cosminus earned a badge
      First Post
    • One Year In
      ThatGuyOnline earned a badge
      One Year In
    • Week One Done
      Jeroen Wilms earned a badge
      Week One Done
    • Week One Done
      rolfus earned a badge
      Week One Done
    • One Month Later
      Leroy Jethro Gibbs earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      500
    2. 2
      +Edouard
      194
    3. 3
      PsYcHoKiLLa
      125
    4. 4
      Steven P.
      87
    5. 5
      neufuse
      73
  • Tell a friend

    Love Neowin? Tell a friend!