OS Support for a Commodity Database on PC clusters - Distributed Devices vs. Distributed File Systems

In this paper we attempt to parallelise a commodity database for OLAP on a cluster of commodity PCs by using a distributed high-performance storage subsystem. By parallelising the underlying storage architecture we eliminate the need to make any changes to the database software. We look at two options that differ in their complexity and features: Distributed devices and distributed file systems. The former aggregates several single disks within the cluster into a RAID device across the network. The latter offers all the features of a real file system at the price of a considerably increased complexity. We configured a Linux version of ORACLE to run on various distributed devices or distributed file systems, respectively, and ran a TPC-D benchmark on our cluster of commodity PCs interconnected by a Gigabit Ethernet. While distributed devices achieve at least the performance of local disks, they offer the benefit of using all surplus storage in a cluster. The distributed file sy...

• Type: Conference
• Year: 2005
• Where: ADC
• Authors: Felix Rauch, Thomas Stricker
• Keywords: ADC 2005, Commodity Pcs, Database, Various Distributed Devices, file Systems