PDA

View Full Version : MySQL backup method options



tgordon
November 14th, 2007, 01:10 PM
Most importantly, I need the following features with my backup solution:

-Hot, or almost hot
-Fast/low overhead
-Support for InnoDB exclusively

I want to use ZRM. The SQL server is on a Debian machine w/o LVM. As far as the methods that ZRM implement to accomplish backups, what is my best bet?

paddy
November 14th, 2007, 02:03 PM
Most importantly, I need the following features with my backup solution:

-Hot, or almost hot
-Fast/low overhead
-Support for InnoDB exclusively

I want to use ZRM. The SQL server is on a Debian machine w/o LVM. As far as the methods that ZRM implement to accomplish backups, what is my best bet?

ZRM can do hot and almost hot backups of Innodb using mysql replication and
snapshot respectively. Snapshot interface allows support for other methods
of filesystem and volume snapshots other than LVM.

Please take a look at ZRM backup and recovery performance numbers posted by Dmitri - http://forums.zmanda.com/showthread.php?t=489&highlight=mysql+paper

You should download and try ZRM (http://www.zmanda.com/download-zrm.php)
so that you can get accurate performance numbers in your configuration. ZRM's application performance report will provide information on ZRM's application
impact.

Paddy

tgordon
November 14th, 2007, 02:33 PM
Thanks much!

tgordon
November 19th, 2007, 05:50 PM
ZRM can do hot and almost hot backups of Innodb using mysql replication and
snapshot respectively. Snapshot interface allows support for other methods
of filesystem and volume snapshots other than LVM.

What methods are these exactly? Could you point me to some documentation perhaps?

paddy
November 24th, 2007, 07:10 PM
What methods are these exactly? Could you point me to some documentation perhaps?

Snapshot plugin interface is described in the wiki (http://wiki.zmanda.com/index.php/Snapshot_Plugin). Please use
snapshot-plugin variable in the mysql-zrm.conf to configure another plugin.

If you need help in writing a filesystem or volume snapshot plugin, please ask.

We are working on adding more information to the wiki.

Thanks,
Paddy

tgordon
November 26th, 2007, 10:38 AM
So no snapshot-plugin has been implemented? There's just an interface for one currently? I don't quite understand.

paddy
November 26th, 2007, 10:40 AM
So no snapshot-plugin has been implemented? There's just an interface for one currently? I don't quite understand.


LVM snapshots uses this interface. You will see more plugins using this interface in future. Developing a filesystem or volume manager snapshot on your own is easy.

Paddy