Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

mirror activator destination be used for backups and recovery?

5 posts in Backup and Recovery Last posting was on 2009-05-19 14:47:26.0Z
Dan Posted on 2009-05-07 21:01:17.0Z
From: "Dan" <danNOSPAM@pancamo.com>
Newsgroups: sybase.public.ase.backup+recovery
Subject: mirror activator destination be used for backups and recovery?
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a034c1d$1@forums-1-dub>
Date: 7 May 2009 14:01:17 -0700
X-Trace: forums-1-dub 1241730077 10.22.241.152 (7 May 2009 14:01:17 -0700)
X-Original-Trace: 7 May 2009 14:01:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3964
Article PK: 48052

We have the following with ASE 15...


Current Backup Path: SAN ------ 2GbsFC------Sun(ASE 12) ---
DUMP---1GBE ---- NAS2
New Backup Path: Netapp --- 1GbsNFS --- Sun(ASE 15) ----
DUMP---1GBE ---- NAS2

Backup dumps in new environment max out the 1Gbit (Netapp) link in the new
environtment and is slower (by about 20 minues) than the old environment...
Backing up about ~100GB

So we are looking for new backup solutions... NFS over the 1Gbit link works
great for everything except dump (sequential read IO) which is about 20-30%
slower....

We are looking to put 10gbe links which hopefully should solve the issue,
however we also are looking for other ideas...

Would the following work. This basically this would offload all the backup
to a secondary server... It could also server as a HA server?

Netapp --- 1GbsNFS --- Sun(ASE 15) ---> replication/mirror
ctivator -----> Sun(ASE 12) ---4GBFC---SAN/SSD ---- DUMP---1GBE ---- NAS


Basically, can the mirror activator destination be used for backups? If so,
would our sybase dba's have issues with this configuration?


"Mark A. Parsons" <iron_horse Posted on 2009-05-07 21:55:10.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: mirror activator destination be used for backups and recovery?
References: <4a034c1d$1@forums-1-dub>
In-Reply-To: <4a034c1d$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 090425-0, 04/25/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a0358be@forums-1-dub>
Date: 7 May 2009 14:55:10 -0700
X-Trace: forums-1-dub 1241733310 10.22.241.152 (7 May 2009 14:55:10 -0700)
X-Original-Trace: 7 May 2009 14:55:10 -0700, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3965
Article PK: 48054


> Netapp --- 1GbsNFS --- Sun(ASE 15) ---> replication/mirror
> ctivator -----> Sun(ASE 12) ---4GBFC---SAN/SSD ---- DUMP---1GBE ---- NAS
>
>
> Basically, can the mirror activator destination be used for backups? If so,
> would our sybase dba's have issues with this configuration?

Technically this is doable.

Business-wise ... *shrug* ... it's your call.

What happens if the replicate db goes down ... you're now left without a backup solution for the primary database.

What do you plan on using for the mirrored log (ie, the device that mirror activator reads from)? a local or
network-based disk?

Are you going to make sure the mirrored device is run in synchronous mode with the primary log device? and if so, will
the network hop from the primary device to the mirror device be fast enough that you won't notice any unwanted
performance degradation in log writes to disk (ie, the primary and mirror devices would have to complete the disk write
before control is returned to Sybase)?

Do you have repserver experience in house?

Do you have mirror activator experience in house?

How about switching the ASE 15 instance to run off the 4GBFC/SAN/SSD, ie, switch the disks on the ASE 12 and ASE 15
instances?

Personally, the repserver/mirror-activator solution sounds like overkill (price-wise, component-wise, support-wise,
headache-wise) if all it takes is a (relatively) quick upgrade of the connection between the ASE 15 instance and its
disk subsystem.


Dan Posted on 2009-05-19 14:47:26.0Z
From: "Dan" <danNOSPAM@pancamo.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <4a034c1d$1@forums-1-dub> <4a0358be@forums-1-dub>
Subject: Re: mirror activator destination be used for backups and recovery?
Lines: 78
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a12b5d2@forums-3-dub.sybase.com>
X-Original-Trace: 19 May 2009 06:36:18 -0700, vip152.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 19 May 2009 07:47:23 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 May 2009 07:47:26 -0700
X-Trace: forums-1-dub 1242744446 10.22.108.75 (19 May 2009 07:47:26 -0700)
X-Original-Trace: 19 May 2009 07:47:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3970
Article PK: 48060

