Optimistic transactional active replication

Hiroshi Horii, Hayato Yamana

    Research output: Chapter in Book/Report/Conference proceedingConference contribution

    Abstract

    Critical database applications require 2-safe replication between at least two sites for disaster-tolerant services. At the same time, they must provide consistent and low-latency results to their clients in normal cases. In this paper, we propose Optimistic Transactional Active Replication (OTAR), which replicates the transaction logs with low latency and provides a consistent view to database applications. The latency of our replication is lower than Passive Replication, and guarantees the serializability of transaction isolation levels that cannot be supported by Active Replication. For our replication, each client sends a transaction request to all replicas and all of the replicas execute the request and optimistically return the result of the transaction to the client. Each replica generates a causality history of the transaction, sent to the client with the result. With the causality histories, the client can make sure that the requested transaction was executed in the same order at all of the replicas and eventually commit it. If the client cannot validate the order, then the client waits for the pessimistic result of the transaction from the replicas. This paper describes the algorithm and its properties.

    Original languageEnglish
    Title of host publicationProceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008
    Pages94-100
    Number of pages7
    DOIs
    Publication statusPublished - 2008
    Event2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008 - Suwon
    Duration: 2008 Jan 312008 Feb 1

    Other

    Other2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008
    CitySuwon
    Period08/1/3108/2/1

    Fingerprint

    Disasters

    Keywords

    • disaster tolerant
    • replication
    • transaction

    ASJC Scopus subject areas

    • Computer Science Applications

    Cite this

    Horii, H., & Yamana, H. (2008). Optimistic transactional active replication. In Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008 (pp. 94-100) https://doi.org/10.1145/1352793.1352813

    Optimistic transactional active replication. / Horii, Hiroshi; Yamana, Hayato.

    Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008. 2008. p. 94-100.

    Research output: Chapter in Book/Report/Conference proceedingConference contribution

    Horii, H & Yamana, H 2008, Optimistic transactional active replication. in Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008. pp. 94-100, 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008, Suwon, 08/1/31. https://doi.org/10.1145/1352793.1352813
    Horii H, Yamana H. Optimistic transactional active replication. In Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008. 2008. p. 94-100 https://doi.org/10.1145/1352793.1352813
    Horii, Hiroshi ; Yamana, Hayato. / Optimistic transactional active replication. Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008. 2008. pp. 94-100
    @inproceedings{a744116851ff4841a65ea184034f4d25,
    title = "Optimistic transactional active replication",
    abstract = "Critical database applications require 2-safe replication between at least two sites for disaster-tolerant services. At the same time, they must provide consistent and low-latency results to their clients in normal cases. In this paper, we propose Optimistic Transactional Active Replication (OTAR), which replicates the transaction logs with low latency and provides a consistent view to database applications. The latency of our replication is lower than Passive Replication, and guarantees the serializability of transaction isolation levels that cannot be supported by Active Replication. For our replication, each client sends a transaction request to all replicas and all of the replicas execute the request and optimistically return the result of the transaction to the client. Each replica generates a causality history of the transaction, sent to the client with the result. With the causality histories, the client can make sure that the requested transaction was executed in the same order at all of the replicas and eventually commit it. If the client cannot validate the order, then the client waits for the pessimistic result of the transaction from the replicas. This paper describes the algorithm and its properties.",
    keywords = "disaster tolerant, replication, transaction",
    author = "Hiroshi Horii and Hayato Yamana",
    year = "2008",
    doi = "10.1145/1352793.1352813",
    language = "English",
    isbn = "9781595939937",
    pages = "94--100",
    booktitle = "Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008",

    }

    TY - GEN

    T1 - Optimistic transactional active replication

    AU - Horii, Hiroshi

    AU - Yamana, Hayato

    PY - 2008

    Y1 - 2008

    N2 - Critical database applications require 2-safe replication between at least two sites for disaster-tolerant services. At the same time, they must provide consistent and low-latency results to their clients in normal cases. In this paper, we propose Optimistic Transactional Active Replication (OTAR), which replicates the transaction logs with low latency and provides a consistent view to database applications. The latency of our replication is lower than Passive Replication, and guarantees the serializability of transaction isolation levels that cannot be supported by Active Replication. For our replication, each client sends a transaction request to all replicas and all of the replicas execute the request and optimistically return the result of the transaction to the client. Each replica generates a causality history of the transaction, sent to the client with the result. With the causality histories, the client can make sure that the requested transaction was executed in the same order at all of the replicas and eventually commit it. If the client cannot validate the order, then the client waits for the pessimistic result of the transaction from the replicas. This paper describes the algorithm and its properties.

    AB - Critical database applications require 2-safe replication between at least two sites for disaster-tolerant services. At the same time, they must provide consistent and low-latency results to their clients in normal cases. In this paper, we propose Optimistic Transactional Active Replication (OTAR), which replicates the transaction logs with low latency and provides a consistent view to database applications. The latency of our replication is lower than Passive Replication, and guarantees the serializability of transaction isolation levels that cannot be supported by Active Replication. For our replication, each client sends a transaction request to all replicas and all of the replicas execute the request and optimistically return the result of the transaction to the client. Each replica generates a causality history of the transaction, sent to the client with the result. With the causality histories, the client can make sure that the requested transaction was executed in the same order at all of the replicas and eventually commit it. If the client cannot validate the order, then the client waits for the pessimistic result of the transaction from the replicas. This paper describes the algorithm and its properties.

    KW - disaster tolerant

    KW - replication

    KW - transaction

    UR - http://www.scopus.com/inward/record.url?scp=79959347200&partnerID=8YFLogxK

    UR - http://www.scopus.com/inward/citedby.url?scp=79959347200&partnerID=8YFLogxK

    U2 - 10.1145/1352793.1352813

    DO - 10.1145/1352793.1352813

    M3 - Conference contribution

    SN - 9781595939937

    SP - 94

    EP - 100

    BT - Proceedings of the 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC-2008

    ER -