loading...
Approaches to Balancing Data Load of Shared-Nothing Clusters and Their Performance Comparison
Taiwan, ROC December 17-December 20
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICPADS.2002.1183414Ninth International Conference on Par ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Jiahong Wang, Iwate Prefectural University
Yuuhei Tsutaya, Iwate Prefectural University
Norihisa Segawa, Iwate Prefectural University
Shinji Yamane, Iwate Prefectural University
Yuko Murayama, Iwate Prefectural University
Masatoshi Miyazaki, Iwate Prefectural University
Hironobu Suzuki, Independent Software Consultant
Using a cluster of PCs or workstations or the likes (called nodes) to implement the database server can bring us two great benefits: high scalability and parallel processing capability. Before such a database server can be put into actual use, however, two problems have to be solved. The one is how we cope with the data-skew since it can degrade the system performance significantly. The other is how a node is connected to or disconnected from a database server without affecting the users. One general solution to both problems is to redistribute the data. Unfortunately, this would take the data off line for a long time. In fact, numerous applications such as that for reservations, finance, process control, hospitals, police, and armed forces cannot afford the off-line data for any significant amount of time. In this paper we address the subject of balancing data load on line, i.e., balancing data load concurrently with users? reading and writing of the database. Main contributions are an effective approach for this purpose and a comprehensive performance study of the possible alternatives.
Citation:
Jiahong Wang, Yuuhei Tsutaya, Norihisa Segawa, Shinji Yamane, Yuko Murayama, Masatoshi Miyazaki, Hironobu Suzuki, "Approaches to Balancing Data Load of Shared-Nothing Clusters and Their Performance Comparison," icpads, pp.293, Ninth International Conference on Parallel and Distributed Systems (ICPADS'02), 2002
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions