BackupSchedule: support automatic backup log truncate when only maxBackups is supplied

[kennytm]

Feature Request

Is your feature request related to a problem? Please describe:

In a BackupSchedule CR, if logBackupTemplate is setup, it will run log backup. According to the docs, the streaming logs will be truncated only according to maxReservedTime.

Expiry of snapshot backup can be configured with either maxBackups or maxReservedTime. Because the schedule may be irregular, it is not always possible to use maxReservedTime to reproduce the effect of maxBackups.

(internal - see GTOC-7367 for details)

Describe the feature you'd like:

When some snapshots are deleted by maxBackups, additionally use that oldest snapshot's CommitTS has the TruncateTSO and perform br log truncate.

Describe alternatives you've considered:
Keep the status quo? 🤔

Teachability, Documentation, Adoption, Migration Strategy:

In the BackupSchedule CR documentation, change this sentence:

- The log backup is created and deleted along with `backupSchedule` and recycled according to `.spec.maxReservedTime`.
+ The log backup is created and deleted along with `backupSchedule` and recycled according to `.spec.maxReservedTime` or `.spec.maxBackups`.