locked
Building an eCommerce infrastructure? RRS feed

  • Question

  •   I'm building a eCommerce infrastructure and want to design it in the most cost effective way but with no application point of failure in terms of database design is mirroring using merge replication the best way to go?

    Wednesday, March 28, 2012 1:29 PM

Answers

  • Its entirely depend upon your business requirement but here are some suggestions -For SQL 2008 and 2005

    Mirroring would be best choice for active and passive(DR) datacenters, Merge replication for active and active datacenters.

    Please aware merge replication would required separate license for both servers ( Main and DR data servers), and it create triggers on tables to keep track of data changes.

    Mirroring requried single licence when passive server having same or less number of CPUs with main db servers and should not be serve users acively more than 30 days, maintenance would be bit easy than replications

    hope this helps you

    http://uk.linkedin.com/in/ramjaddu

    • Marked as answer by Stephanie Lv Thursday, April 5, 2012 9:35 AM
    Wednesday, March 28, 2012 3:01 PM