Abstract
Because of the huge scale and numerous components, a massive database system’s availability has become a serious challenge. Many database replication technologies are used to increase the MTTF, but few are provided to decrease MTTR in massive database systems where the traditional backup methods are not feasible for expensive human cost. Based on analyzing the characteristics of the data in massive databases, we propose a novel approach called Detaching Read-Only (DRO) mechanism and its variation DRO+. It decreases MTTR through reducing the size of physically changing data in every database by detaching data on node granularity. The analysis and experiment results show that our approach can not only reduce MTTR by an order of magnitude, but also reduce the expensive human cost without extra hardware cost.
Supported by the National High Technology Development 863 Program of China under Grant No.2004AA112020, and the National Grand Fundamental Research 973 Program of China under Grant No.2005CB321804.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Gray, J., Szalay, A.: Science in an exponential world. Nature 440, 23 (2006)
Gray, J., Shenoy, P.: Rules of Thumb in Data Engineering. In: ICDE 2000 (2000)
Becla, J., Wang, D.: Lessons Learned from Managing a Petabyte. In: CIDR 2005 (2005)
Gelman, B.: V2LDB. In: CIDR 2005 (2005)
Nagaraja, K., Li, X., Zhang, B., Bianchini, R., Martin, R., Nguyen, T.: Using Fault Injection and Modeling to Evaluate the Performability of Cluster-Based Services. In: Proceedings of the Usenix Symposium on Internet Technologies and Systems (March 2003)
Silberschatz, A., Korth, H.F., Sudarshan, S.: Database System Concepts, 4th edn., pp. 461–470. China Machine Press
Cecchet, E.: C-JDBC: a Middleware Framework for Database Clustering. IEEE Computer Society Technical Committee on Data Engineering (2004)
Breitbart, Y., Komondoor, R., Rastogi, R., Seshadri, S., Silberschatz, A.: Update Propagation Protocols For Replicated Databases. In: SIGMOD 1999 (1999)
Patterson, D.A., Brown, A., Broadwell, P., Candea, G., Chen, M., Cutler, J., Enriquez, P., Fox, A., Kiciman, E., Merzbacher, M., Oppenheimer, D., Sastry, N., Tetzlaff, W., Traupman, J., Treuhaft, N.: Recovery-Oriented Computing (ROC): Motivation, Definition, Techniques, and Case Studies. UC Berkeley Computer Science Technical Report UCB//CSD-02-1175, March 15 (2002)
Cai, Y.D., Aydt, R., Brunner, R.J.: Optimized Data Loading for a Multi-Terabyte Sky Survey Repository. In: Proc. Super Computing 2005 (2005)
Szalay, A., Kunszt, P., Thakar, A., Gray, J., Brunner, R.: Designing and Mining Multi-Terabyte Astronomy Archives: The Sloan Digital Sky Survey. In: Proc. SIGMOD 2000 (2000)
Wiesmann, M., Pedone, F., Schiper, A., Kemme, B., Alonso, G.: Transaction Replication Techniques: a Three Parameter Classification. In: SRDS 2000 (2000)
Abadi, D.J., Madden, S.R., Ferreira, M.C.: Integrating Compression and Execution in Column-Oriented Database Systems. In: Proceedings of SIGMOD 2006 (2006)
Hitt, E.F.: Total ownership cost use in management. In: Digital Avionics Systems Conference 1998 (1998)
Weikum, G., Moenkeberg, A., Hasse, C., Zabback, P.: Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering. In: VLDB 2002 (2002)
http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=105092601
Gray, J., Helland, P., O’Neil, P., Shasha, D.: The Dangers of Replication and a Solution. In: ACM SIGMOD 1996 (1996)
Sousa, A., Pereira, J., Soares, L., Correia Jr., A., Rocha, L., Oliveira, R., Moura, F.: Testing the Dependability and Performance of Group Communication Based Database Replication Protocols. In: Dependable Systems and Networks (DSN) (2005)
Building Highly Available Database Servers Using Oracle Real Application Clusters. An Oracle White Paper (May 2001)
Ghemawat, S., Gobioff, H., Leung, S.-T.: The Google File System. In: The ACM Symposium on Operating Systems Principles (SOSP) (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Du, K., Wang, H., Deng, B., Wang, Y., Yang, S. (2006). DRO+: A Systemic and Economical Approach to Improve Availability of Massive Database Systems. In: Feng, L., Wang, G., Zeng, C., Huang, R. (eds) Web Information Systems – WISE 2006 Workshops. WISE 2006. Lecture Notes in Computer Science, vol 4256. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11906070_12
Download citation
DOI: https://doi.org/10.1007/11906070_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-47663-4
Online ISBN: 978-3-540-47664-1
eBook Packages: Computer ScienceComputer Science (R0)