Implementing Performance Competitive Logical Recovery

TL;DR

This paper extends ARIES-style recovery techniques to logical recovery in modern hardware platforms, demonstrating that logical redo can achieve performance comparable to traditional methods through specific optimizations.

Contribution

It introduces a method to adapt ARIES recovery optimizations for logical recovery, enabling performance competitiveness in new hardware architectures.

Findings

Logical recovery can be optimized to match ARIES performance.

Performance experiments show logical redo is competitive with traditional methods.

The approach supports flexible database system architectures on modern hardware.

Abstract

New hardware platforms, e.g. cloud, multi-core, etc., have led to a reconsideration of database system architecture. Our Deuteronomy project separates transactional functionality from data management functionality, enabling a flexible response to exploiting new platforms. This separation requires, however, that recovery is described logically. In this paper, we extend current recovery methods to work in this logical setting. While this is straightforward in principle, performance is an issue. We show how ARIES style recovery optimizations can work for logical recovery where page information is not captured on the log. In side-by-side performance experiments using a common log, we compare logical recovery with a state-of-the art ARIES style recovery implementation and show that logical redo performance can be competitive.