Transactional Replication multiple Distributors

Question

Transactional Replication multiple Distributors

Casper101

Hall of Fame

Points: 3903
More actions
November 20, 2018 at 1:24 am

#378644

My current setup is as follows:
Server A = Publisher
Server B = Subscriber and Distributor (Push subscription)
I need to now also replication to Server C.
I know it is possible for 1 Publisher to have multiple Subscribers.
My question is: Can Server C also act as its own Distributor?
If not, what would the setup be? I would prefer, if possible, to not make the Publisher the Distributor, I would want it to be only a Publisher.
And I would like to keep the original setup of (Server A = Publisher, Server B = Subscriber and Distributor)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

Casper101 - Tuesday, November 20, 2018 1:24 AM
My current setup is as follows:
Server A = Publisher
Server B = Subscriber and Distributor (Push subscription)
I need to now also replication to Server C.
I know it is possible for 1 Publisher to have multiple Subscribers.
My question is: Can Server C also act as its own Distributor?
If not, what would the setup be? I would prefer, if possible, to not make the Publisher the Distributor, I would want it to be only a Publisher.
And I would like to keep the original setup of (Server A = Publisher, Server B = Subscriber and Distributor)

The publisher can't have multiple distributors. You can add another subscriber being Server C using the current distributor.

Sue

frederico_fonseca SSCoach Points: 16154 More actions · Answer 2

just to make it clearer
Publisher
------> Distributor
---------------> subscriber 1
---------------> subscriber 2
---------------> ....
---------------> subscriber N

the above can be any server - they could even be all on the same server. Or all on independent servers

trangxeco Newbie Points: 8 More actions · Answer 3

[TrÃch dáº«n]

Sue_H - Thá»© Ba, ngÃ y 20 thÃ¡ng 11, 2018 10:15 sÃ¡ng

Casper101 - Thá»© Ba, ngÃ y 20 thÃ¡ng 11 nÄƒm 2018 1:24 sÃ¡ng
Thiáº¿t láºp hiá»‡n táº¡i cá»§a tÃ´i nhÆ° sau:
MÃ¡y chá»§ A = NhÃ xuáº¥t báº£n
MÃ¡y chá»§ B = NgÆ°á»i Ä‘Äƒng kÃ½ vÃ NhÃ phÃ¢n phá»‘i (ÄÄƒng kÃ½ Ä‘áº©y)
TÃ´i cáº§n pháº£i sao chÃ©p sang MÃ¡y chá»§ C.
TÃ´i biáº¿t cÃ³ thá»ƒ cÃ³ 1 NhÃ xuáº¥t báº£n cÃ³ nhiá»u NgÆ°á»i Ä‘Äƒng kÃ½.
CÃ¢u há»i cá»§a tÃ´i lÃ : MÃ¡y chá»§ C cÃ³ thá»ƒ Ä‘Ã³ng vai trÃ² lÃ NhÃ phÃ¢n phá»‘i riÃªng cá»§a mÃ¬nh khÃ´ng?
Náº¿u khÃ´ng, thiáº¿t láºp sáº½ lÃ gÃ¬? TÃ´i muá»‘n, náº¿u cÃ³ thá»ƒ, Ä‘á»ƒ khÃ´ng lÃ m cho NhÃ xuáº¥t báº£n trá»Ÿ thÃ nh NhÃ phÃ¢n phá»‘i, tÃ´i muá»‘n nÃ³ chá»‰ lÃ má»™t NhÃ xuáº¥t báº£n.
VÃ tÃ´i muá»‘n giá»¯ nguyÃªn thiáº¿t láºp ban Ä‘áº§u cá»§a (MÃ¡y chá»§ A = NhÃ xuáº¥t báº£n, MÃ¡y chá»§ B = NgÆ°á»i Ä‘Äƒng kÃ½ vÃ NhÃ phÃ¢n phá»‘i)

NhÃ xuáº¥t báº£n khÃ´ng thá»ƒ cÃ³ nhiá»u nhÃ phÃ¢n phá»‘i. Báº¡n cÃ³ thá»ƒ thÃªm má»™t thuÃª bao khÃ¡c lÃ Server C báº±ng cÃ¡ch sá» dá»¥ng nhÃ phÃ¢n phá»‘i hiá»‡n táº¡i.

Sue

[/quote]

MÃ¬nh nghÄ© má»™t nhÃ xuáº¥t báº£n cÃ³ nhiá»u nhÃ phÃ¢n phá»‘i Ä‘Æ°á»£c chá»© nhá»‰?

