Partial replication: Achieving scalability in redundant arrays of inexpensive databases Export

@article{cecchet:raidb, abstract = {Clusters of workstations become more and more popular to power data server applications such as large scale Web sites or e-Commerce applications. There has been much research on scaling the front tiers (web servers and application servers) using clusters, but databases usually remain on large dedicated SMP machines. In this paper, we focus on the database tier using clusters of commodity hardware. Our approach consists of studying different replication strategies to achieve various degree of performance and fault tolerance. Redundant Array of Inexpensive Databases (RAIDb) is to databases what RAID is to disks. In this paper, we focus on RAIDb-1 that offers full replication and RAIDb-2 that introduces partial replication, in which the user can define the degree of replication of each database table. We present a Java implementation of RAIDb called Clustered JDBC or C-JDBC. C-JDBC achieves both database performance scalability and high availability at the middleware level without changing existing applications. We show, using the TPC-W benchmark, that partial replication (RAIDb-2) can offer better performance scalability (up to 25\%) than full replication by allowing fine-grain control on replication. Distributing and restricting the replication of frequently written tables to a small set of backends reduces I/O usage and improves CPU utilization of each cluster node.}, author = {Cecchet, Emmanuel and Marguerite, Julie and Zwaenepoel, Willy}, booktitle = {7th International Conference on Principles of Distributed Systems (OPODIS 2003); December 10-13, 2003; MARTINIQUE}, citeulike-article-id = {3154230}, citeulike-linkout-0 = {http://springerlink.metapress.com/link.asp?id=kay13m7clgg75utk}, editor = {Papatrianatafilou}, journal = {Lecture Notes in Computer Science}, keywords = {database, pario-bib, raidb, replication, strategies}, month = {July}, pages = {58--70}, posted-at = {2008-08-25 23:21:23}, priority = {2}, publisher = {Springer-Verlag Heidelberg}, title = {Partial replication: Achieving scalability in redundant arrays of inexpensive databases}, url = {http://springerlink.metapress.com/link.asp?id=kay13m7clgg75utk}, volume = {3144}, year = {2004} }

TY - JOUR ID - cecchet:raidb L3 - citeulike-article-id:3154230 N2 - Clusters of workstations become more and more popular to power data server applications such as large scale Web sites or e-Commerce applications. There has been much research on scaling the front tiers (web servers and application servers) using clusters, but databases usually remain on large dedicated SMP machines. In this paper, we focus on the database tier using clusters of commodity hardware. Our approach consists of studying different replication strategies to achieve various degree of performance and fault tolerance. Redundant Array of Inexpensive Databases (RAIDb) is to databases what RAID is to disks. In this paper, we focus on RAIDb-1 that offers full replication and RAIDb-2 that introduces partial replication, in which the user can define the degree of replication of each database table. We present a Java implementation of RAIDb called Clustered JDBC or C-JDBC. C-JDBC achieves both database performance scalability and high availability at the middleware level without changing existing applications. We show, using the TPC-W benchmark, that partial replication (RAIDb-2) can offer better performance scalability (up to 25%) than full replication by allowing fine-grain control on replication. Distributing and restricting the replication of frequently written tables to a small set of backends reduces I/O usage and improves CPU utilization of each cluster node. JF - Lecture Notes in Computer Science EP - 70 TI - Partial replication: Achieving scalability in redundant arrays of inexpensive databases PB - Springer-Verlag Heidelberg VL - 3144 T2 - 7th International Conference on Principles of Distributed Systems (OPODIS 2003); December 10-13, 2003; MARTINIQUE SP - 58 KW - database KW - pario-bib KW - raidb KW - replication KW - strategies AU - Cecchet, Emmanuel AU - Marguerite, Julie AU - Zwaenepoel, Willy A2 - Papatrianatafilou PY - 2004/July// UR - http://springerlink.metapress.com/link.asp?id=kay13m7clgg75utk ER -