Point-in-Time Recovery Capabilities: Standard vs Enterprise Editions

{question}

Difference in Continuous Backup Between Standard vs Enterprise Edition on Helios

{question}

{answer}

Standard Edition

• Supports restoration once per day at 00:00 UTC within the retention window.

• The default retention period is 7 days, and it cannot be extended beyond 7 days.

• You can recover by branching the database to 00:00 UTC of a chosen day within the retention period.

Example Scenario:
If a bad update was executed on January 2, 2025, you can branch the database to 00:00 UTC on January 2 and recover the data prior to the change.

Behavior:

• You specify only the date.

• The system automatically sets the timestamp to 00:00:00 UTC.

• The timestamp cannot be customized.

ATTACH DATABASE DB_X AS recover_DB_X AT TIME '2025-01-02';

Enterprise Edition

• Supports point-in-time recovery with 1-second granularity within the retention window.

• Default retention is 7 days, minimum is 1 day.

• Retention can be extended up to 90 days or longer.

• Restoration timestamps must be in UTC.

• Self-service restoration is supported (same as Standard).

Example Command:

ATTACH DATABASE DB_X AS recover_DB_X AT TIME '2025-01-02 21:57:31';

Important Notes

• Increasing the retention period increases storage usage and cost because data must be retained for the entire duration.

• Even if records or tables are deleted, data remains recoverable until the retention period expires, contributing to storage consumption.

• Although the minimum retention can be configured to 1 day, SingleStore recommends at least 3 days.
  Shorter retention windows significantly reduce the available reaction time to identify and correct issues.

Long-Term Retention

If you need to retain data beyond the continuous backup retention window, use the BACKUP DATABASE command to back up data to your own object storage.

{answer}