I'm specifically targeting the single point of failure
But when it comes down to it, there is always a single point of origin. Your SQL replication scheme only works if the master copy is available and participating, for example.
and slow time to recover. Servers in a single datacenter are a single point of failure if there is a site wide problem, however multiple servers in geographically dispersed locations are some insurance against that.
But the SQL replicated scheme has exactly the same vulnerability. I agree that it seems like an extraordinarily long downtime for such a major outage of both HostGator and BlueHost (which may be the same company for all we know).
Cloudfare may (not that I have noticed) improve responsiveness for static pages but a forum DB is not static pages.
Yes, that does seem odd. CloudFlare appears to have simply rolled over and played dead instead of serving up old content. Perhaps that is a user-configurable behavior?
I strongly suspect these problems are the result of some technician walking around with two fingers up his nose. Or a screwdriver.
Its hard to find good help. But then it seemed to take an extraordinarily long time to recover. I was very surprised that a "Multi-Server Outage" took the better part of a day to fix a network hardware problem.