How to keep two database in sync ?

From: Roger <NOrgSPAM_at_mcs-hh.de>
Date: Mon, 14 Feb 2000 20:04:05 +0100
Message-ID: <889jh7$8nq$1@opal.hamburg.cityline.net>

I wan't to keep two databases in sync. One database is the production system, the other database is a backup system. Both are connected over a 2 MBit connection. Right now I'm considering 2 "solutions":

    1.) use replication
    2.) use a standby server (the archived logs a transfered to the backup
system)

What is the best solution for this problem ? Are there other solutions ?

BTW: The application is an interned based e-commerce system with a lot of DML statements.

Regards

Roger Received on Mon Feb 14 2000 - 13:04:05 CST