BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 10-05-2010, 07:10 AM   #1 (permalink)
Thumbs Must Hurt
 
elbutre's Avatar
 
Join Date: Oct 2006
Location: London
Model: 9700
Carrier: vodafone
Posts: 75
Post Thanks: 2
Thanked 2 Times in 2 Posts
Default bes 5.0 ha sql mirror placement of witness server

Please Login to Remove!

hi

i have 2 sites, our office and our DR site

i have 1 bes 5 primary server with sql server 2008 r2 principal besmgt database running in our office

i have 1 bes 5 standby server with sql server 2008r2 with besmgt mirrored.

i have also setup a 3rd sql express 2008 r2 in our DR site and use this as a witness server.

i am debating whether to put the witness server in our DR site or our office.

for instance if it is in our office and our office site goes down i cannot failover to the DR site sql server so i placed it in our DR site which means that SQL and bes both failover automatically.

but on the other hand this creates a situation if the DR site becomes inaccessible the principal sql database detects that both the mirror and witness server are not accessible and it goes into a standby mode. luckily the bes server remains operational even with the sql database being in the state it is in.

we only have 21 users so there is no way i am going to run sql and bes on separate servers and it would also still not solve the issue where to place the witness server.

my current thinking is to keep it in the DR site as this will:
a) enable me to failover automatically to the DR site if needed
b) if DR site goes down the bes server in the office still remains up and running even though the besmgt database goes into a standby state, i guess as long as you do not restart bes services it should be okay.

could you let me know where you have placed your witness server.

i do have an option btw to place the witness server at a 3rd site completely separate from the office and the DR site so perhaps that is the best solution?

cheers
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

25x 4Gb PC3-10600 1333MHz ECC Registered Server DDR3 Memory Modules
$375.0
25x 4Gb PC3-10600 1333MHz  ECC Registered  Server DDR3 Memory Modules  picturePrecision New DS3231 RTC Module Memory Module for Arduino Raspberry Pi M5V3
$2.1
Precision New DS3231 RTC Module Memory Module for Arduino Raspberry Pi M5V3 pictureOMRON Memory Cassette, ZEN-ME01
$54.75
OMRON Memory Cassette, ZEN-ME01 picture1PC Brand New Siemens Memory Card 6ES7 953-8LG20-0AA0 6ES7953-8LG20-0AA0 #RS02
$82.51
1PC Brand New Siemens Memory Card 6ES7 953-8LG20-0AA0 6ES7953-8LG20-0AA0 #RS02 pictureBrand New AB ALLEN BRADLEY 1756-L62 ControlLogix 4 MB Memory Controller 1756L62
$1883.96
Brand New AB ALLEN BRADLEY 1756-L62 ControlLogix 4 MB Memory Controller 1756L62 picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.