SQL-UP for HA

  • Anyone tried SQL-UP from incepto (one of the site sponsors) for a High Availability solution.

    It looks like it does the job but I was interested if anyone had tried it and had a view?

    Thanks

    Craig

  • They did us a demo for us (me, Steve, Brian) at Pass, looked decent, very fast failover. It uses replication which adds some complexity there, but of course you dont have the complexity of clustering and you could do it over a WAN to a remote location. Worth looking at it I think. Check the licensing, not sure I remember, but might have been per db.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • Indeed it looked slick and I wish I'd set it up and tested it.

    Few issues, basically makes 3 copies (4 total) of the database, so space can be an issue. Also needs fairly high speed connections for the replication and failover pieces, but failed over in like 3-4 seconds. Very slick.

    Doesn't tolerate schema changes, but the tear down and rebuild of the HA is (supposedly) a simple process.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • We have trialled it on the minimum specs between 3 machines ( many to one). Found that it worked well for our small databases, but when we got to our large ones, I ran into problems.

    The connection speed between the servers needs to be good and fast as the cluster fails when it cannot contact the other server.

    I think if we had trialled it on an equivalent to our production servers with lots of disk space and memory etc it probably would be ok.

    I fould it very easy to install and use.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply