Asee peer logo

Performance Testing And Analysis Of Redundant Arrays Of Inexpensive Databases

Download Paper |

Conference

2004 Annual Conference

Location

Salt Lake City, Utah

Publication Date

June 20, 2004

Start Date

June 20, 2004

End Date

June 23, 2004

ISSN

2153-5965

Conference Session

Undergraduate Research & New Directions

Page Count

9

Page Numbers

9.986.1 - 9.986.9

Permanent URL

https://peer.asee.org/14107

Download Count

16

Request a correction

Paper Authors

author page

Brandon Rogers

author page

Joseph Ekstrom

Download Paper |

Abstract
NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

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. https://peer.asee.org/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