support partition as command line option to xtrabackup
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Hrvoje Matijakovic |
Bug Description
Hello,
I am using mysql 5.5 with lots of range based partitioned tables . I use monthly partitions and use sliding window of 12 months as data retention policy. In current environment, I dont update data for previous months partition. So as I roll forward to the next month , the partitions for previous months becomes static ones. I only update data for current partitions at any time.
So far we could provide table names, tables-file as command line options , to selectively back them using xtrabackup. On the same line if xtrabackup add supports to backup 'partitions' as command line filter, it would be super. With extensive use of partitioned tables now days, this is much needed feature. With this feature xtrabackup will be truly partition compatible backup solution.
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 337 lines (+148/-70)8 files modifieddoc/source/how-tos.rst (+1/-0)
doc/source/howtos/recipes_ibkx_partition.rst (+105/-0)
doc/source/innobackupex/innobackupex_option_reference.rst (+1/-1)
doc/source/innobackupex/partial_backups_innobackupex.rst (+5/-1)
doc/source/installation/apt_repo.rst (+4/-4)
doc/source/percona-theme/layout.html (+11/-41)
doc/source/release-notes.rst (+20/-22)
innobackupex (+1/-1)
- Alexey Kopytov (community): Approve
-
Diff: 345 lines (+148/-70)8 files modifieddoc/source/how-tos.rst (+1/-0)
doc/source/howtos/recipes_ibkx_partition.rst (+105/-0)
doc/source/innobackupex/innobackupex_option_reference.rst (+1/-1)
doc/source/innobackupex/partial_backups_innobackupex.rst (+5/-1)
doc/source/installation/apt_repo.rst (+4/-4)
doc/source/percona-theme/layout.html (+11/-41)
doc/source/release-notes.rst (+20/-22)
innobackupex (+1/-1)
Changed in percona-xtrabackup: | |
status: | Triaged → In Progress |
Changed in percona-xtrabackup: | |
status: | In Progress → Fix Committed |
Changed in percona-xtrabackup: | |
status: | Fix Committed → In Progress |
Changed in percona-xtrabackup: | |
status: | In Progress → Fix Committed |
Changed in percona-xtrabackup: | |
status: | Fix Committed → Fix Released |
It is already possible to backup individual partitions with XtraBackup, since from the storage engines perspective partitions are regular tables with specially formatted names.
For example, table t containing partitions p0, p1 and p2 will be 3 separate tables inside InnoDB: t#P#p0, t#P#p1 and t#P#p2. So all that needs to be done to backup partition p0 (apart from enabling innodb_ file_per_ table) is to use t#P#p0 as a table 'name'.
We don't have that procedure documented anywhere explicitly, so I'm changing this bug to a doc request.