2-Phase commit or replication?
From: Mr Michael Wai Kee Yung <myung_at_hk.super.net>
Date: 1995/05/30
Message-ID: <3qfd01$142_at_tst.hk.super.net>#1/1
Date: 1995/05/30
Message-ID: <3qfd01$142_at_tst.hk.super.net>#1/1
Dear all, my company is running a 40-50 Gigabyte database using Oracle 7. We're planning to set up a secondary site as the backup of our business database. Could you all experts give me a clue what's the best solution to implement this? I mean what's the pros and cons to use 2PC or replication? Is 2PC a high performance penalty option? Would appreciate if you can share with me your experience. Many thanks in advance.
+--- vwwwwwv ---------+---------------------------------+ | yyyywww | Born To Be Wired ... | ---| q-O-O-p Michael | |--- \ | | L | Yung | Internet : myung_at_hk.super.net | / \ | ` `-' ' | CompuServe : 100314,345 | / / | `---' | | \ / +-oOOo/ \oOOo-------+---------------------------------+ \ ----+ +----Received on Tue May 30 1995 - 00:00:00 CEST