The secondary node can either be an HDR or RS secondary type.
该辅助节点可以是hdr或rs辅助类型。
The example below shows that customer table in stores_demo at RS secondary server is not available and that transaction has been applied.
下面的例子显示RS次要服务器上stores_demo中的customer表不可用,而且该事务已经被应用。
SDS or HDR secondary node can take over primary, and RS secondary server continues to receive logical logs from new primary server.
SDS或HDR次要节点可以接管主要服务器,而RS次要服务器继续从新的主要服务器接收逻辑日志。
This feature was only available for the CS and RS isolation levels.
该特性只能用于CS和RS隔离级别。
Below steps clearly describe performing external backup on RS secondary.
以下步骤明确说明了如何在RS次要服务器上执行外部备份。
The next example shows the RS secondary server online log when DELAY_APPLY is set.
下一个例子显示了设置DELAY_APPLY时的RS次要服务器在线日志。
During external backup, logical logs coming from primary are staged at RS secondary server.
在执行外部备份期间,来自主要服务器的逻辑日志暂存于RS次要服务器上。
We also explained how an external backup can be taken on an RS secondary server.
我们还说明了如何在RS次要服务器上制作外部备份。
When the server is unblocked, staged logical log files from primary server at RS secondary server are automatically removed after being applied.
解除服务器的阻塞时,将在应用RS次要服务器上来自主要服务器的已暂存逻辑日志文件之后自动删除它。
Let's add an RS node to our cluster.
现在向集群添加一个RS节点。
The primary purpose of the RS secondary server is to provide a disaster recovery solution.
RS备用服务器的主要作用是提供灾难修复解决方案。
The primary server is not blocked or affected by the external backup performed on RS secondary nodes.
RS次要节点上执行的外部备份不会阻塞或影响主要服务器。
This leaves the CS and RS isolation levels — which are the most widely used when only committed data is required for processing.
这样就剩下CS和RS这两种隔离级别——当处理只需要提交的数据时,这两个级别是使用最广泛的。
How is restoring external backup done on the RS secondary server?
在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.
一旦将检查点传输给rss节点,它会开始将来自主要服务器的日志记录暂存到RS次要服务器上的日志暂存区域中。
Figure 1 shows the primary, HDR, and RS secondary nodes and illustrates the steps of an external backup on RSS.
图1显示了主要节点、hdr与rs次要节点,并举例说明了在rss上进行外部备份的步骤。
Now query the stores_demo database and look for customer table at RS secondary server after 5 minutes of commit time.
现在查询stores_demo数据库,并在提交时间过去5分钟后在RS次要服务器上查找customer表。