Skip to main content
SpringerLink
Log in
Book cover

International Service Availability Symposium

ISAS 2004: Service Availability pp 1–16Cite as

Architecture of Highly Available Databases

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3335))

Abstract

This paper describes the architectures that can be used to build highly available database management systems. We describe these architectures along two dimensions – process redundancy and data redundancy. Process redundancy refers to the management of redundant processes that can take over in case of a process or node failure. Data redundancy refers to the maintenance of multiple copies of the underlying data. We believe that the process and data redundancy models can be used to characterize most, if not all, highly available database management systems.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Application Interface Specification, SAI-AIS-A.01.01. Service Availability Forum (April 2003), available at www.saforum.org

  2. Gray, J., Reuter, A.: Transaction Processing Systems, Concepts and Techniques. Morgan Kaufmann Publishers, San Francisco (1992)

    Google Scholar 

  3. How MySQL Cluster Supports 99.999% Availability. MySQL Cluster white paper, MySQL AB (2004), available at http://www.mysql.com/cluster/

  4. Hu, K., Mehrotra, S., Kaplan, S.M.: Failure Handling in an Optimized Two-Safe Approach to Maintaining Primary-Backup Systems. In: Symposium on Reliable Distributed Systems 1998, pp. 161–167 (1998)

    Google Scholar 

  5. Humborstad, R., Sabaratnam, M., Hvasshovd, S.-O., Torbjørnsen, Ø.: 1-Safe Algorithms for Symmetric Site Configurations. In: VLDB 1997, pp. 316–325 (1997)

    Google Scholar 

  6. Hvasshovd, S., et al.: The ClustRa Telecom Database: High Availability, High Throughput and Real-time Response. In: VLDB 1995, pp. 469–477 (September 1995)

    Google Scholar 

  7. Kannan, S., et al.: Configuring Highly Available Clusters Using HACMP 4.5 (October 2002), available at http://www.ibm.com

  8. Norman, M.G., Zurek, T., Thanisch, P.: Much Ado About Shared-Nothing. SIGMOD Record 25(3), 16–21 (1996)

    Article  Google Scholar 

  9. Maximum Availability Architecture (MAA) Overview. Oracle Corporation (2003), available at http://otn.oracle.com/deploy/availability/htdocs/maa.htm

  10. Mohan, C., Treiber, K., Obermarck, R.: Algorithms for the Management of Remote Backup Data Bases for Disaster Recovery. In: ICDE 1993, pp. 511–518 (1993)

    Google Scholar 

  11. MySQL Reference Manual. MySQL AB (2004), available at http://www.mysql.com/documentation/

  12. Oracle Data Guard Overview. Oracle Corporation (2003), available at http://otn.oracle.com/deploy/availability/htdocs/DROverview.html

  13. Oracle Real Application Clusters (RAC) Overview, Oracle Corporation (2003), available at http://otn.oracle.com/products/database/clustering/

  14. Polyzois, C.A., Garcia-Molin, H.: Evaluation of Remote Backup Algorithms for Transaction-Processing Systems. ACM Trans. Database Syst. 19(3), 423–449 (1994)

    Article  Google Scholar 

  15. SAP Standard Applications Benchmarks, SD Parallel (June 2002), available at http://www.sap.com/benchmark/

  16. Solid High Availability User Guide, Version 4.1, Solid Information Technology (February 2004), available at http://www.solidtech.com

  17. Sun Cluster 3.1 10/03 Concepts Guide, Sun Microsystems, Part No. 817-0519-10 (October 2003)

    Google Scholar 

  18. Sun ONE Application Server 7 Enterprise Edition – Administrator’s Guide, Sun Microsystems, Part no. 817-1881-10 (September 2003)

    Google Scholar 

  19. Thalmann, L., Ronström, M.: High Availability features of MySQL Cluster. MySQL Cluster white paper, MySQL AB (2004), available at http://www.mysql.com/cluster/

  20. Transaction Processing Performance Council TPC-C Benchmarks (December 2003), available at http://www.tpc.org

  21. Wiesmann, M., Schiper, A.: Beyond 1-Safety and 2-Safety for Replicated Databases: Group-Safety. In: Bertino, E., Christodoulakis, S., Plexousakis, D., Christophides, V., Koubarakis, M., Böhm, K., Ferrari, E. (eds.) EDBT 2004. LNCS, vol. 2992, pp. 165–182. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. TimesTen, Inc, 800 W. El Camino Real, Mountain View, CA, 94040, USA

    Sam Drake

  2. Oracle Corporation, 400 Oracle Parkway, Redwood Shores, CA, 94065, USA

    Wei Hu & Alok Srivastava

  3. IBM Canada Ltd., 8200 Warden Ave. C4/487, Markham, ON, L6G 1C7, Canada

    Dale M. McInnis

  4. MySQL AB, Bangårdsgatan 8, S-753 20, Uppsala, Sweden

    Martin Sköld & Lars Thalmann

  5. Nokia Group, Nokia Corporation, P.O.Box 407, FIN-00045, Finland

    Matti Tikkanen

  6. Sun Microsystems, Haakon VII gt 7B, 7485, Trondheim, Norway

    Øystein Torbjørnsen

  7. Solid Information Technology, Merimiehenkatu 36D, FIN-00150, Helsinki, Finland

    Antoni Wolski

Authors
  1. Sam Drake
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Wei Hu
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Dale M. McInnis
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Martin Sköld
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Alok Srivastava
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Lars Thalmann
    View author publications

    You can also search for this author in PubMed Google Scholar

  7. Matti Tikkanen
    View author publications

    You can also search for this author in PubMed Google Scholar

  8. Øystein Torbjørnsen
    View author publications

    You can also search for this author in PubMed Google Scholar

  9. Antoni Wolski
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institut für Informatik, Humboldt-Universität zu, Berlin

    Miroslaw Malek

  2. Fujitsu Siemens Computers, Domagkstr. 28, P.O. Box, D-80807, Muenchen, Germany

    Manfred Reitenspieß

  3. Univ. Magdeburg,  

    Jörg Kaiser

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Drake, S. et al. (2005). Architecture of Highly Available Databases. In: Malek, M., Reitenspieß, M., Kaiser, J. (eds) Service Availability. ISAS 2004. Lecture Notes in Computer Science, vol 3335. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30225-4_1

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-30225-4_1

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-24420-2

  • Online ISBN: 978-3-540-30225-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation