可以恢复备份以创建一台主要服务器。
在主要服务器上执行事务。
这项功能的作用与主要服务器的备份类似。
这项功能允许DBA降低主要服务器上的负载。
This feature allows the DBA to reduce the load on the primary server.
此参数表示次要节点上保存来自主要服务器的日志的目录。
It is the directory in which logs are staged at the secondary node that are coming from primary server.
如何避免阻塞hdr环境中主要服务器上的检查点?
How to avoid blocking checkpoints on primary in an HDR environment?
RS次要节点上执行的外部备份不会阻塞或影响主要服务器。
The primary server is not blocked or affected by the external backup performed on RS secondary nodes.
当发出该命令时,将等待来自主要服务器的检查点请求。
When this command is issued, it waits for checkpoint request from primary.
主要服务器将不会知道逻辑日志暂存在RS次要服务器上。
The primary server will not know that logical logs are staged at RS secondary server.
这样做的主要目的是帮助DBA降低主要服务器上的负载。
This primary helps the DBA reduce the load on the primary server.
RS次要服务器继续从主要服务器接收逻辑日志,但不会应用它们。
The RS secondary server continues to receive logical logs from the primary but does not apply them.
在这里,来自主要服务器的日志4与日志5都暂存在RS次要服务器上。
Here, log 4 and log 5 that are coming from primary server are staged at RS secondary server.
最后,我们对HDR环境中主要服务器上阻塞的检查点进行了详细说明。
We concluded with a detailed explanation on blocking checkpoints on primary in an HDR environment.
关键是根据应用程序体系结构确定并专注于应用程序所使用的主要服务器组件和资源。
The key is to identify and focus in on the major server components and resources used by your application, based on the application architecture.
在执行外部备份期间,来自主要服务器的逻辑日志暂存于RS次要服务器上。
During external backup, logical logs coming from primary are staged at RS secondary server.
对主要服务器的任何更新会立即复制到辅助服务器,以维护一个活动数据副本。
Any update made on this primary server is immediately replicated to the secondary server so as to maintain a copy of the active data.
当主要服务器脱机时(计划内或计划外停机),备用服务器将联机代替其工作。
When the primary server goes offline for (planned or unplanned) downtime, the standby server is available to be brought online.
如果主要服务器失效,而日志暂存于HDR次要服务器上,会出现什么情况?
What happens when primary fails while logs are staged at HDR secondary?
HD r次要服务器上有暂存的日志,如果处于排出模式下,则会关闭主要服务器。
HDR secondary has logs staged, and primary server went down while in drain mode.
当RS次要服务器阻塞之后,来自主要服务器的逻辑日志暂存于RS次要服务器上。
After the RS secondary server is blocked, the logical logs coming from the primary server are staged at the RS secondary server.
在这种模式中,次要服务器从暂存文件中读取数据,并从主要服务器直接接收新数据。
In this mode, the secondary reads data from the staging file and receives new data from the primary directly.
下图展示了主要服务器与HDR次要节点,以及日志暂存在检查点期间的工作步骤。
The below diagram represents primary and HDR secondary nodes, and steps of working log staging during checkpoint.
在主-主配置中,没有主要服务器,对任何服务器所做的修改都会传播到其他主服务器。
In the master-master configuration, there is no primary server and the changes made to any of the server get propagated to the other masters.
现在我们将了解,在设置DB 2HADR主要服务器和备用服务器时都涉及哪些内容。
Let's look at what is involved in setting up the DB2 HADR primary and standby servers.
一旦应用暂存的逻辑日志,只要从主要服务器接收到日志记录,就可以立即恢复应用日志记录。
Once the staged logical log records are applied, it continues to resume applying the log records as soon as they are received from the primary.
解除服务器的阻塞时,将在应用RS次要服务器上来自主要服务器的已暂存逻辑日志文件之后自动删除它。
When the server is unblocked, staged logical log files from primary server at RS secondary server are automatically removed after being applied.
在正在执行外部备份操作期间,如果主要服务器失效而日志被暂存在RS次要服务器上,会出现什么情况?
What happens when the primary server fails while logs are staged at RS secondary during external backup operation is in progress?
SDS或HDR次要节点可以接管主要服务器,而RS 次要服务器继续从新的主要服务器接收逻辑日志。
SDS or HDR secondary node can take over primary, and RS secondary server continues to receive logical logs from new primary server.
一旦将检查点传输给rss节点,它会开始将来自主要服务器的日志记录暂存到RS次要服务器上的日志暂存区域中。
Once a checkpoint is transferred to the RSS node, it will start staging the log records coming from the primary in a log staging area at RS secondary server.
主要服务器将使用暂存目录中的文件,并在实际应用或暂存将保存到主要服务器的日志数据缓存之前,应立即识别对它的接收。
Primary in to files in the staging directory. It immediately acknowledges receipt of the log data buffer to the primary before it actually applies or stages it.
应用推荐