Testing for backup of partitions tables
Bug #707008 reported by
Vadim Tkachenko
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Valentine Gostev | ||
Bug Description
We need to test backup of database with tables with partitions.
It should cover also incremental backup of these tables.
Related branches
lp:~percona-dev/percona-xtrabackup/xb_partition
- Alexey Kopytov: Pending requested
-
Diff: 237 lines (+222/-0)3 files modifiedtest/inc/part_range_sample-db/part_range_sample-schema.sql (+54/-0)
test/t/ib_partition.sh (+68/-0)
test/t/xb_part_range.sh (+100/-0)
| Changed in percona-xtrabackup: | |
| assignee: | nobody → Valentine Gostev (core-longbow) |
| Changed in percona-xtrabackup: | |
| milestone: | none → 1.6 |
| Changed in percona-xtrabackup: | |
| importance: | Undecided → Medium |
| status: | New → In Progress |
Revision history for this message
| Valentine Gostev (longbow) wrote | #1 |
| Changed in percona-xtrabackup: | |
| status: | In Progress → Fix Committed |
| Changed in percona-xtrabackup: | |
| status: | Fix Committed → Fix Released |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
Added general test for full and incremental backups of partitioned tables.
Issues found:
- <tablename>.par file is not backuped by xtrabackup binary. To make backup more reliable *.par files should be backuped manually, or such backup may protect only from accidental "delete from table" and similar statements.
- while using innobackupex for backuping some particular tables (--tables-file option) - only <tablename>.par file is being backuped.
Full backups with innobackupex contain all necessary files.