并行数据库 [英] Parallel Database
问题描述
DB2 UDB是否支持并行数据库，即同时在多个节点上进行处理
，允许用户同时在一个节点上比另一个节点更活跃。这是为了允许故障转移以及
负载平衡？
Oracle中是否存在等效的Real Application Cluster（RAC）。
我们可以在应用程序级集群，而不是硬件，例如
HACMP。
谢谢& Rgds，
F
Does DB2 UDB support parallel database i.e processing is taking place
on multiple nodes at the same time allowing users to be active on more
than one node simultaneously. This is to allow for failover as well as
load balancing?
Is there an equivalent of Real Application Cluster (RAC) in Oracle.
Where we can cluster at application level rather then hardware such as
HACMP.
Thanks & Rgds,
F
推荐答案
DeeBee2写道：
DeeBee2 wrote:
DB2 UDB支持并行数据库，即同时在多个节点上进行处理，允许用户同时比一个节点更活跃。这是为了允许故障转移以及负载平衡吗？
在Oracle中是否存在等效的Real Application Cluster（RAC）。
我们可以在应用程序级别进行集群那么硬件如
HACMP。
Does DB2 UDB support parallel database i.e processing is taking place
on multiple nodes at the same time allowing users to be active on more
than one node simultaneously. This is to allow for failover as well as
load balancing?
Is there an equivalent of Real Application Cluster (RAC) in Oracle.
Where we can cluster at application level rather then hardware such as
HACMP.
相当多的问题。您一次要求提出两个问题：
故障转移和并行化
DB2支持通常所说的无共享并行性
向外扩展。
这与故障转移没什么关系。这是纯粹的品种规模，面向> 500GB数据，价格为
。
通常DPF（数据分区功能）用于仓储。
但OLTP应用程序，如果设计得当，也可以利用它的b $ b。
对于故障转移，您可以使用Veritas或您提供的解决方案
可以使用HADR。
Wrt RAC没有直接匹配。 DPF安装有一个更大的
（更极端）的甜点，> 100个节点成为典型的，但是它们没有HACMP就不适合高可用性。
HADR是纯粹的故障转移和灾难恢复解决方案（对于
灾难恢复，您需要Oracle中的数据保护，而不是RAC）。
直接比较这些是没有意义的，因为它们解决了不同的
要求
告诉我们更多关于问题的业务需求。否则
这个线程很快就会变成火焰战。
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
Pretty loaded question. You are asking for two questions at once:
Failover and Parallelism
DB2 supports what is commonly called shared nothing parallelism for
scale out.
This has little to do with failover. It''s pure breed scale out geared
towards >500GB data.
Typically DPF (Data partitioning feature) is used for warehousing.
But OLTP applications, when designed properly, can also take advantage
of it.
For failover you can use solutions such as provided by Veritas or you
can use HADR.
W.r.t RAC there is no direct match. DPF installations have a bigger
(more extreme) sweet spots with >100 nodes becoming typical, but they
are not geared for high availability without HACMP.
HADR is a pure breed failover and disaster recovery solution (for
disaster recovery you need dataguard in Oracle, not RAC).
It makes no sense to directly compare these since they address different
requirements
Tell us more about the business requirement of the question. Otherwise
this thread is going to turn into flame war in no time.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Serge Rielau写道：
Serge Rielau wrote:
DeeBee2写道：
DeeBee2 wrote:
DB2 UDB是否支持并行数据库，即在多个节点上进行处理同时允许用户成为同时比一个节点更活跃。这是为了允许故障转移以及负载平衡吗？
在Oracle中是否存在等效的Real Application Cluster（RAC）。
我们可以在应用程序级别进行集群那么硬件如
HACMP。
Does DB2 UDB support parallel database i.e processing is taking place
on multiple nodes at the same time allowing users to be active on more
than one node simultaneously. This is to allow for failover as well as
load balancing?
Is there an equivalent of Real Application Cluster (RAC) in Oracle.
Where we can cluster at application level rather then hardware such as
HACMP.
相当多的问题。你一次要问两个问题：
故障转移和并行性
Pretty loaded question. You are asking for two questions at once:
Failover and Parallelism
有一家公司（xkoto）开发了一个软件/硬件
解决方案，它提供了与DB2 UDB相当的RAC。我相信
对你使用的客户端软件有一定的限制。
我没用过这个，但它似乎是一个有趣的技术。
There is a company (xkoto) that has developed a software/hardware
solution that provides the equivalent of RAC for DB2 UDB. I believe
there are certain limitations as to the client software you use.
I haven''t used this, but it seems like an interesting technology.
有趣......
http://www.eweek.com/article2/0,1759...119TX1K0000594
关于NOT DETERMINISTIC和EXTERNAL ACTION事件的一些明显问题。
但它将涵盖很多情况。
不清楚他们如何添加节点或重新集成弹跳系统...（同步）
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
Interesting...
http://www.eweek.com/article2/0,1759...119TX1K0000594
Some obvious issues around NOT DETERMINISTIC and EXTERNAL ACTION events.
But it will cover many cases.
Not clear how they add a node or re-integrate a bounced system... (synch up)
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
这篇关于并行数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
