AKARA: A flexible clustering protocol for demanding transactional workloads
Autor(a) principal: | |
---|---|
Data de Publicação: | 2008 |
Outros Autores: | , |
Idioma: | eng |
Título da fonte: | Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
Texto Completo: | http://hdl.handle.net/1822/37667 |
Resumo: | Shared-nothing clusters are a well known and cost-effective approach to database server scalability, in particular, with highly intensive read-only workloads typical of many 3-tier web-based applications. The common reliance on a centralized component and a simplistic propagation strategy employed by mainstream solutions however conduct to poor scalability with traditional on-line transaction processing (OLTP), where the update ratio is high. Such approaches also pose an additional obstacle to high availability while introducing a single point of failure. More recently, database replication protocols based on group communication have been shown to overcome such limitations, expanding the applicability of shared-nothing clusters to more demanding transactional workloads. These take simultaneous advantage of total order multicast and transactional semantics to improve on mainstream solutions. However, none has already been widely deployed in a general purpose database management system. In this paper, we argue that a major hurdle for their acceptance is that these proposals have disappointing performance with specific subsets of real-world workloads. Such limitations are deep-rooted and working around them requires in-depth understanding of protocols and changes to applications. We address this issue with a novel protocol that combines multiple transaction execution mechanisms and replication techniques and then show how it avoids the identified pitfalls. Experimental results are obtained with a workload based on the industry standard TPC-C benchmark. |
id |
RCAP_2f064979ec1b1baaaf9eb59ca019cc1a |
---|---|
oai_identifier_str |
oai:repositorium.sdum.uminho.pt:1822/37667 |
network_acronym_str |
RCAP |
network_name_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository_id_str |
7160 |
spelling |
AKARA: A flexible clustering protocol for demanding transactional workloadsSqlDatabasesCiências Naturais::Ciências da Computação e da InformaçãoScience & TechnologyShared-nothing clusters are a well known and cost-effective approach to database server scalability, in particular, with highly intensive read-only workloads typical of many 3-tier web-based applications. The common reliance on a centralized component and a simplistic propagation strategy employed by mainstream solutions however conduct to poor scalability with traditional on-line transaction processing (OLTP), where the update ratio is high. Such approaches also pose an additional obstacle to high availability while introducing a single point of failure. More recently, database replication protocols based on group communication have been shown to overcome such limitations, expanding the applicability of shared-nothing clusters to more demanding transactional workloads. These take simultaneous advantage of total order multicast and transactional semantics to improve on mainstream solutions. However, none has already been widely deployed in a general purpose database management system. In this paper, we argue that a major hurdle for their acceptance is that these proposals have disappointing performance with specific subsets of real-world workloads. Such limitations are deep-rooted and working around them requires in-depth understanding of protocols and changes to applications. We address this issue with a novel protocol that combines multiple transaction execution mechanisms and replication techniques and then show how it avoids the identified pitfalls. Experimental results are obtained with a workload based on the industry standard TPC-C benchmark.Springer VerlagSpringer VerlagUniversidade do MinhoCorreia, AlfrânioPereira, JoséOliveira, Rui Carlos Mendes de20082008-01-01T00:00:00Zconference paperinfo:eu-repo/semantics/publishedVersionapplication/pdfhttp://hdl.handle.net/1822/37667engCorreia A, Pereira JO, Oliveira R. 2008. AKARA: A Flexible Clustering Protocol for Demanding Transactional Workloads. OTM International Symposium on Distributed Objects, Middleware, and Applications - DOA. 5331:{691-708}978-3-540-88870-30302-974310.1007/978-3-540-88871-0_48http://link.springer.com/chapter/10.1007%2F978-3-540-88871-0_4info:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2024-05-11T05:28:49Zoai:repositorium.sdum.uminho.pt:1822/37667Portal AgregadorONGhttps://www.rcaap.pt/oai/openairemluisa.alvim@gmail.comopendoar:71602024-05-11T05:28:49Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse |
dc.title.none.fl_str_mv |
AKARA: A flexible clustering protocol for demanding transactional workloads |
title |
AKARA: A flexible clustering protocol for demanding transactional workloads |
spellingShingle |
AKARA: A flexible clustering protocol for demanding transactional workloads Correia, Alfrânio Sql Databases Ciências Naturais::Ciências da Computação e da Informação Science & Technology |
title_short |
AKARA: A flexible clustering protocol for demanding transactional workloads |
title_full |
AKARA: A flexible clustering protocol for demanding transactional workloads |
title_fullStr |
AKARA: A flexible clustering protocol for demanding transactional workloads |
title_full_unstemmed |
AKARA: A flexible clustering protocol for demanding transactional workloads |
title_sort |
AKARA: A flexible clustering protocol for demanding transactional workloads |
author |
Correia, Alfrânio |
author_facet |
Correia, Alfrânio Pereira, José Oliveira, Rui Carlos Mendes de |
author_role |
author |
author2 |
Pereira, José Oliveira, Rui Carlos Mendes de |
author2_role |
author author |
dc.contributor.none.fl_str_mv |
Universidade do Minho |
dc.contributor.author.fl_str_mv |
Correia, Alfrânio Pereira, José Oliveira, Rui Carlos Mendes de |
dc.subject.por.fl_str_mv |
Sql Databases Ciências Naturais::Ciências da Computação e da Informação Science & Technology |
topic |
Sql Databases Ciências Naturais::Ciências da Computação e da Informação Science & Technology |
description |
Shared-nothing clusters are a well known and cost-effective approach to database server scalability, in particular, with highly intensive read-only workloads typical of many 3-tier web-based applications. The common reliance on a centralized component and a simplistic propagation strategy employed by mainstream solutions however conduct to poor scalability with traditional on-line transaction processing (OLTP), where the update ratio is high. Such approaches also pose an additional obstacle to high availability while introducing a single point of failure. More recently, database replication protocols based on group communication have been shown to overcome such limitations, expanding the applicability of shared-nothing clusters to more demanding transactional workloads. These take simultaneous advantage of total order multicast and transactional semantics to improve on mainstream solutions. However, none has already been widely deployed in a general purpose database management system. In this paper, we argue that a major hurdle for their acceptance is that these proposals have disappointing performance with specific subsets of real-world workloads. Such limitations are deep-rooted and working around them requires in-depth understanding of protocols and changes to applications. We address this issue with a novel protocol that combines multiple transaction execution mechanisms and replication techniques and then show how it avoids the identified pitfalls. Experimental results are obtained with a workload based on the industry standard TPC-C benchmark. |
publishDate |
2008 |
dc.date.none.fl_str_mv |
2008 2008-01-01T00:00:00Z |
dc.type.driver.fl_str_mv |
conference paper |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://hdl.handle.net/1822/37667 |
url |
http://hdl.handle.net/1822/37667 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
Correia A, Pereira JO, Oliveira R. 2008. AKARA: A Flexible Clustering Protocol for Demanding Transactional Workloads. OTM International Symposium on Distributed Objects, Middleware, and Applications - DOA. 5331:{691-708} 978-3-540-88870-3 0302-9743 10.1007/978-3-540-88871-0_48 http://link.springer.com/chapter/10.1007%2F978-3-540-88871-0_4 |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
Springer Verlag Springer Verlag |
publisher.none.fl_str_mv |
Springer Verlag Springer Verlag |
dc.source.none.fl_str_mv |
reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação instacron:RCAAP |
instname_str |
Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
instacron_str |
RCAAP |
institution |
RCAAP |
reponame_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
collection |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository.name.fl_str_mv |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
repository.mail.fl_str_mv |
mluisa.alvim@gmail.com |
_version_ |
1817544634939736064 |