How long does a HADR take to switch from primary to Secondary?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • pnsimham
    New Member
    • Nov 2011
    • 1
    #1

    How long does a HADR take to switch from primary to Secondary?

    We are looking at implementing HADR Solution to our OLTP databases and wanted to check how long does a HADR take to switch from primary to Secondary in real world?
    I have been reading documentation that it is fast, but the actual time is not mentioned any where. Wanted to see if it is less than 5 minutes or longer than it?
    Also, wanted to see what happens in case of a Crash to the primary? Will the secondary come up immediately or will it also go through the crash recovery?
    Tags: None
    • ggonsalves
      New Member
      • Nov 2011
      • 3
      #2
      HADR take less than a minute to switch over from primary to secondary. The best way to test is to configure one on you test environment. It is very simply to configure.

      If you need to configure a HADR environment on VMWare for test purpose below link will help you.

      DB2 9.7 HADR with TSA - Part 00
      http://gilroygonsalves.blogspot.com/2010/11/db2-97-hadr-with-tsa-part-00.html
      In coming weeks before I start my Christmas vacation, i would be presenting series of blogs explaining the DB2 9.7 HADR configuration using...

        Comment

        Previous template Next
        Working...