Thanks for the info! responses below...

"Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in message
news:4a0358be@forums-1-dub...
>
>
>> Netapp --- 1GbsNFS --- Sun(ASE 15) ---> replication/mirror
>> tivator -----> Sun(ASE 12) ---4GBFC---SAN/SSD ---- DUMP---1GBE ---- NAS
>>
>>
>> Basically, can the mirror activator destination be used for backups? If
>> so, would our sybase dba's have issues with this configuration?
>
> Technically this is doable.
>
> Business-wise ... *shrug* ... it's your call.
>
> What happens if the replicate db goes down ... you're now left without a
> backup solution for the primary database.

Right now if our primary goes down, we are down until a restore is done...
hours...


> What do you plan on using for the mirrored log (ie, the device that mirror
> activator reads from)? a local or network-based disk?

Haven't got this far in the thought process yet...

>
> Are you going to make sure the mirrored device is run in synchronous mode
> with the primary log device? and if so, will the network hop from the
> primary device to the mirror device be fast enough that you won't notice
> any unwanted performance degradation in log writes to disk (ie, the
> primary and mirror devices would have to complete the disk write before
> control is returned to Sybase)?




> Do you have repserver experience in house?

yes


> Do you have mirror activator experience in house?


not yet...


> How about switching the ASE 15 instance to run off the 4GBFC/SAN/SSD, ie,
> switch the disks on the ASE 12 and ASE 15 instances?


FC = significant increase in complexity and decrease in flexibility over NFS
and only slight gain in backup performance. Also with large RAM caches,
almost a no increase in transactional performance.





> Personally, the repserver/mirror-activator solution sounds like overkill
> (price-wise, component-wise, support-wise, headache-wise) if all it takes
> is a (relatively) quick upgrade of the connection between the ASE 15
> instance and its disk subsystem.

You may be right, mirror-activator on paper sounds good but we don't have
any experience on it yet... I was hoping someone here has some production
experience...


Peter Collard Posted on 2009-05-11 14:11:41.0Z
Message-ID: <4a08321d@forums-1-dub>
From: Peter Collard <peter@glossop.org>
Subject: Re: mirror activator destination be used for backups and recovery?
Newsgroups: sybase.public.ase.backup+recovery
References: <4a034c1d$1@forums-1-dub>
Lines: 8
User-Agent: KNode/0.10.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 11 May 2009 07:11:41 -0700
X-Trace: forums-1-dub 1242051101 10.22.241.152 (11 May 2009 07:11:41 -0700)
X-Original-Trace: 11 May 2009 07:11:41 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3966
Article PK: 48055


> Current Backup Path: SAN ------ 2GbsFC------Sun(ASE 12) ---
> DUMP---1GBE ---- NAS2
> New Backup Path: Netapp --- 1GbsNFS --- Sun(ASE 15) ----
> DUMP---1GBE ---- NAS2
>

Have you tried increasing the number of stripes to see if you can reduce
latency losses with the NFS.


Dan Posted on 2009-05-19 14:02:37.0Z
From: "Dan" <danNOSPAM@pancamo.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <4a034c1d$1@forums-1-dub> <4a08321d@forums-1-dub>
Subject: Re: mirror activator destination be used for backups and recovery?
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a12ab10$1@forums-3-dub.sybase.com>
X-Original-Trace: 19 May 2009 05:50:24 -0700, vip152.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 19 May 2009 07:01:29 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 May 2009 07:02:37 -0700
X-Trace: forums-1-dub 1242741757 10.22.108.75 (19 May 2009 07:02:37 -0700)
X-Original-Trace: 19 May 2009 07:02:37 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3969
Article PK: 48059

Yes, tried just about every dump option... We've come to the conclusion
that the bottleneck is either latency and/or 1gbit link. We are upgrading
to 10gbit between the server and the filers and we should have the results
shortly....

But it sure would be nice to have another method that offloaded the backups
from the primary disks...

"Peter Collard" <peter@glossop.org> wrote in message
news:4a08321d@forums-1-dub...
>> Current Backup Path: SAN ------ 2GbsFC------Sun(ASE 12) ---
>> DUMP---1GBE ---- NAS2
>> New Backup Path: Netapp --- 1GbsNFS --- Sun(ASE 15) ----
>> DUMP---1GBE ---- NAS2
>>
>
> Have you tried increasing the number of stripes to see if you can reduce
> latency losses with the NFS.