liveBook · Manning

HA/DR architecture

As explained in 100 SQL Server Mistakes and How to Avoid Them

An HA/DR architecture is a system design combining high-availability and disaster-recovery capabilities to maintain service and recover from failures.

Mistake 1: treating “it can’t be down” as a design specification. Accepting an application owner’s statement without translating it into measurable availability requirements can produce an unnecessarily expensive HA/DR topology. section 13.2

When five nines means six seconds

A five-nines requirement means 99.999% availability, allowing only 6 seconds of downtime per week. A simple network blip could consume that entire allowance, while the associated HA/DR solution may cost more than the downtime itself. section 13.2

Use this decision sequence:

  • Translate business expectations into a percentage of availability and acceptable downtime. section 13.2
  • Build the topology that satisfies the justified requirement rather than assuming every application needs maximum availability. section 13.2

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Defines availability percentages and quantifies downtime and cost, but does not specify implementation procedures or topology designs.
Examples
Uses four-nines and five-nines availability, downtime tables, and comparative downtime-versus-solution costs.
What you can do after
Evaluate availability requirements and justify an HA/DR topology against downtime allowances and costs.
How it connects
Connects high availability and disaster recovery with availability requirements, downtime, cost, and HA/DR topology.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.