data replication 的速度和稳定性

来源: 美国老土 2009-10-18 16:47:57 [] [博客] [旧帖] [给我悄悄话] 本文已被阅读: 0 次 (1205 bytes)
I will answer this way:
-- This is a good question.
-- First of all, when you as replication at here, I need to understand clearly what you realy mean.
-- You can relplicate only one table, or you can replicate the whole schema of tables from one database (or location) to the remote place.
What are you asking about at here.
-- Regardless what you really want to ask, the answer is: Yes, when you replicate the data to remote place, you have consider the data change rate or DML rate in your source database (or table).
-- Different databse offers different tools for replciate data, what kind of database are you using at here?
-- If you are using Oracle:
-- For single table raplication, you can use Materialized View ( I do talk Materialized View in my class);
-- For multi tables replication you can use Oracle Stream;
-- Or you can set up a hot standby database in the remote site and open for Read Only when your user use it to run the report.
-- If the data change rate is too high, and you don't want the lead time is too long, you may have to purchase third party tool like Shareplex to do the replication.
-- Am I answering your question?

Thanks!
请您先登陆,再发跟帖!

发现Adblock插件

如要继续浏览
请支持本站 请务必在本站关闭/移除任何Adblock

关闭Adblock后 请点击

请参考如何关闭Adblock/Adblock plus

安装Adblock plus用户请点击浏览器图标
选择“Disable on www.wenxuecity.com”

安装Adblock用户请点击图标
选择“don't run on pages on this domain”