We recently had a major data center outage from our hosting provider. They lost a fibre connection, causing a 9 hours outage, where most of our customers could not connect.
This has caused us to consider housing our website across 2 independent datacenters.
The website is an asp.net website with Sql 2008 database. I've read a few articles around round-robin IP, anycast IP, etc.
This is new terrority for me, so am fairly lost where to start.
I have a some questions:
- How can we host the database in 2 data centers and still keep them in sync
- Would 1 data center have to act as the primary?
- I'd like all users to go to datacenter1 but in the case that 1 is unavailable I'd like traffic to move to data center 2. How can this be acheived?
These are just some questions to start off. If someone could give me an overview on how to tackle this or point me to some resource that will help, will be very greatly appreciated.