Done
Details
Assignee
dmitriy.kostiukdmitriy.kostiuk(Deactivated)Reporter
sherrysherryComponents
Fix versions
Priority
Critical
Details
Details
Assignee
dmitriy.kostiuk
dmitriy.kostiuk(Deactivated)Reporter
sherry
sherryComponents
Fix versions
Priority

Smart Checklist
Smart Checklist
Smart Checklist
Created October 2, 2021 at 9:17 AM
Updated March 5, 2024 at 5:44 PM
Resolved October 20, 2021 at 6:20 PM
PITR Document link
https://www.percona.com/doc/kubernetes-operator-for-pxc/backups.html#storing-binary-logs-for-point-in-time-recovery
Issue 1:
`type`
key can be equal to one of the following options, *date
- roll back to specific date, *transaction
- roll back to specific transaction, *latest
- recover to the latest possible transactioncomment:
There's one more type supported since 1.7.0, * skip - skip a specific transaction https://github.com/percona/percona-xtradb-cluster-operator/blob/v1.7.0/cmd/pitr/recoverer/recoverer.go#L192
type *
transaction is added start from 1.8.0
Issue 2:
{{}}
`gtidSet`
key is used withtype=transaction
option - it contains exact GTID or GTIDSet (the restore will not include the transaction with specified GTID, but the one before it)Comment:
`gtidSet` key is only for 1.7.0, as of 1.8.0, `gtid` is used instead, it contains an exact GTID (the restore will not include the transaction with specified GTID, but the one before it)
https://github.com/percona/percona-xtradb-cluster-operator/blob/v1.7.0/cmd/pitr/recoverer/recoverer.go#L41
https://github.com/percona/percona-xtradb-cluster-operator/blob/v1.8.0/cmd/pitr/recoverer/recoverer.go#L45