ddr question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gustavo Tobares - 31 Mar 2004 15:19 GMT

Hi all,

I making my first steps with HDR, it is configured and working but
I'm confused with the output of two commands:

informix> onstat -g dri

Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 22 days
01:5
9:15 -- 16384 Kbytes

Data Replication:

Type State Paired server Last DR CKPT (id/pg)

primary on simpedb 1810 / 211

DRINTERVAL 30

DRTIMEOUT 30

DRAUTO 0

DRLOSTFOUND /usr/informix7/etc/dr.lostfoundimpex

informix> onstat -g ddr

Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 22 days
02:0
1:38 -- 16384 Kbytes

DDR -- Down --

The replication seems to be working fine, why the second command show "DDR
-- Down --" ??

I appreciate any help, thank's in advance

Gustavo Tobares
Administrador de Sistemas y DBA
Centro de C?mputos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940

sending to informix-list

Reply to this Message

Curtis Crowson - 31 Mar 2004 21:11 GMT

> Hi all,
>
[quoted text clipped - 50 lines]
>
> sending to informix-list

There are two kinds of replication that informix implements.

High-Availability Data Replication which is what you are using (HDR).
And Enterprise Replication which you are not using (ER). The onstat -g
ddr shows you the status of ER which you aren't using so it will be
shown as down.

Informix 9.4 can actually use them both at the same time. In earlier
versions you have to choose. Each implementation has strength and
weaknesses. Each has its place.

ER replicates at the individual table level and the instances can be
different. It is harder to set up, but you can write to the secondary.
I think that you can have even more than one secondary database. I
think that you can even segment your data so that the replicated
instances only have partial data (this would be usefull for setting up
regional reporting databases). Of course it is much harder to set up.
Check out the "Guide to Informix Enterprise Replication" manual. See
you need a whole manual versus the 3 chapters you get for HDR.

HDR takes about an hour :-) to set up and works great as a hot spare
and reporting database.

Reply to this Message