BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-04-2006, 05:27 AM   #1 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Database Questions

Please Login to Remove!

I want to start thinking about DR for my Blackberry’s and want to know if anyone is clustering their SQL database over two servers? Can it be done?

Secondly they who must be obeyed have said there is no money available so want to do it on the cheap so it means looking into sharing the server with other Databases, can this be done or does it need a dedicated SQL server?
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 07-04-2006, 08:51 AM   #2 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can you no use SQL clustering with the BlackBerry Enterprise Server. The database does not replicate well, and it will not work for DR. The best way to get it to work is to just do a daily backup, and then restore it on another SQL server...

You can share a database between two BlackBerry Enterprise Server. The good thing about this is that when you move a user from one BlackBerry Enterprise Server to the other they do not need to re-cradle, and it is seamless to the user.

You donxxx8217;t need a dedicated SQL server. I have done it with MSDE. You just need to make sure that TCP/IP and Named Pipes are enabled within the svrnetcn utility, and the service account has permissions.
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator
Offline  
Old 07-04-2006, 09:05 AM   #3 (permalink)
Thumbs Must Hurt
 
timay's Avatar
 
Join Date: Jan 2006
Location: Nottinghamshire- UK
Model: 8900
OS: 4.6.1.101
PIN: 208db57b
Carrier: O2
Posts: 53
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by SimonMac
Secondly they who must be obeyed have said there is no money available so want to do it on the cheap so it means looking into sharing the server with other Databases, can this be done or does it need a dedicated SQL server?
Yes, I currently run our company BES on a shared SQL server, than runs a number of databases.

I haven't tried to cluster them though, just do a manual daily backup
Offline  
Old 07-04-2006, 02:13 PM   #4 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

Just to let all know that SQL replicaton is not supported, so do not try...

KB-04044 Known Issues - SQL replication not supported for the BlackBerry Enterprise Server
http://www.blackberry.com/knowledgec...?nodeid=946147

Cheers!
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 07-05-2006, 03:13 AM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bummer!

Whats the best route then to head down for Disaster Recovery then?
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 07-06-2006, 07:52 AM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: Philly
Model: 8700
Carrier: AT&T
Posts: 20
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES DR is a manual process without 3rd party tools

For DR you have to manually re-install everything, then restore. RIM does not have any good options for failover or DR.
We will soon be testing a product that looks promising:
http://www.neverfailgroup.com/products/nfblackberry.asp
Offline  
Old 07-06-2006, 08:34 AM   #7 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

raise my both hands to weazbo... every company has their own DR, depending on available resources and $$$ of course ;) Actually a DR plan is pretty much dependent on each company budgets + policies... there is no single model DR plan...
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 07-27-2006, 07:46 AM   #8 (permalink)
Thumbs Must Hurt
 
Join Date: Feb 2006
Model: 8330
Carrier: Verizon
Posts: 142
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by ashworth
Can you no use SQL clustering with the BlackBerry Enterprise Server. The database does not replicate well, and it will not work for DR. The best way to get it to work is to just do a daily backup, and then restore it on another SQL server...

You can share a database between two BlackBerry Enterprise Server. The good thing about this is that when you move a user from one BlackBerry Enterprise Server to the other they do not need to re-cradle, and it is seamless to the user.

You don’t need a dedicated SQL server. I have done it with MSDE. You just need to make sure that TCP/IP and Named Pipes are enabled within the svrnetcn utility, and the service account has permissions.
Is there any documentation on how to do this with MSDE? I'd love to set this up...
__________________
8330 4.5.0.77 OS - PIN: 303297df
BES Admin:
5x4.1.6 Exchange - 700 Users
"Sink or Swim" Educated
Offline  
Old 07-27-2006, 08:44 AM   #9 (permalink)
Thumbs Must Hurt
 
Join Date: Feb 2006
Model: 8330
Carrier: Verizon
Posts: 142
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ignore. New Thread...
__________________
8330 4.5.0.77 OS - PIN: 303297df
BES Admin:
5x4.1.6 Exchange - 700 Users
"Sink or Swim" Educated
Offline  
Old 06-19-2007, 10:27 AM   #10 (permalink)
New Member
 
Join Date: Jun 2007
Model: 8700c
PIN: N/A
Carrier: Cingular
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by kpoland View Post
Ignore. New Thread...
Where is the new thread?

Last edited by almullaney : 06-19-2007 at 11:22 AM.
Offline  
Old 06-19-2007, 10:28 AM   #11 (permalink)
New Member
 
Join Date: Jun 2007
Model: 8700c
PIN: N/A
Carrier: Cingular
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

where is new thread?
Offline  
Old 06-19-2007, 11:39 AM   #12 (permalink)
New Member
 
