Subject | Re: [ib-support] keeping current "standby" data |
---|---|
Author | Nando Dessena |
Post date | 2002-08-01T11:09:44Z |
Bernahrd,
technically possible to have a UDF connect to a *different* db to
execute replica SQL statements. I wouldn't do it that way, though. Since
a UDF runs in the process space of the server, I am for keeping them as
simple and robust as possible.
You could use a replication solution like IBReplicator or even develop
your own. The ingredients are triggers, POST_EVENT and a server side
application that wakes up on the events (or just polls the source DB)
and applies the deltas to the target DB. Like I said before,
IBReplicator offers all this and more out of a reasonably priced box.
Ciao
--
____
_/\/ando
> Shadowing can occur only to a local disk. Shadowing to a NFSIt is, shadowing is a local mechanism. And, while we're at it, it is
> filesystem or mapped drive is not supported.
>
> Is this information correct?
technically possible to have a UDF connect to a *different* db to
execute replica SQL statements. I wouldn't do it that way, though. Since
a UDF runs in the process space of the server, I am for keeping them as
simple and robust as possible.
You could use a replication solution like IBReplicator or even develop
your own. The ingredients are triggers, POST_EVENT and a server side
application that wakes up on the events (or just polls the source DB)
and applies the deltas to the target DB. Like I said before,
IBReplicator offers all this and more out of a reasonably priced box.
Ciao
--
____
_/\/ando