skip to main content
10.1145/1363686.1364205acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

Conflict-aware load-balancing techniques for database replication

Published: 16 March 2008 Publication History

Abstract

Middleware-based database replication protocols are more portable and flexible than kernel-based protocols, but have coarser-grain information about transaction access data, resulting in reduced concurrency and increased aborts. This paper proposes conflict-aware load-balancing techniques to increase the concurrency and reduce the abort rate of middleware-based replication protocols. Experimental evaluation using a prototype of our system running the TPC-C benchmark showed that aborts can be reduced with no penalty in response time.

References

[1]
C. Amza, A. Cox, and W. Zwaenepoel. Conflict-Aware Scheduling for Dynamic Content Applications. In Proceedings of USITS, March 2003.
[2]
C. Amza, A. L. Cox, and W. Zwaenepoel. A comparative evaluation of transparent scaling techniques for dynamic content servers. In Proceedings of IEEE ICDE, pages 230--241, April 2005.
[3]
P. Bernstein, V. Hadzilacos, and N. Goodman. Concurrency Control and Recovery in Database Systems. Addison-Wesley, 1987.
[4]
E. Cecchet, J. Marguerite, and W. Zwaenepoel. C-JDBC: Flexible database clustering middleware. In Proceedings of ATEC, Freenix track, pages 9--18, June 2004.
[5]
A. Correia, A. Sousa, L. Soares, J. Pereira, F. Moura, and R. Oliveira. Group-based replication of on-line transaction processing servers. In LADC, pages 245--260, October 2005.
[6]
S. Elnikety, S. Dropsho, and W. Zwaenepoel. Tashkent+: Memory-aware load balancing and update filtering in replicated databases. In Proceedings of EuroSys, pages 399--412, March 2007.
[7]
Y. Lin, B. Kemme, M. Patiño-Martínez, and R. Jiménez-Peris. Middleware based data replication providing snapshot isolation. In Proceedings of ACM SIGMOD, pages 419--430, June 2005.
[8]
J. M. Milán-Franco, R. Jiménez-Peris, M. Patiño-Martínez, and B. Kemme. Adaptive middleware for data replication. In Proceedings of Middleware, pages 175--194, October 2004.
[9]
F. D. Muñoz-Escoí, J. Pla-Civera, M. I. Ruiz-Fuertes, L. Irún-Briz, H. Decker, J. E. Armendáriz-Iñigo, and J. R. G. de Mendívil. Managing transaction conflicts in middleware-based database replication architectures. In Proceedings of IEEE SRDS, 2006.
[10]
M. Patiño-Martínez, R. Jiménez-Peris, B. Kemme, and G. Alonso. Consistent Database Replication at the Middleware Level. ACM Transactions on Computer Systems, 23(4):375--423, 2005.
[11]
F. Pedone, R. Guerraoui, and A. Schiper. The database state machine approach. Journal of Distributed and Parallel Databases and Technology, 14:71--98, 2003.
[12]
C. Plattner and G. Alonso. Ganymed: scalable replication for transactional web applications. In Proceedings of Middleware, pages 155--174, October 2004.
[13]
L. Rodrigues, H. Miranda, R. Almeida, J. Martins, and P. Vicente. The GlobData fault-tolerant replicated distributed object database. In Proceedings of EurAsia-ICT, pages 426--433, October 2002.
[14]
F. B. Schneider. Implementing fault-tolerant services using the state machine approach: A tutorial. ACM Computing Surveys, 22(4):299--319, 1990.
[15]
Transaction Proccesing Performance Council (TPC). TPC benchmark C. Standard Specification, 2005.

Cited By

View all
  • (2022)Database ReplicationundefinedOnline publication date: 24-Feb-2022
  • (2016)T-PartProceedings of the 2016 International Conference on Management of Data10.1145/2882903.2915227(1553-1565)Online publication date: 26-Jun-2016
  • (2014)Speculative client execution in deferred update replicationProceedings of the 9th Workshop on Middleware for Next Generation Internet Computing10.1145/2676733.2676738(1-6)Online publication date: 8-Dec-2014
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SAC '08: Proceedings of the 2008 ACM symposium on Applied computing
March 2008
2586 pages
ISBN:9781595937537
DOI:10.1145/1363686
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 March 2008

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. load balancing
  2. replication
  3. transactions scheduling

Qualifiers

  • Research-article

Conference

SAC '08
Sponsor:
SAC '08: The 2008 ACM Symposium on Applied Computing
March 16 - 20, 2008
Fortaleza, Ceara, Brazil

Acceptance Rates

Overall Acceptance Rate 1,650 of 6,669 submissions, 25%

Upcoming Conference

SAC '25
The 40th ACM/SIGAPP Symposium on Applied Computing
March 31 - April 4, 2025
Catania , Italy

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)4
  • Downloads (Last 6 weeks)1
Reflects downloads up to 12 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2022)Database ReplicationundefinedOnline publication date: 24-Feb-2022
  • (2016)T-PartProceedings of the 2016 International Conference on Management of Data10.1145/2882903.2915227(1553-1565)Online publication date: 26-Jun-2016
  • (2014)Speculative client execution in deferred update replicationProceedings of the 9th Workshop on Middleware for Next Generation Internet Computing10.1145/2676733.2676738(1-6)Online publication date: 8-Dec-2014
  • (2010)Database replicationReplication10.5555/2172338.2172350(219-252)Online publication date: 1-Jan-2010
  • (2010)TransPeerProceedings of the 2010 ACM Symposium on Applied Computing10.1145/1774088.1774179(423-430)Online publication date: 22-Mar-2010
  • (2010)Database Replication: A TutorialReplication10.1007/978-3-642-11294-2_12(219-252)Online publication date: 2010
  • (2009)Correctness proof of a database replication protocol under the perspective of the I/O automaton modelActa Informatica10.1007/s00236-009-0097-446:4(297-330)Online publication date: 19-Jun-2009

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media