How to replicate database over multiple datacenters?

J Kirkpatrick

For a recent project I got assigned for our company, we are going to start replicating our database across multiple data centers across the world to help decrease load and latency issues for regional offices.

What tips and good practices do you suggest for implementing this kind of infrastructure?

We have concerns about, speed, freshness of data, security, maintenance issues from dealing with so many machines, automation, etc?

thanks,
J. Kirkpatrick

Sep 29 '10 #1

sreehari9

it depends on what RDBMS are you working on. If it is on Oracle you can use Oracle datagaurd/traditional standy(logical/physical). or you can opt for Oracle Streams/Oracle Advanced queues. or also use Oracle Golden gate to replicate the data.
If it is UDB DB2 . You can use with Federations/Q-REP technology to replicate data accross data centres.

Jul 30 '13 #2