This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Real time backup database - hot standby  RSS feed

 
Stephen King
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • 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
 
Peter Chase
Ranch Hand
Posts: 1970
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this a question about Performance? If so, please explain how. Otherwise, I'll be moving it to JDBC.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!