making netapp snapshot backups with percona xtrabackup

[guenter]

Hi
Is it possible to use percona xtrabackup for making snapshot backups
of the innodb consistent?
(in the following i will ignore the *.frm files that are also
necessary for the innodb tables and binary logs)
my idea ist:

xtrabackup --backup --target-dir=/bak --log-stream > /bak/
xtrabackup_logfile
# make the snapshot
rm /bak/xtrabackup_suspended #to stop the log-stream process


restoring the database:
stop mysql
restoring the ibdata1-file from the snapshot
removing the ib_logfile*
xtrabackup --prepare --target-dir=/bak

starting mysql

i hope that will work because everything that will be modified in the
innodb-file during the snapshot is recorded to the innodb-logs and
will be restored to the correct value during the prepare phase.

what confuses me is the fact that there is a special program tar4ibd
to copy the ibdata1 that "that understands how to work with InnoDB's
data format". of course the netapp snapshot knows nothing about the
innodb dataformat

can anybody explain this to me?

mfg guenter

[Peter Zaitsev]

Hi,

tar4idb is used for Stream backup  and is mainly needed so we can interleave different
files while streaming backup.    When files are copied they are just copied as files.

If you have netapp snapshot though why do not you simply take the snapshot and copy
all files from it ?  Is it expensive in terms of performance ? (this is often the case for LVM snapshots)

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To post to this group, send email to percona-d...@googlegroups.com.
To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.

--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501   Skype:  peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911

Percona Training Workshops
http://www.percona.com/training/