Sunday, February 19, 2012

HA / DR technology for SQL,Oracle,DB2

Does anyone have any reference to some of the terms used by the different
RDBMS vendors for the different HA/DR technology ?
For eg: I think Mirroring on SQL is Data Guard on Oracle and HADR on DB2A quick readup on IBM's HADR at http://www.dbazine.com/db2/db2-disa...ou
los19 show that it
is basically the same thing as database mirroring. They seem to have three m
odes (asynchronous,
near-synchronous, and synchronous) compared to SQL Server's two modes. But t
he technology behind
this are both based on re-playing log records on a standby server.
It seems like Oracle's Data Guard also is similar in implementation to Datab
ase Mirroring but with
two options. You either run it same thing as database mirroring. Or, you can
have it implemented
pretty much the same way as Transaction Replication (re-generating SQL state
ments from the log
instead of sending the physical log records), allowing fro different physica
l database schema on
standby server. http://www.oracle.com/technology/de...rdOverview.html
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.hotmail.com> wrote in message news:%23DUxW%239RHHA.4028@.TK2MSFTNGP03.phx.gb
l...
> Does anyone have any reference to some of the terms used by the different
RDBMS vendors for the
> different HA/DR technology ?
> For eg: I think Mirroring on SQL is Data Guard on Oracle and HADR on DB2
>
>

No comments:

Post a Comment