HADR

  • 网络高可用性灾难恢复(High Availability Disaster Recovery);High Availability Disaster and Recovery;高可用性灾难回复

HADRHADR

HADR

高可用性灾难恢复(High Availability Disaster Recovery)

对于高可用性灾难恢复HADR)数据库,只支持 DDL 复制方式。 不修改复制的对象中的限定对象。

High Availability Disaster and Recovery

HADRHigh Availability Disaster and Recovery)是 DB2 Linux Unix and Windows 中高可用性和灾难恢复的解决方案。通过 …

高可用性灾难回复

支持高可用性灾难回复 (HADR)?(更多相关信息)否。

高可用性灾祸回复

高可用性灾祸回复 (HADR) 不支援对资料库日志档案使用原始 I/O (直接磁碟存取)。 7如果以 START HADR 命令启动 HADR, …

1
The easiest way to understand HADR is as a pair of servers that are kept in sync with each other at the database level. 理解HADR最容易的方法是设想两台服务器,它们在数据库级保持相互同步。
2
Hence, you will define your DB2 datasource in the same manner as if you were not using HADR. 所以,定义DB2数据源的方式与没有使用HADR时毫无二致。
3
If, in the event, the connectivity between the pair is lost you can set a timeout period for HADR to turn off. 如果这对系统之间的连接丢失,那么可以设置一个超时值,以便自动关闭HADR。
4
Only data changes are required to be replicated, so read transaction are unaffected by the implementation of HADR. 由于只需复制被更改的数据,所以读事务不受HADR实现的影响。
5
You could also mingle automatic client reroute technique with the HADR databases. 您还可以混合使用自动客户端重新路由技术与HADR数据库。
6
If any of these parameters are empty or misconfigured, DB2 HADR servers will not start properly. 如果这些参数中任何一个参数为空或者配置不正确,DB2HADR服务器都不会正常启动。
7
DB2 HADR also increases availability by allowing you to perform rolling upgrades. DB2HADR还允许执行滚动升级,从而增加了可用性。
8
To take advantage of HADR, you must have two dedicated servers available: one for the primary database and one for the standby database. 要想使用HADR,必须有两个专用的服务器:一个用于运行主数据库,一个用于备用数据库。
9
Once HADR is turned off, the primary can continue to process transactions normally. HADR关闭后,主系统可以继续正常地处理事务。
10
On the standby machine, first deactivate the database and then issue the start hadr command to start it as the standby database (Listing 7). 在备用计算机上,首先禁用数据库,然后发出starthadr命令,将其作为备用数据库启动(清单7)。
11
On the primary machine, first activate the database and then issue the start hadr command to start it as the primary database (Listing 8). 在主要计算机上,首先激活数据库,然后发出starthadr命令将其作为主要数据库启动(清单8)。
12
Assign appropriate values to the HADR configuration parameters for both the primary and the standby database. 给主和备用数据库的HADR配置参数设置适当的值。
13
The failover operation for HADR can be automated using HA software. HADR的故障转移操作可以通过HA软件实现自动化。
14
With HADR, a failover occurs and the standby database takes over, replacing the failed primary database in seconds. 如果使用HADR,在发生故障时,备用数据库会接管工作,在几秒内替代发生故障的主数据库。
15
Connect to the standby database and start HADR on the standby server by executing the START HADR command. 连接备用数据库,执行STARTHADR命令在备用服务器上启动HADR。
16
Connect to the primary database and start HADR on the primary server with the START HADR command. 连接主数据库,执行STARTHADR命令在主服务器上启动HADR。
17
The basic method by which HADR replicates data is to send DB2 log writes simultaneously to the local disk and to the standby system. HADR复制数据的基本方法是将DB2日志写同时发送到本地磁盘和备用系统。
18
If the primary and standby databases are not identical when HADR is started, an error will occur. 在启动HADR时,如果主和备用数据库不相同,就会发生错误。
19
A DB2 HADR scenario consists of two DB2 systems, a primary and a standby. 一个DB2HADR场景由两个DB2系统组成,一个是主系统,一个是备用系统。
20
Setup and administration of HADR is very simple and DB2 provides a wizard to help with these tasks. HADR的设置和管理非常简单,DB2提供向导帮助完成这些任务。
21
If there are two network interfaces on each host, a private network can be set up exclusively for HADR replication. 如果每个主机上有两个网络接口,可以设置专门的网络用于HADR复制。
22
If a server has multiple network interfaces, ensure that the HADR host name or IP address maps to the intended interface. 如果服务器有多个网络接口,那么一定要把HADR主机名或IP地址映射到适当的接口。
23
It is critical that all the HADR parameters be set with proper values prior to starting DB2 HADR on either the primary or standby machine. 在主要计算机或备用计算机上启动DB2HADR之前,正确设置所有HADR参数的值非常重要。
24
Only DDL copymode is supported for high availability disaster recovery (HADR) databases. 对于高可用性灾难恢复(HADR)数据库,只支持DDL复制方式。
25
Configure the HADR variables for each database on the primary machine. 为主要计算机上的每个数据库配置HADR变量。
26
Later, it is decided to switch the database to HADR-enabled DB2. 后来,决定将数据库切换到启用HADR的DB2。
27
Under the HADR status role, you will see "Standby" for the standby machine and "Primary" for the primary machine. 在HADR状态角色下,您将看到用于备用计算机的“Standby”状态和用于主要计算机的“Primary”状态。
28
In the event you want to perform some type of system maintenance task, upgrade, or DB2 fix installation, you can turn HADR off. 当需要执行某种类型的系统维护任务、升级或安装DB2修复包时,可以关闭HADR。
29
Once the databases are in peer mode, the DB2 HADR servers on the primary and standby machines are ready for use. 在数据库处于对等模式之后,主要计算机和备用计算机上的DB2HADR服务器就准备就绪可供使用了。
30
Figure 5 illustrates the HADR processes synchronizing a primary and standby system. 图5演示了同步主系统和备用系统的HADR过程。