Join Date: Jun 2007
Model: 8100
PIN: N/A
Carrier: T-Mobile (UK)
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by SimonMac View Post
I want to start thinking about DR for my Blackberryxxx8217;s and want to know if anyone is clustering their SQL database over two servers? Can it be done?
You could try log shipping for the SQL side (start 2 SQL servers with same copy of DB, then ship logs from active server the the backup server, idea is any changes/updates/etc done to server 1 are done to server 2). Means you will have a CURRENT live DB to either move to or backup and restore from.

As for the BES Server itself...and the SQL if you want...NeverFail is a technology I have tried before and does work damn well! But it does cost, in terms of duplicate hardware mainly. I tested it on a dedicated SQL2000 server running a 75Gb DB with 100 users thrashing hell out of it and only ever managed to lose current transactions when forcing a fail.

Hope this helps

Last edited by QuaCKeReD : 06-19-2007 at 11:41 AM.
Offline  
Old 06-19-2007, 05:43 PM   #13 (permalink)
New Member
 
Join Date: Apr 2005
Location: Florida
Model: 8100G
Carrier: Cingular
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up DR Option

I currently have blackberry running MSDE. I use SQL2000 tools to a backup and dumb the file to a folder on the win2k3 blackberry server. From there I have a windows job that copies that file weekly to our backup server in another facility. On the backup server I have another windows Job that runs a script that restores the file to the backup blackberry server. If you do not have log shipping this works great. I even did a DR test and had everyone working from the backup server. The only thing you need to be carefull you do not have the BB services running on both boxes or you can lock your SRP account and will have to call RIM to unlock the account. I only run the backup and restore once a week, but if a hurricane starts coming towards florida I can manually run the job.

Hope this helps I spent many hours trying to get info on setting up a DR Server.
Offline  
Old 06-19-2007, 09:53 PM   #14 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

That is one crazy DR implementation. Please tell me you've got that process documented. Sounds like a great "poor mans" DR solution. Besides all the custom scripting its totally supportable. Nice Job!
Offline  
Old 07-04-2007, 02:43 PM   #15 (permalink)
New Member
 
Join Date: Jul 2007
Model: 8300
PIN: N/A
Carrier: AT&T
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

who said you can't use SQL clustering as the back-end for a BES Server? I have it running just fine in our environment.

I have a standard 2-node active/passive SQL 2000 cluster and the BES configuration database is on it. There is no replication involved when you do clustering. Clustering is where 2 or more servers are sharing the SAME storage area. So they are sharing the same SQL database.

In this case, an active/passive cluster only has 1 node active at any given time. If that node fails, the passive node kicks in and becomes active. But it is still using the SAME database.

All you do is configure the BES server to connect to the Virtual SQL instance that is created in the cluster. This virtual instance ALWAYS stays active and is moved between the 2 nodes. So if one node fails, the Virtual instance is always still avaiable. Depending on how well you tune your SQL cluster, you will only see a 1-3 second delay in interruption before the other node becomes active.

In our environment, I have 2 BES servers, both sharing the same configuration database. That database is then on a SQL cluster. So I have the best of both worlds. I have DR at both levels of the BES environment.

SQL clustering is a more expensive DR solution, since you have to use the Enterprise Edition of Windows server, as well as have a SAN or some other Array that supports clustering hardware, but if you already have the hardware environment and you already have a cluster, SQL clustering is the BEST DR solution for a BES environment, and requires no manual scripting, tweaking, or modding.
Offline  
Old 07-04-2007, 04:13 PM   #16 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can use it, and it does work ... but as with Exchange clustering generally adds more complexity than it is worth.

SQL Clustering may be THE BEST DR solution for you; certainly isn't for me.
Offline  
Old 07-05-2007, 09:09 AM   #17 (permalink)
New Member
 
Join Date: Jul 2007
Model: 8300
PIN: N/A
Carrier: AT&T
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Exchange clustering and SQL clustering are actually very easy. but then again, I've been an MS engineer for 10+ years...;)

Yes, there are many DR solutions, and obviously choose the one that best suits your environment, skillset, resources, and ultimately your budget.

Just wanted to make sure it was clear that clustering IS supported, contrary to the original reply to the poster.

cheers
Offline  
Old 07-05-2007, 09:16 AM   #18 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

absolutely ... when you deal with clustering on a regular basis its second nature ... I'm sure there are lots of us that can do clustering better than installing Vista! ... but the problem comes in when someone installs a cluster and never tests failover / failback because the servers just work.
Offline  
Old 07-05-2007, 09:43 AM   #19 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

SQL clustering may be the best DR option for continuous operation but take special attention to a known potential error due to clustered index during a major service pack upgrade for BES where the database schema requires to be updated by the installer.

For more information see KB03569 under Cause 1. Anything virtual will break at some point; it's just a matter of time.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 07-05-2007, 10:20 AM   #20 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Using SQL as replication works great and its not as hard as it seems. What backup software do you use? I would suggest going the route of using Veritas SQL Replication. it does it Hot, easy to re-attach / restore and does it on the byte or file level.
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.