+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Cluster failover in Technical; Hi All, We are looking at implementing a cluster failover system here so that if the SIMS server dies, another ...
  1. #1

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    793
    Thank Post
    157
    Thanked 102 Times in 71 Posts
    Rep Power
    178

    Cluster failover

    Hi All,

    We are looking at implementing a cluster failover system here so that if the SIMS server dies, another will just kick in and take over. Has anyone else done this? If you have, could you either reply to this post or e-mail me directly (shawkins@orwellhigh.com) as I have only just started looking in to this and it looks a little tricky (to say the least!!)

    Thanks for any help

    Stuart

  2. #2

    Join Date
    Nov 2006
    Posts
    998
    Thank Post
    132
    Thanked 58 Times in 51 Posts
    Rep Power
    24
    How about running the SIMS server virtually? There'd be a delay between the time it took to move the virtual machine to another host, but it would be less problematic than trying to set up a cluster.

    In fact, I'm sure you could store the SIMS database on a DFS share (It's MS SQL express, I think), and run the server in the virtual machine. Then store multiple copies of the virtual machine on various computers and simply switch them on if needed.

  3. #3

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    793
    Thank Post
    157
    Thanked 102 Times in 71 Posts
    Rep Power
    178
    Thanks for the idea, the trouble is the head wants it so that we don't have to take time out to switch anything over. He wants it so that if the server dies for any reason, the other one just starts working instead and the users don't notice anything has happened.

    Stuart

  4. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,691
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    I think that you will need to get into SQL database replication between the two servers as clustering by itself will probably not cut it when it comes to the continuity of data. Same thing with DFS the file would be considered open and therefore not replicated until the service closed the connection to it.

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,095
    Thank Post
    511
    Thanked 2,309 Times in 1,785 Posts
    Blog Entries
    24
    Rep Power
    803
    The problem here would be that the sims client uses the connect.ini file to connect to the server, and this will have the DNS name of the server hard coded into it will it not?

  6. #6

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,691
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    If you are using a combination of clustering and direct SQL replication the servers should show us as a single entity that is referenced by the connect.ini file.

  7. #7
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    29
    Clustering? Failover?

    Come on.. this is SIMS we're talking about here xD

  8. Thanks to Oops_my_bad from:

    danrhodes (9th January 2009)

SHARE:
+ Post New Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •