The Community for Technology Leaders
RSS Icon
Subscribe
Long Beach, CA, USA
Mar. 1, 2010 to Mar. 6, 2010
ISBN: 978-1-4244-5445-7
pp: 509-520
Sriram Subramanian , Department of Computer Science, University of Wisconsin, Madison, USA
Yupu Zhang , Department of Computer Science, University of Wisconsin, Madison, USA
Rajiv Vaidyanathan , Department of Computer Science, University of Wisconsin, Madison, USA
Haryadi S. Gunawi , Department of Computer Science, University of Wisconsin, Madison, USA
Andrea C. Arpaci-Dusseau , Department of Computer Science, University of Wisconsin, Madison, USA
Remzi H. Arpaci-Dusseau , Department of Computer Science, University of Wisconsin, Madison, USA
Jeffrey F. Naughton , Department of Computer Science, University of Wisconsin, Madison, USA
ABSTRACT
Despite the best intentions of disk and RAID manufacturers, on-disk data can still become corrupted. In this paper, we examine the effects of corruption on database management systems. Through injecting faults into the MySQL DBMS, we find that in certain cases, corruption can greatly harm the system, leading to untimely crashes, data loss, or even incorrect results. Overall, of 145 injected faults, 110 lead to serious problems. More detailed observations point us to three deficiencies: MySQL does not have the capability to detect some corruptions due to lack of redundant information, does not isolate corrupted data from valid data, and has inconsistent reactions to similar corruption scenarios. To detect and repair corruption, a DBMS is typically equipped with an offline checker. Unfortunately, the MySQL offline checker is not comprehensive in the checks it performs, misdiagnosing many corruption scenarios and missing others. Sometimes the checker itself crashes; more ominously, its incorrect checking can lead to incorrect repairs. Overall, we find that the checker does not behave correctly in 18 of 145 injected corruptions, and thus can leave the DBMS vulnerable to the problems described above.
CITATION
Sriram Subramanian, Yupu Zhang, Rajiv Vaidyanathan, Haryadi S. Gunawi, Andrea C. Arpaci-Dusseau, Remzi H. Arpaci-Dusseau, Jeffrey F. Naughton, "Impact of disk corruption on open-source DBMS", ICDE, 2010, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2010, pp. 509-520, doi:10.1109/ICDE.2010.5447821
24 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool