Slashdot Mirror


Ask Slashdot: Low Cost Way To Maximize SQL Server Uptime?

jdray writes "My wife and I own a mid-sized restaurant with a couple of Point of Sale (POS) terminals. The software, which runs on Windows and .NET, uses SQL Server on the back end. With an upgrade to the next major release of the software imminent, I'm considering upgrading the infrastructure it runs on to better ensure uptime (we're open seven days a week). We can't afford several thousand dollars' worth of server infrastructure (two cluster nodes and some shared storage, or some such), so I thought I'd ask Slashdot for some suggestions on enabling maximum uptime. I considered a single server node running VMWare with a limp-mode failover to a VMWare instance on a desktop, but I'm not sure how to set up a monitoring infrastructure to automate that, and manual failover isn't much of an option with non-tech staff. What suggestions do you have?"

4 of 284 comments (clear)

  1. Re:Obvious solution by Anonymous Coward · · Score: 5, Funny

    MySQL is not web scale. He should use MondoDB. That is web scale.

  2. Re:If it a'int broke... by Anonymous Coward · · Score: 3, Funny

    Roger Moore's law.

    What does James Bond have to do with this?

  3. Re:If it a'int broke... by edittard · · Score: 4, Funny

    WTF? Software isn't subject to physical wear like an engine. Do you think friction will eventually turn a 1 into a 0 somewhere in the code?

    --
    At the bottom of the /. main page it says 'Yesterday's News'. Well they got that right.
  4. Re:Not to get buzzwordy, but Azure...the Cloud! by gmuslera · · Score: 4, Funny

    I don't understand why people complain so much about that service. 9.99999% of uptime should be good.