By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,406 Members | 1,353 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,406 IT Pros & Developers. It's quick & easy.

How to replicate database over multiple datacenters?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: 2
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.