Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Application Interface Specification, SAI-AIS-B.02.02, Service Availability Forum (December 2005), available at: http://www.saforum.org
Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency control and recovery in database systems. Addison-Wesley Publishing Company, Reading (1987)
Bitton, D., DeWitt, D.J., Turbyfill, C.: Benchmarking Database Systems A Systematic Approach. In: VLDB, pp. 8–19 (1983)
Gray, J. (ed.): The Benchmark Handbook for Database and Transaction Processing Systems. Morgan Kaufmann Publishers, San Francisco (1993)
Gray, J., Reuter, A.: Transaction Processing Systems, Concepts and Techniques. Morgan Kaufmann Publishers, San Francisco (1992)
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)
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)
Solid High Availability User Guide, Version 4.5, Solid Information Technology (June 2005), available at: http://www.solidtech.com
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), http://www.cs.helsinki.fi/u/tpstrand/thesis/
Turbyfill, C., Orji, C.U., Bitton, D.: AS3AP - An ANSI SQL Standard Scaleable and Portable Benchmark for Relational Database Systems. In: [4]
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), http://research.solidtech.com/publ/wolhof-smdb05-ha-case.pdf
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
Wolski, A., Raatikka, V. (2006). Performance Measurement and Tuning of Hot-Standby Databases. In: Penkler, D., Reitenspiess, M., Tam, F. (eds) Service Availability. ISAS 2006. Lecture Notes in Computer Science, vol 4328. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11955498_11
Download citation
DOI: https://doi.org/10.1007/11955498_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-68724-5
Online ISBN: 978-3-540-68725-2
eBook Packages: Computer ScienceComputer Science (R0)