BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-20-2008, 06:25 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2005
Model: 8100
Carrier: Vodafone
Posts: 21
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES Reliance on Remote SQL Database

Please Login to Remove!

Whilst I am going to test this, but does anyone know what will happen to BES if the Remote SQL Database goes down?
I understand you couldn't add / remove users or do any administration. However, would the Blackberry devices continue to work?
Offline  
Old 08-20-2008, 06:33 PM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

Wirelessly posted (Breaking Ball)

The handhelds will continue to function.
If you lose SQL connectivity, do NOT stop the BES services or restart the server. Without SQL, the services will not start back up.

How long of a SQL outage are you talking about here?
Minutes, hours, days?
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 08-20-2008, 06:34 PM   #3 (permalink)
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

They would continue to work on their own, but could not process any mail/contact/calendar/etc. synchronization.

I'm not sure about MDS - but I would guess that would not work as well.
__________________
Provision, maintain, and report on users via web: the NEW BerryStats | FAQ
Offline  
Old 08-20-2008, 06:43 PM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2005
Model: 8100
Carrier: Vodafone
Posts: 21
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The scenario is this -

Country 1, Has a Blackberry server for local users and has a Remote SQL Connection in the local country. (This SQL Server log ships to another location in this country)

Country 2, Has a Blackberry server for local users and has a Remote SQL Connection to the SQL server in Country 1.

NOTE - Both BES are in the same Config DB.

The issue we have is in a link issue between country 1 and 2 should we be SQL log shipping from Country 1 to Country 2. Or it is overkill.
What do other comapnies do?
Offline  
Old 08-20-2008, 06:49 PM   #5 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

I would get a local SQL server in Country 2 and run with 2 dbs.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 08-20-2008, 06:50 PM   #6 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

Wirelessly posted (Breaking Ball)

Quote:
Originally Posted by qc_metal
They would continue to work on their own, but could not process any mail/contact/calendar/etc. synchronization.

I'm not sure about MDS - but I would guess that would not work as well.
That's not correct.
Mail will still flow and the devices will not be adversely affected by the SQL outage.

After several hours of SQL being unavailable, the BES will likely start to get unhealthy and angry and then things will begin to fail.

A brief SQL outage of a few minutes or so would not even be noticed by the handhelds.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 08-20-2008, 06:55 PM   #7 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

Quote:
Originally Posted by penguin3107 View Post
Wirelessly posted (Breaking Ball)

Mail will still flow and the devices will not be adversely affected by the SQL outage.

After several hours of SQL being unavailable, the BES will likely start to get unhealthy and angry and then things will begin to fail.

A brief SQL outage of a few minutes or so would not even be noticed by the handhelds.
Yup. I've taken the SQL server down for maintenance and BES continue to function.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 08-21-2008, 08:57 AM   #8 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,761
Post Thanks: 275
Thanked 296 Times in 280 Posts
Default

Well I am glad to know this.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
Online  
Old 08-21-2008, 09:01 AM   #9 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2007
Model: 8330
PIN: N/A
Carrier: Sprint
Posts: 51
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would definitely second the statement to get another SQL server.

Do you have a fast network link between Country 1 and Country 2? If there is too much latency between Country 2's BES server and Country 1's SQL DB, it will not work. I believe RIM's recommended requirement is around 35-45ms. Trying pinging your SQL server from the Country 2 BES and see what your roundtrip response it. If it is above 75, you might want to call RIM and see what they have to say.
__________________
BES Admin
Offline  
Old 08-21-2008, 11:32 AM   #10 (permalink)
rsk
Thumbs Must Hurt
 
Join Date: Jan 2007
Model: 9630
Carrier: Sprint
Posts: 134
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

don't split your BES domain by adding another SQL server, you will create more problems than you solve. Stay with a single BES domain and a single SQL instance. BES will handle the outages just fine and as long as you don't need to provision during the outage there should be no problem.

rich
Offline  
Old 08-21-2008, 07:18 PM   #11 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2005
Model: 8100
Carrier: Vodafone
Posts: 21
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by housej55 View Post
I would definitely second the statement to get another SQL server.

Do you have a fast network link between Country 1 and Country 2? If there is too much latency between Country 2's BES server and Country 1's SQL DB, it will not work. I believe RIM's recommended requirement is around 35-45ms. Trying pinging your SQL server from the Country 2 BES and see what your roundtrip response it. If it is above 75, you might want to call RIM and see what they have to say.

We have a 10MB link between Country 1 and Country 2
Offline  
Old 08-26-2008, 06:14 AM   #12 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

Quote:
Originally Posted by Baguss View Post
We have a 10MB link between Country 1 and Country 2
The speed of the connection is not all that important.
What's the latency?
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
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





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