On 10 Feb 2005 at 9:58, dirknaudts wrote:

>> I think you jsut need replication.
>
>Yes I do indeed need replication, but I need it in realtime, not
>sheduled once or even a couple a times a day.

As you described below, you actually need not replication, but high
availability of database.

>I was in the assumtption that the available tools didn't do it in
>realtime. But now after reading further on ibphoenix.com about
>IBreplicator, it seems to be triggerable by events as well !

Theoretically - yes. In practice nobody use it. They just set up
replication every N seconds where N is reasonably small.

>So I guess I didn't do my research well :-(
>
>In my case the target database is a sleeping database, up until the
>master server dies, then the target becomes the master database.

From here a bit more details, please! How? Your application can
recognize server failure and switch to another one? Or something else
like DNS round-robin?

>I built the sync-server app with Kylix 3 using UIB components.
>Now that it's finished I wonder wether I should throw it away and go
>for the IBReplicator tool anyway... Especially the IBevent driven
>feature makes me doubt (so no polling needed !)

If I were you, I'd think about three-tier architecture...
--
SY, Dimitry Sibiryakov.