SQLJocky (2/6/2013)

---

Thanks for the response. Yes, the company has a DR site already setup with VMWare infrastructure and are planning for everything. We just need to determine what the best production environment would look like first. Something highly scalable.

Looks like we're going to do a two phased approach now. We're going to build out for approximately 1000+ stores now and then scale up to the 5000+ in the next few years. So I'm seriously thinking that the right approach is to do a multi-node "partitioned writes" environment and use peer-to-peer replication so that as we need to add more nodes, we can do so with ease (in a manner of speaking). In this case we would have the application layer partition the stores to write against one server and read from another and replicate between them. Then I might have a third server that I can database mirror to just for offloading the reporting process.