Skip to:

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

Issues

Select view

Select search mode

 
4 of 4

In which version does xtrabackup start to support PUNCH HOLE of mysql5.7?

Not a Bug

Description

Masters, may anyone tell me
From which version does xtrabackup support mysql5.7 page compression(Hole Punch)

  • I checked a lot of xtrabackup release notes and percona official documents, but didn't find any description of page compression support

  • I also checked a lot of bugs, but didn't find any clear description of whether xtrabackup supports page compression




    https://jira.mariadb.org/browse/MDEV-13023

  • I used version 2.4.29 to do local backup tests and remote backup tests. The test results showed that Hole Punch is not supported. Is there something wrong with my test or does xtrabackup itself not support it?

Could tell me clearly whether xtrabackup 2.4.x supports page compression of mysql 5.7? (Hole Punch)

Looking forward to your reply
Thank you very much

Environment

None

Details

Assignee

Reporter

Needs QA

Yes

Needs Doc

Yes

Components

Affects versions

Priority

Smart Checklist

Created September 7, 2024 at 1:01 AM
Updated September 8, 2024 at 1:21 AM
Resolved September 7, 2024 at 3:46 PM

Activity

Show:

j mSeptember 8, 2024 at 1:21 AM

Master,thank you very much for the reply

Aaditya DubeySeptember 7, 2024 at 3:46 PM

Hi

Thank you for the report.
It is a known limitation for 2.4.X, which is mentioned here at

Added support here at

Please note that 2.4 is EOL, so we recommend using 8.0. If you still need EOL support, please contact us here.

j mSeptember 7, 2024 at 1:04 AM

test command

xtrabackup --defaults-file=/etc/my.cnf --use-memory=4G --user='xxxxxx' --password='xxxxxx' --host='127.0.0.1' --port=6606 --parallel=8 --backup --target-dir=/data/xxxxxx