470,817 Members | 1,300 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,817 developers. It's quick & easy.

How to replicate database over multiple datacenters?

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
1 10079
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Sarah Tanembaum | last post: by
2 posts views Thread by Caroline Yong | last post: by
1 post views Thread by barry hampson | last post: by
2 posts views Thread by Petra Chong | last post: by
8 posts views Thread by situ | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.