July 29, 2003 at 3:05 pm
Is that a mouthful! I'm looking for suggestions and experience. I have a two node active/active cluster On one node a Publisher with a vb app processing/loading around 100K entries a day. The other node is the handles the distributor feeding 3 seperate subscribers that our web front end retrieve from.
I need to have a hot standby server ready to take over the tasks of the 2 node cluster. And I'm looking at Transactional Replication and Log Shipping http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replbackup_3js7.asp%5B/url%5D as my solution. Specifically the Semi-Synchronous Mode, since I'm looking for lease amount of latency and can turn off the data feeds. As anyone out there tried implementing Transactional Replication with Log Shipping? Was it on a cluster (not that should matter). Any gottchas, bugs, quirks, or was it as smooth as silk.
John Zacharkan
John Zacharkan
August 1, 2003 at 8:00 am
This was removed by the editor as SPAM
August 2, 2003 at 9:49 am
Havent tried it. I'd have to experiment with the semi synch thing, could be dicey - depends I suppose on what the overall latency is and whether you can afford to lose any transactions. Latency typically pretty low for transactional, so you might not be talking about much data anyway. I think I'd try for synchronous first. Seems simpler to administer and if your cluster drops, you'll appreciate simple!
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply