Performance Measurement and Tuning of Hot-Standby Databases

  • Antoni Wolski
  • Vilho Raatikka
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4328)


General-purpose, high-availability database systems have lately proliferated to various network element platforms. In telecommunication, databases are expected to meet demanding availability levels while preserving the required throughput. However, so far, the effects of various high-availability configurations on overall database performance have not been analyzed. In this paper, the operation of a fully replicated, hot-standby database system is presented, together with some performance tuning possibilities. To study the effect of several database-tuning parameters, a telecom-oriented database benchmark, TM1, is used. The experiments involve varying of the read/write balance and various logging and replication parameters. It is shown that, by relaxing the reliability requirements, significant performance gains can be achieved. Also, it is demonstrated that a possibility to redirect the log writing from the local disk to the standby node is one of the most important benefits of a high-availability database system.


System Under Test Home Location Register Buffer Pool Replication Protocol Commit Transaction 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Application Interface Specification, SAI-AIS-B.02.02, Service Availability Forum (December 2005), available at:
  2. 2.
    Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency control and recovery in database systems. Addison-Wesley Publishing Company, Reading (1987)Google Scholar
  3. 3.
    Bitton, D., DeWitt, D.J., Turbyfill, C.: Benchmarking Database Systems A Systematic Approach. In: VLDB, pp. 8–19 (1983)Google Scholar
  4. 4.
    Gray, J. (ed.): The Benchmark Handbook for Database and Transaction Processing Systems. Morgan Kaufmann Publishers, San Francisco (1993)MATHGoogle Scholar
  5. 5.
    Gray, J., Reuter, A.: Transaction Processing Systems, Concepts and Techniques. Morgan Kaufmann Publishers, San Francisco (1992)Google Scholar
  6. 6.
    Brossier, S., Herrmann, F., Shokri, E.: On the Use of the SA Forum Checkpoint and AMF Services. In: Malek, M., Reitenspiess, M., Kaiser, J. (eds.) ISAS 2004. LNCS, vol. 3335, pp. 200–212. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  7. 7.
    Drake, S., Hu, W., McInnis, D.M., Sköld, M., Srivastava, A., Thalmann, L., Tikkanen, M., Torbjørnsen, Ø.: Architecture of Highly Available Databases. In: Malek, M., Reitenspiess, M., Kaiser, J. (eds.) ISAS 2004. LNCS, vol. 3335, pp. 1–16. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  8. 8.
    Solid High Availability User Guide, Version 4.5, Solid Information Technology (June 2005), available at:
  9. 9.
    Strandell, T.: Open Source Database Systems: Systems study, Performance and Scalability. Master’s Thesis, University of Helsinki, Department of Computer Science, p. 54 (May 2003),
  10. 10.
    Turbyfill, C., Orji, C.U., Bitton, D.: AS3AP - An ANSI SQL Standard Scaleable and Portable Benchmark for Relational Database Systems. In: [4]Google Scholar
  11. 11.
    Wolski, A., Hofhauser, B.: A Self-Managing High-Availability Database: Industrial Case Study. In: Proc. Workshop on Self-Managing Database Systems (SMDB 2005), Tokyo, Japan, April 8-9 (2005),

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Antoni Wolski
    • 1
  • Vilho Raatikka
    • 1
  1. 1.Solid Information TechnologyHelsinkiFinland

Personalised recommendations