Performance Measurement and Tuning of Hot-Standby Databases
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.
KeywordsSystem Under Test Home Location Register Buffer Pool Replication Protocol Commit Transaction
Unable to display preview. Download preview PDF.
- 1.Application Interface Specification, SAI-AIS-B.02.02, Service Availability Forum (December 2005), available at: http://www.saforum.org
- 2.Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency control and recovery in database systems. Addison-Wesley Publishing Company, Reading (1987)Google Scholar
- 3.Bitton, D., DeWitt, D.J., Turbyfill, C.: Benchmarking Database Systems A Systematic Approach. In: VLDB, pp. 8–19 (1983)Google Scholar
- 5.Gray, J., Reuter, A.: Transaction Processing Systems, Concepts and Techniques. Morgan Kaufmann Publishers, San Francisco (1992)Google Scholar
- 8.Solid High Availability User Guide, Version 4.5, Solid Information Technology (June 2005), available at: http://www.solidtech.com
- 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), http://www.cs.helsinki.fi/u/tpstrand/thesis/
- 10.Turbyfill, C., Orji, C.U., Bitton, D.: AS3AP - An ANSI SQL Standard Scaleable and Portable Benchmark for Relational Database Systems. In: Google Scholar
- 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), http://research.solidtech.com/publ/wolhof-smdb05-ha-case.pdf