db2 replication vs log shipping

Hi,

I'm trying to find an easy, efficient and safe site-to-site
backup/failover solution.
The idea is to have anytime a remote copy of 99.99% of the data.

Productive db -> VPN (internet) -> Backup site
source destination
Replication:
Slows down productive db
Quite difficult to invert the replication, backup site cannot go live
then back to the normal (backup) state again

Log shipping:
Quite a lot of data can be lost since the logfile size cannot always be
reduced

Has someone here some good or bad experiences doing this ?
Any ideas about bandwidth usage ?

Thanks, Greg

Nov 12 '05 #1

Subscribe Reply

4357

Dale McInnis

Greg
There are several options available for Disater Recovery:

Method

Pros

Cons

Transport of database backups
Low cost

Recovery to time of last backup
Lose all transactions since last backup

Transport of database backups and archived logs (physical/network)
Recovery to time of last archived log

Low cost
Lose all transactions in the active logs

Longer recovery time (database restore followed by roll-forward
through all the logs)

Standby Database via Log Shipping
Support for no transaction loss

Minimal impact to production system
Standby not available for use while in Rollforward mode

Standby needs to be physically and logically identical

Some administrative actions not reflected on standby (eg. NOT LOGGED
operations)

Standby Database via Replication
Can read (and write) standby

Standby need not be physically and logically identical

Can choose to replicate only critical tables
Transaction loss a possibility

Extra cycles on production database for transaction capture

Some administrative actions not reflected on standby (eg. NOT LOGGED
operations)

Synchronous mirroring of all data and log disks
No transaction loss

All changes to the database (including administrative) are replicated

Shortest restart time
Performance impact of synchronous mirroring to a geographically remote
site

High price (software/hardware/network)

I would also check out the up and coming release of DB2 UDB called Stringer:
http://www-306.ibm.com/software/data/db2/stinger/

Dale McInnis

"GB" <bo********@big foot.com> wrote in message
news:40******** @news.deckpoint .ch...

Hi,

I'm trying to find an easy, efficient and safe site-to-site
backup/failover solution.
The idea is to have anytime a remote copy of 99.99% of the data.

Productive db -> VPN (internet) -> Backup site
source destination
Replication:
Slows down productive db
Quite difficult to invert the replication, backup site cannot go live
then back to the normal (backup) state again

Log shipping:
Quite a lot of data can be lost since the logfile size cannot always be
reduced

Has someone here some good or bad experiences doing this ?
Any ideas about bandwidth usage ?

Thanks, Greg

Nov 12 '05 #2

Similar topics

5109

Oracle Rman Replication

by: RYAN | last post by:

Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do replication of Archives logs. In this way, one can setup some sort or Oracle Instances replication accross 2 machine at different sites. 1. Does amyone know how is the performance of this method of replication as

Oracle Database

2545

Looking for db replication tool

by: BobF | last post by:

I'd like to use log shipping to provide warm backup to some production MSFT SQL 2000 servers. I know that I can write something to ship logs but I'm looking for a complete solution that would take a while to write. Prefer not to upgrade to SQL enterprise (too costly). Is there a tool that provides a robust solution? ... deletes old log files, logs events, does backups, failure notification, recreates schemas, etc.

Microsoft SQL Server

1934

replication and log shipping

by: Eric | last post by:

Hi, Ive a few questions and would be grateful for any assistance/comments from experience as Ive not that much dba experience , we have 3 servers all containing sql 2000 standard edition, two (prod and standby) located in the U.S. and Im hoping to set up the third as a reporting server locally in Europe...presumably having the data close as possible and as current as possible for reporting?...We dont have the resources to implement...

Microsoft SQL Server

2127

Log Shipping for replication

by: T.Paakki | last post by:

I need to implement a dirt cheap replication method for some dirt cheap servers. We are using the SQL Server workgroup license. Is there anything in this that prevents using log shipping for replication in Workgroup versus Enterprise? Thanks Travis

Microsoft SQL Server

1600

Replication as backup

by: Ian Wyld | last post by:

Hello All We intend to replicate a database in order to have it as a near immediate standby in case of the failure of the main server. Is this the best solution for disaster recovery? We are currently testing our replication plan. When we set up the subscriber, a snapshot of the publisher is created and this takes hours. Is there a better way?

Microsoft SQL Server

1545

Backup transaction logs and replication simultaneously

by: Vincento Harris | last post by:

Is there any problem with implementating some kind of replication and backing up transaction logs at the same time? SQL Server 2000 Standard Edition The server is configured to back up log files regularly, with the presence of a(New) Disaster recovery server and with an inability for standby(Standard Edition)I am planning to implement some kind of replication hopefully still backing up the transaction logs to enable a point in time...

Microsoft SQL Server

1874

Replication Problem!

by: debian mojo | last post by:

Hello Group, I'm working on two SQL server databases on two different remote servers. What client needs is that his database on one remote server should be mirrored to the other one. The changed should be propogated at regular intervals at the other server. For now i'm quite sure that i'll have to use replication to resolve this issue. But which type of replication should i use? Transactional, Merge or

Microsoft SQL Server

446

Database Replication

by: Driesen via SQLMonster.com | last post by:

Hi everybody Can I replicate a database onto a seperate instance of SQL? I need to replicate a database to a stand-alone machine with no connectivety to anything. Does anyone know where I can find info on this? Thanks for any help. --

Microsoft SQL Server

2262

DB2 and File Replication

by: Tony Hinkle | last post by:

I am working on an application note to provide instructions on how to use a real-time file replication application to provide disaster recovery for DB2. I basically need to know how to identify what files need to be replicated for the default databases and others that are mounted. I would greatly appreciate any offered assistance. Thanks!

DB2 Database

9511

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10410

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10200

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10139

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9984

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9020

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5418

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3701

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General