Point-in-Time Recovery (PITR) Configuration

Overview

MariaDB SkySQL supports point-in-time recovery (PITR) as an option:

  • This feature is not enabled by default. By default, full and complete backup restoration is available.

  • When enabled, additional steps are taken to preserve binary logs, enabling point-in-time recovery to be used at a later date. Customers are responsible for additional storage costs.

  • For Replicated Transactions service, when enabled, point-in-time recovery is available only to points after the last failover.

  • Point-in-time recovery configuration is available to Power Tier customers.

Compatibility

  • Distributed Transactions

  • Replicated Transactions

  • Single Node Transactions

Configure for Point-in-Time Recovery

Point-in-time recovery must be configured in advance of need to ensure the required data is available to support point-in-time recovery at a later date.

Contact SkySQL Support to for point-in-time recovery configuration.