DBTrail
Settings

Retention

How long changes stay in the live index, how often rotation runs, and where old hours go.

Every hour by default: export old hours to Parquet, upload to S3, delete the local copy only after the upload worked, drop the hours from the index. A failed upload keeps the hours in the index. WordPress binlog 30 MB a day becomes 1.5 MB of Parquet, about 20 to 1.

Rotation dialog

Console → Settings → Rotation. Applies on the next cycle, no restart; one schedule for every index the daemon rotates.

The Rotation dialog: retention, interval and future partitions, with changes taking effect on the next run.
SettingMeaning
RetentionHow long events stay in the live index
IntervalHow often rotation runs. Default: every hour
Future partitionsEmpty hourly partitions created ahead of time

Archive destination

Per server: Archive to S3 in the server form (Servers).

  • Set: expired hours become Parquet in that bucket and stay queryable; the console finds them on its own.
  • Not set: expired hours are dropped.
  • Upload keeps failing: hours are not dropped and rotation reports unhealthy (Alerts). The index grows; nothing is lost.

Not AWS: S3-compatible storage. Compression: zstd default, snappy and gzip supported (measured). Archived Parquet follows your bucket's lifecycle rules, not retention.

Headless

bintrail rotate --index-dsn "$IDX" --retain 7d --archive-dir /data/archives --archive-compression zstd

Rotation & status reference.

On this page