BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-01-2005, 05:59 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Location: West Palm Beach, FL
Model: 8100
Carrier: T-Mobile
Posts: 122
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Standby Server 4.0

Please Login to Remove!

I was just curious as to which setup everyone is using for their backup servers with 4.0. i am in the process of building one up and was planning on using SQL to replicate the database from the production server. However i read a KB article from RIM today that said this is not possible.

Does anyone have a backup server setup with 4.0 and if so would you please give me a description of your setup.
Offline  
Old 06-01-2005, 09:38 PM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Thats odd that you wouldn't be able to replicate. I don't see why not, to be honest. I haven't quite addressed our backup plans just yet. I was going to do SQL replication between two servers, but I guess not now.

If that is the case, I am already planning on converging two local SQL databases for our two servers onto one server and I'll just make daily/nightly backups of it and restore as needed. I still haven't decided on the type of backup yet - either database-level or export/file-level.

Atleast with the shared database, I'll be able to move users from one server to the other w/o issues. I just really do not see why you cannot do an active-passive replication though.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 06-02-2005, 06:55 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Location: West Palm Beach, FL
Model: 8100
Carrier: T-Mobile
Posts: 122
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here is a link to the KB article.

http://www.blackberry.com/knowledgec...46147&vernum=1
Offline  
Old 06-02-2005, 08:31 AM   #4 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We have separate BES/SQL servers. I keep the backup server (same name and instance as the primary) down, turned off until the primary goes down. Then the backup pops up and no one notices anything.
Offline  
Old 06-02-2005, 08:36 AM   #5 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Well, atleast its a 'bug' that *may* be fixed sometime in the vague future.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 06-02-2005, 09:17 AM   #6 (permalink)
dev
CrackBerry Addict
 
dev's Avatar
 
Join Date: Apr 2005
Location: Toronto
Model: 8800
Carrier: Rogers
Posts: 571
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default

The reason that "transactional" replication may not be supported is because the config db does not update dramatically or change at such a high rate to be considered a high transaction db.
There are several types of "replication" methods for SQL dbs
1.SnapShot Replication
No transaction requirements
Low overhead
Replica only as current as last snapshot
2.Transactional Replication
Replical is nearly identical
Updated on a per transaction basis
Requires always up connectivity to subscriber servers
Higher overhead on SQl server
3.Merge Replication
Updates can be made at the publish or subscriber servers
Updated in batches
Ideal for distributed sites that update a central db
Merge replication not supported at this time
4.Log Shipping
Requires "Enterprise Edition"
Logs backed-up every 1-15mins and copied to standby server
Logs applied to standby server immediately
Standby server db not accessible while primary db is up
Files being copied have potential foe being large

RIM recommends the following:
Perform a once-a-day online backup to a network share or separate disk drive - back these up to tape
Perform regular nightly backups to tape of all dbs
Ensure that the master db is always backed up as part of a nightly backup routine.
Offline  
Old 06-02-2005, 08:55 PM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Location: West Palm Beach, FL
Model: 8100
Carrier: T-Mobile
Posts: 122
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

i figured as much... We are looking to have a quick failover... with the hurricanes down here we need something that we can start on the West Coast in less than 20 minutes... as of right now i have duplicate hardware and software setup and am planning on just setting up a script to copy the backup to the standby server nightly... in the event of downtime i should just need to restore the database on the backup server and start the services. hopefully less than 30 minutes.
Offline  
Old 06-02-2005, 10:20 PM   #8 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

hurricane on the east coast, earthquake on the west coast.

but seriously, with the size of the database, i don't see you having an issue with putting the server up within a few minutes. the frantic nature of failing over is what usually makes your actions take longer than you'd plan... the overthinking adrenaline rush that goes with the emergency times. fun fun. they say hurricane season is going to be just as bad as last year - woot!
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 06-15-2005, 01:12 PM   #9 (permalink)
New Member
 
Join Date: Apr 2005
Location: OR
Model: 8330
Carrier: Verizon
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Has anyone done a daily database dump, and held on to that for a restore to the backup server? We're evaluating all the options right now, and I was trying to find the simplest daily process.
Offline  
Old 06-15-2005, 04:54 PM   #10 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2005
Location: Denmark
Model: 7230
Carrier: TDC
Posts: 102
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

we are going to look at this for h/a http://www.neverfailgroup.com/products/nfblackberry.asp , only seen if from the docs , looks very interresing
Offline  
Old 06-23-2005, 07:42 AM   #11 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2005
Model: 9530
Carrier: Verizon
Posts: 57
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was just going to use Snapshot replication between the SQL Servers and our Domino admin was going to set up a cluster between the 2 BES server for the Domino pieces.
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.