Casper101 Hall of Fame Points: 3903 More actions · Answer 4

Thank you for your input.
Having 1 Distributor server, is it then advised to have multiple distribution databases? For the multiple Subscribers?
Something like:
Server A = Publisher
Server B = Subscriber 1 and Distributor using distribution DB1
Server C = Subscriber 2 using distribution DB2 (on Server B)
Or should/can Server C just use the original distribution DB that was created?

Sue_H SSC Guru Points: 90860 More actions · Answer 5

trangxeco - Tuesday, November 20, 2018 8:58 PM
[TrÃch dáº«n]
Sue_H - Thá»© Ba, ngÃ y 20 thÃ¡ng 11, 2018 10:15 sÃ¡ng
Casper101 - Thá»© Ba, ngÃ y 20 thÃ¡ng 11 nÄƒm 2018 1:24 sÃ¡ng
Thiáº¿t láºp hiá»‡n táº¡i cá»§a tÃ´i nhÆ° sau:
MÃ¡y chá»§ A = NhÃ xuáº¥t báº£n
MÃ¡y chá»§ B = NgÆ°á»i Ä‘Äƒng kÃ½ vÃ NhÃ phÃ¢n phá»‘i (ÄÄƒng kÃ½ Ä‘áº©y)
TÃ´i cáº§n pháº£i sao chÃ©p sang MÃ¡y chá»§ C.
TÃ´i biáº¿t cÃ³ thá»ƒ cÃ³ 1 NhÃ xuáº¥t báº£n cÃ³ nhiá»u NgÆ°á»i Ä‘Äƒng kÃ½.
CÃ¢u há»i cá»§a tÃ´i lÃ : MÃ¡y chá»§ C cÃ³ thá»ƒ Ä‘Ã³ng vai trÃ² lÃ NhÃ phÃ¢n phá»‘i riÃªng cá»§a mÃ¬nh khÃ´ng?
Náº¿u khÃ´ng, thiáº¿t láºp sáº½ lÃ gÃ¬? TÃ´i muá»‘n, náº¿u cÃ³ thá»ƒ, Ä‘á»ƒ khÃ´ng lÃ m cho NhÃ xuáº¥t báº£n trá»Ÿ thÃ nh NhÃ phÃ¢n phá»‘i, tÃ´i muá»‘n nÃ³ chá»‰ lÃ má»™t NhÃ xuáº¥t báº£n.
VÃ tÃ´i muá»‘n giá»¯ nguyÃªn thiáº¿t láºp ban Ä‘áº§u cá»§a (MÃ¡y chá»§ A = NhÃ xuáº¥t báº£n, MÃ¡y chá»§ B = NgÆ°á»i Ä‘Äƒng kÃ½ vÃ NhÃ phÃ¢n phá»‘i)
NhÃ xuáº¥t báº£n khÃ´ng thá»ƒ cÃ³ nhiá»u nhÃ phÃ¢n phá»‘i. Báº¡n cÃ³ thá»ƒ thÃªm má»™t thuÃª bao khÃ¡c lÃ Server C báº±ng cÃ¡ch sá» dá»¥ng nhÃ phÃ¢n phá»‘i hiá»‡n táº¡i.
Sue

[/quote]
Giá»‘ng nhÆ° tráº¡ng thÃ¡i tÃ i liá»‡u: Má»—i NhÃ xuáº¥t báº£n cÃ³ thá»ƒ Ä‘Æ°á»£c chá»‰ Ä‘á»‹nh cho má»™t cÃ¡ thá»ƒ NhÃ phÃ¢n phá»‘i duy nháº¥t, nhÆ°ng nhiá»u nhÃ xuáº¥t báº£n cÃ³ thá»ƒ chia sáº» NhÃ phÃ¢n phá»‘i.

Sue

Sue_H SSC Guru Points: 90860 More actions · Answer 6

Casper101 - Wednesday, November 21, 2018 1:40 AM
Thank you for your input.
Having 1 Distributor server, is it then advised to have multiple distribution databases? For the multiple Subscribers?
Something like:
Server A = Publisher
Server B = Subscriber 1 and Distributor using distribution DB1
Server C = Subscriber 2 using distribution DB2 (on Server B)
Or should/can Server C just use the original distribution DB that was created?

You can't configure one publication to use multiple distribution databases.
Having a couple (or more) of subscribers for one publication using one distribution database is very common.
Multiple publishers can use the same distributor and that's more likely when you can see impacts from loads and you consider a distribution database for each publisher and/or using a dedicated distribution server.

Sue