Re: Database replication

Michael Wimmer wrote:
> Hi,
>
> I need some advice on database replication.
>
> A customer wants his databases replicated between two servers,
connected
> by the internet. The database structure will be quite simple, mainly
> address data with about 100.000 entries in the beginning, but
steadily
> increasing.
>
> We expect an average of up to 2000 new inserts or edits per day.
>
> The customer wants the data to be stored in both databases, so
querying
> one database from the other is not an option.
>
> A perfect solution would allow both database servers to change data
and
> insert new records, but this could be discussed if it would make
things
> much more complicated.
>
> As a database Oracle and DB2 are into consideration so I am happy
with
> advice on both systems. Maybe someone can give me a hint which of
these
> two would be more suited for the task.

http://www.oracle.com/technology/products/dataint/pdf/ibm_comp.pdf http://www.oracle.com/technology/products/dataint/index.html
>
> Any help / advice highly appreciated

Oracle would be perfect for this. There are several options based on what requirements you want to satify. Sounds like multimaster replication would be your perfect solution. http://www.oracle.com/technology/products/dataint/pdf/distributed_environment.pdf But that might depend on why exactly the customer wants the data stored in both servers.

http://www.oracle.com/technology/deploy/availability/pdf/BWP_HA_Oracle_Database_10gR1_111503.pdf

http://www.oracle.com/ecostructure/blueprint_rec/rec_design_configuration_emc_srdf.htm

jg

--
@home.com is bogus.  "From 6 to 9AM on Christmas Day, we are going to
show a burning log in a fireplace."  "Why don't you do something
interesting every so often, like a sequined gloved hand throwing
evidence into the fire?  _That_ would be comedy!" - heard on radio