DB2集群 [英] DB2 Clustering

问题描述

我们正在考虑开始在DB2 V8中使用集群。我理解，当一个节点出现故障时，如果有节点，那么其他节点将为用户保留数据库。我想要知道的是，如果节点发生硬盘驱动器崩溃并且

磁盘不可抢救，或者只是机器断开连接，那么这包括吗？ />
如果使用新机器替换损坏的机器怎么一起同步？b $ b同步？任何有关该主题的信息将不胜感激。


Daniel G. Cantua

洛杉矶县 - ISD

We are thinking of starting to use clustering with our DB2 V8. I
understand that with clustering when a node goes down that the other
nodes will keep the database up for the users. What I would like to
know is does this include if the node has a hard drive crash and the
disks are not salvagable or just if the machine looses connection?
And if a new machine is used to replace the damaged one how does it
sync together? Any information on the subject will be appreciated.

Daniel G. Cantua
Los Angeles County - ISD

推荐答案

Daniel，


你下载过DB2 Stinger吗？鉴于你只是开始

外观您想要将HADR添加到您的选择中。偷看:-)


干杯

Serge

-

Serge Rielau
DB2 SQL编译器开发

IBM多伦多实验室

Daniel,

Have you downloaded DB2 Stinger? Given that you are just "starting to
look" you want to add HADR to your choices. Take peek :-)

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

基于群集的高可用性往往通过组合多端口磁盘来实现br />
设备，

当

a处理器失败，在那里运行的服务（可能包括
a DB2节点

又称处理分区）在备用处理中重新启动设施

（可能有以前闲置的
，或者已经装好的处理器设置为

吸收

故障转移中的额外工作负载）。与

失败节点相关的磁盘资源

也需要从新节点访问。


磁盘（媒体）恢复通常不是这张图片的一部分。其他方法

用于

，包括RAID /镜像和数据库恢复（恢复和

前滚）。


由Serge提到的HADR（高可用性灾难恢复）是一个日志

运费

数据库复制功能。此类产品通常部署为

提供

故障转移到不同的处理器和不同的磁盘。这可以在

a集群中使用

，带*独立*磁盘资源，这与通常的

配置不同

意味着有人提到基于群集的HA。更典型的是，日志传送
基于
的HA部署在独立（非集群）系统之间，



一个数据中心为本地 ;故障转移，或地理位置分离

（远程）

系统，以防止整个站点故障。


问候，

-steve p。

-------------------

Steve Pearson

DB2 UDB开发

Portland，OR，USA

Daniel G. Cantua <直流***** @ co.la.ca.us>在消息中写道

news：6c ************************** @ posting.google.c om ...

Cluster-based high availability tends to work by combining multi-ported disk
devices,
spare processing power, and a cluster manager (such as HACMP, MSCS, etc.).
When
a processor fails, the services that were running there (which could include
a DB2 "node"
aka processing "partition") are restarted in the spare processing facilities
(which may have
previously been idle, or may be already loaded processors that are set up to
absorb
additional workload in a failover). The disk resources associated with the
failed node
need to be accessible from the new node as well.

Disk (media) recovery is not usually part of this picture. Other approaches
are used
for that, including RAID/mirroring and database recovery (restore and
rollforward).

HADR (high availability disaster recovery), mentioned by Serge, is a log
shipping
database replication feature. Such products are typically deployed to
provide
failover to both different processors and different disks. This can be used
within
a cluster, with *separate* disk resources, which is different from the usual
configuration
meant when someone refers to cluster-based HA. More typically, log shipping
based HA is deployed between independent (not clustered) systems, either
within
one data center for "local" failover, or between geographically separated
("remote")
systems for protection against whole site failures.

Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"Daniel G. Cantua" <dc*****@co.la.ca.us> wrote in message
news:6c**************************@posting.google.c om...

我们正在考虑开始在DB2 V8中使用集群。我理解，当节点出现故障时，群集会使其他节点为用户保留数据库。我想知道的是，这包括节点是否有硬盘驱动器崩溃且
磁盘不可挽救或者只是机器连接断开？
如果新机器是用来代替损坏的那个如何同步？任何有关该主题的信息将不胜感激。

Daniel G. Cantua
洛杉矶县 - ISD

We are thinking of starting to use clustering with our DB2 V8. I
understand that with clustering when a node goes down that the other
nodes will keep the database up for the users. What I would like to
know is does this include if the node has a hard drive crash and the
disks are not salvagable or just if the machine looses connection?
And if a new machine is used to replace the damaged one how does it
sync together? Any information on the subject will be appreciated.

Daniel G. Cantua
Los Angeles County - ISD

Steve ，

如果我们在两台机器上使用HADR而另一台机器是物理的，或者b $ b损坏或关闭，用户是否能够继续工作，就好像

什么都没发生。或者他们是否必须对工作站进行某种类型的重新配置

。我们所拥有的是洛杉矶县的六个站点，

将需要连接到这个DB。我们是聚集的事情

照顾灾难发生。但听起来好像我们有两台使用HADR的机器将会互相镜像。可以

这也用于负载平衡。就像我说我是新来的。


谢谢你的帮助，

Daniel G. Cantua

洛杉矶县 - ISD

Steve,

If we use HADR on two machines and one the machines is physical
damaged or turned off, will the user be able to continue to work as if
nothing happen. Or will they have to do some type of reconfiguration
the the workstation. What we have are six sites in LA county that
will need to connect to this DB. We were thing that clustering will
take care of a disaster occurs. But it sounds like if we have two
machines using HADR that both machines will mirror each other. Can
this be used also for load balancing. Like I said I am new to this.

Thank You For Your Help,
Daniel G. Cantua
Los Angeles County - ISD

这篇关于DB2集群的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！