Salt Lake City, Utah
June 20, 2004
June 20, 2004
June 23, 2004
2153-5965
9
9.986.1 - 9.986.9
10.18260/1-2--14107
https://peer.asee.org/14107
467
Performance Testing and Analysis of Redundant Arrays of Inexpensive Databases
Brandon Rogers, Joseph J. Ekstrom
Brigham Young University
Abstract
The Internet revolution has focused scaling and redundancy research on systems, such as application servers using clusters, redundant Internet connections, and other redundant hardware. Conversely, back-end services, such as databases, have largely remained undistributed, un- clustered, and housed in large, dedicated SMP machines. However, a new turn in database management recently was introduced with the proposal of a RAIDb (Redundant Array of Inexpensive Databases) standard.
Various studies have indicated that redundant disk arrays and computer node clustering have greatly improved machine performance per dollar spent. Clustering provides immense processing capability and redundancy has proved to be a valuable resource in up time and availability. Based on these notions, RAIDb utilizes increased processing power through database computer clustering, while providing increased availability through the use of redundant databases and database controllers.
This paper details the performance of the C-JDBC (Clustered JDBC), a Java-based implementation of RAIDb. Performance is measured using a variable-node RAIDb cluster against a standard database backend. Each database backend is flooded with SQL requests by a benchmark client, which keeps track of the number of requests per minute successfully served by the database engine. Results of the testing are compiled and interpreted, showing performance trends and comparisons of the database implementations.
Introduction
In 2003, Brigham Young University’s School of Technology began building a laboratory for hardware and software testing and performance analysis. The lab contains 20 workstation computers, a few high-speed machines and switches, and one Itanium 64-bit computer. The purpose of this lab is to provide students and faculty with a means to perform research that can be used to characterize the performance of a system. This experimental environment is ideal for creating and performing benchmarking tests to scientifically describe the performance of these systems. This is one of two studies completed and used to christen this new lab.
Proceedings of the 2004 American Society for Engineering Education Annual Conference & Exposition Copyright © 2004, American Society for Engineering Education
Rogers, B., & Ekstrom, J. (2004, June), Performance Testing And Analysis Of Redundant Arrays Of Inexpensive Databases Paper presented at 2004 Annual Conference, Salt Lake City, Utah. 10.18260/1-2--14107
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2004 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015