Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Recommended Stretagy for Bi-Directional SQL DB Synchronization

Re: Recommended Stretagy for Bi-Directional SQL DB Synchronization

From: DA Morgan <>
Date: Fri, 11 Feb 2005 09:59:07 -0800
Message-ID: <1108144580.890529@yasure> wrote:

> Hi,
> Our company is an independent Voice applications solution provider with
> number clients using our suite. We have a CT application suite which is
> running with Application Server and SQL Server 7 / 2000 as DB Engines
> at the back end.
> The SQL server has two databases configured:
> Logging Database - Massive updates every second, the data grows
> rapidly,
> Configuration Database - Generally small-sized and updated
> occasionally.
> Now we want to have the reslience implemented on the server. We have to
> synchronize the two databases 'real-timely' and in 'efficient'
> manner, so that if Primary server or its Databases gets unavailable,
> the users are seamlessly switched over to the Secondry server that will
> have its own set of data updated and well synchronized.
> Typically, it can be explained as follows:
> 1. We will have 2 database servers A - Primary (acting as publisher)
> and B - Secondary (acting as subscriber). Our application will be
> initially connected to A.
> 2. When A becomes unavailable (for whatever reason), the application
> will fail-over to B.
> 3. All the users will be switched to server B and the updates are being
> done accordingly without being replicated on Server A temporarily.
> 4. When A is back on-line, A needs to be brought up-to-date with B
> automatically (In other words, I shouldn't have to manually export all
> the data from B to A ).
> Our requirements are:
> - The system should support Bi-directional Synchronization
> between both the servers for their set of databases (the logging and
> configuration).
> - There will be constant and heavy activity in Logging
> Database, thus if one server gets down the data should be logged and
> maintained as it is on second server and on fail-back no data-loss
> should occur with minimum latency time.
> - There could be a scenario when a server fails-over for a
> week's time, there will be constant logging each second! Once it
> fails-back the system should rapidly synchronize the data without
> noticeable delay among the two server database sets.
> - The system should also work fine if certain amount of
> records are purged over a time period.
> Our concern is, observing the above scenario, how any of your SQL
> server replication strategy can help us achieve the requirements.
> Thanks
> John

What does any of this have to do with Oracle?

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Fri Feb 11 2005 - 11:59:07 CST

Original text of this message