Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[MySQL] Enable PITR

Description

As an Everest user

I want to be able to enable Point in time recovery for my MySQL database cluster

So that the data after the last full backup would be stored in the external storage. 

https://www.figma.com/file/g77gIX02jKysAzHzsDA9KW/Beta-Release?type=design&node-id=884%3A43415&mode=dev

100% Done
Type
Key
Summary
Priority
Story Points
Assignee
Status

Activity

Show:

Manish Chawla January 10, 2024 at 9:09 AM

PITR is now working for mysql. There are some PITR issues for which separate Jira issues have been filed, hence closing this task.

Oksana Grishchenko November 20, 2023 at 1:59 PM

According by PXC docs

  1. recommended to use a separate bucket/directory for PITR.

  2. PITR is only working when both backups and pitr are stored in an s3 compatible storage

Since pxc allows prefixes for the buckets only by using "{bucket}/prefix" instead of "{bucket}", the 1. limitation could be resolved by defining a separate storage for pitr on the pxc cluster level, so the the pxc cluster would contain an additional storage to be used only by the pitr functionality. 

Oksana Grishchenko November 8, 2023 at 2:12 PM

The dbaas-operator PR https://github.com/percona/dbaas-operator/pull/62 to reference to.

Done

Details

Assignee

Reporter

Sprint

Fix versions

Priority

Parent

Smart Checklist

Created October 6, 2023 at 3:15 PM
Updated March 14, 2024 at 4:59 PM
Resolved January 10, 2024 at 9:09 AM

Flag notifications