Performance issues with replication [message #74583] |
Mon, 10 January 2005 07:26 |
Jan-Hendrik van Heusden
Messages: 1 Registered: January 2005
|
Junior Member |
|
|
We want to use replication (with materialized views) to copy (a minor subset of, at most 5%) data from a transactional database to an operational (MIS, Management Information System) database. This will be done synchronously (thus an update, insert or delete on a table will be transferred immediately to the replicated system.
The performance of the source system will be critical (rather high workload, and real time reaction needed).
I wonder if synchronous replication (by means of Advanced Replication) will be an adverse influence on the workload and performance of the source system.
Can anyone tell more about this? (Alternatives also welcome in case this is not the recommended approach).
Thanks for your comments,
Jan-Hendrik van Heusden
|
|
|
Re: Performance issues with replication [message #74584 is a reply to message #74583] |
Tue, 11 January 2005 03:57 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
Synchronous replication is usually a bad idea. If your network goes down, nobody will be able to work on the primary database anymore. Best would be to consider near-real-time (async) alternatives.
Best regards.
Frank
|
|
|