Fault Diversity among Off-The-Shelf SQL Database Servers

  • Authors:
  • Ilir Gashi;Peter Popov;Lorenzo Strigini

  • Affiliations:
  • City University, London;City University, London;City University, London

  • Venue:
  • DSN '04 Proceedings of the 2004 International Conference on Dependable Systems and Networks
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

Fault tolerance is often the only viable way of obtainingthe required system dependability from systems built outof "off-the-shelf" (OTS) products. We have studied asample of bug reports from four off-the-shelf SQL serversso as to estimate the possible advantages of software faulttolerance - in the form of modular redundancy withdiversity - in complex off-the-shelf software. We checkedwhether these bugs would cause coincident failures inmore than one of the servers. We found that very few bugsaffected two of the four servers, and none caused failuresin more than two. We also found that only four of thesebugs would cause identical, undetectable failures in twoservers. Therefore, a fault-tolerant server, built withdiverse off-the-shelf servers, seems to have a good chanceof delivering improvements in availability and failurerates compared with the individual off-the-shelf servers ortheir replicated, non-diverse configurations.