question

Mandar Alawani avatar image
Mandar Alawani asked

replication architecture

Hi, I have couple of questions about replication, especially transaction replication. MSDN Says:- By design, transactional replication addresses the principal requirements for this scenario: • Transactional consistency • Low latency • High throughput • Minimal overhead I have a scenario with: Primary Server A, Secondary Server B, Network line between them currently 10MB I plan to use trans. replication to repl from A to B. As I want least data loss and max availability, can I : 1. Have publisher, distributor and subscriber on A. Also, can I replicate publisher, distributor and subscriber on B too which can be brought up in case of site A failure. I think, it is NOT POSSIBLE but would like some confirmation from someone else. 2. Another possibility is to have publisher, distributor and one subscriber on A and another subscriber on B. So, when Server A fails, application can connect to DBs on server B. Another question is, my approx. transaction size is about 50KB. is it possible to estimate(even roughly) how much bandwidth will be adequate to keep latency lowest? Thanks a lot!!!...any help is appreciated.
sql-server-2005replicationtransactionnetwork
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ecomma avatar image
ecomma answered
Having Only two Servers say A AND B.You can set up replication as follows. You can Configure server A as the Publisher and act as it own Distributor.Then configure Server B as the Subscriber. Steps are as follow. - First configure the Distributor on Server A. -Second, configure the Replication on Server A. -Third, configure the subscription. use this as a guide: http://msdn.microsoft.com/en-us/library/aa337437.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mandar Alawani avatar image Mandar Alawani commented ·
Thanks ecomma, I am aware the method to configure replication. My main question is it possible to have copies of Pub, Dist & Subs on another server which can be brought up immed in case of failure?? I have never heard of this, hence clarifying..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.