+ 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
    834
    Thank Post
    177
    Thanked 105 Times in 73 Posts
    Rep Power
    185

    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
    25
    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
    834
    Thank Post
    177
    Thanked 105 Times in 73 Posts
    Rep Power
    185
    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
    11,239
    Thank Post
    882
    Thanked 2,742 Times in 2,316 Posts
    Blog Entries
    11
    Rep Power
    784
    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
    18,132
    Thank Post
    522
    Thanked 2,542 Times in 1,976 Posts
    Blog Entries
    24
    Rep Power
    876
    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
    11,239
    Thank Post
    882
    Thanked 2,742 Times in 2,316 Posts
    Blog Entries
    11
    Rep Power
    784
    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
    30
    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
  •