Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Real time backup database - hot standby

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Ranchers!!!

First of all, thanks a ton for making this place a virtual open classroom. Thanks for sharing the wealth of knowledge you have with the people who need the valuable inputs. It really works

I am back again with a question. Hoping to get many good inputs/suggestions.

Here is the question -

I need to have two exactly identical databases in my web application - one being the primary and another one as hot standby. Any update in the primary db should also be made in the standby db.
Can anybody on this forum please suggest how this can be accomplished? Are their any easier ways to implement this than to do this in the code itself?

Thanks in advance for your valuable suggestions.

Cheers,
Steve
 
Ranch Hand
Posts: 1970
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is this a question about Performance? If so, please explain how. Otherwise, I'll be moving it to JDBC.
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well, some replication schemes perform better than others, so maybe that's performance. It's not really JDBC as it should be well hidden way behind the JDBC interfaces. I'll happily leave the hard choices up to the authorities.

What database do you use? Most of the options depend on the vendor.

How much latency can you stand? The secondary database might be seconds, minutes or hours behind the primary.

How much data loss can you stand? Say the primary goes completely off the network and the last n minutes of data don't make it to the secondary.

How much downtime can you stand? It may take a few minutes of manual effort to get the standby in operation.

How much of a performance hit can you stand? The most responsive options are not free in this area.

Are there lives at stake? Mine? Customer orders? People playing online poker?
[ July 25, 2007: Message edited by: Stan James ]
 
Stephen King
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot for your response. Here are the key requirements -

a> The requirements say "hot standby" which is being interpreted as exact "replica" of the primary db. So there seems to be no scope of any data mismatch. Should not be close to the primary database but should be exactly the same.

b> The database being used is Oracle 10g.

c> How much is the tolerance for dataloss??
Well, I guess, as per the requirements there is no scope. Would like to understand first of all, are there any easier or pre-known methods of achieving this? Posting the question on Performance forum since the only option which comes to my mind is to do this from code and commit only when both the dbs are undated. But I suspect that it will no way be performant

Any suggestions please?

Cheers,
Steve
 
Where all the women are strong, all the men are good looking and all the tiny ads are above average:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic