分配器- 含义- 在单独的数据库服务器实例上配置?
根据以下 Distributor 的定义:
分发服务器是一种数据库实例,充当与一个或多个发布服务器关联的复制特定数据的存储。每个发布者都与分发者处的单个数据库(称为分发数据库)相关联。分发数据库存储复制状态数据、有关发布的元数据,并且在某些情况下充当从发布服务器移动到订阅服务器的数据的队列。在许多情况下,单个数据库服务器实例同时充当发布者和分发者。这被称为本地经销商。当发布服务器和分发服务器配置在不同的数据库服务器实例上时,分发服务器称为远程分发服务器。
我希望理解以下短语:
在单独的数据库服务器实例上配置
这是否意味着在不同计算机上运行的服务器上?或者在一台计算机上,一台 SQL Server,具有不同的实例名称?
From the following definition of a Distributor:
The Distributor is a database instance that acts as a store for replication specific data associated with one or more Publishers. Each Publisher is associated with a single database (known as a distribution database) at the Distributor. The distribution database stores replication status data, metadata about the publication, and, in some cases, acts as a queue for data moving from the Publisher to the Subscribers. In many cases, a single database server instance acts as both the Publisher and the Distributor. This is known as a local Distributor. When the Publisher and the Distributor are configured on separate database server instances, the Distributor is known as a remote Distributor.
I am looking to understand the following phrase:
configured on separate database server instances
Does this mean on servers running on different computers? Or on one computer, one sql server, with different instance names?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
“在单独的数据库服务器实例上配置”是指在两个独立的 SQL 服务器实例上;它们是否安装在同一台物理计算机上
,例如publisher =
server\instance11
、distributor =server\instance2
,还是安装在两台不同的计算机上
,例如publisher =
server1\instance< /code> ,distributor =
server2\instance
远程分发是指发布者和分发者不是同一个 SQL Server 实例的情况。
"configured on separate database server instances" means on two independent SQL server instances; whether they are installed on the same physical machine
e.g. publisher =
server\instance11
, distributor =server\instance2
or on two distinct machines
e.g. publisher =
server1\instance
, distributor =server2\instance
Remote Distribution is any case where the publisher and the distributor are not the same SQL server instance.