Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
Benchmark Handbook: For Database and Transaction Processing Systems
Benchmark Handbook: For Database and Transaction Processing Systems
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
Benchmarking Database Systems A Systematic Approach
VLDB '83 Proceedings of the 9th International Conference on Very Large Data Bases
A Self-Managing High-Availability Database: Industrial Case Study
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
Architecture of highly available databases
ISAS'04 Proceedings of the First international conference on Service Availability
On the use of the SA forum checkpoint and AMF services
ISAS'04 Proceedings of the First international conference on Service Availability
Hi-index | 0.00 |
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.