PDA

View Full Version : Can't find the answer: Does Zmanda need a DB-Lock for Backup?



gerrie1978
September 21st, 2007, 01:33 AM
Hey erveryone,

I have a simple question but can't find it anywhere in the documentation.

We have 2 RHEL Server running MySQL and we need to Backup the DB (InnoDB) without being locked, so the normal database process cannot be interrupted.

Ist this possible with zmanda?

Thanks a lot,

Nadine

shailen
September 25th, 2007, 04:36 PM
Hey erveryone,

I have a simple question but can't find it anywhere in the documentation.

We have 2 RHEL Server running MySQL and we need to Backup the DB (InnoDB) without being locked, so the normal database process cannot be interrupted.

Ist this possible with zmanda?

Thanks a lot,

Nadine

Hello Nadine,

Yes this is possible with Zmanda Recovery Manager.

You can backup your InnoDB databases by using the lvm-snapshot backup mode in Zmanda Recovery Manager.

Please note there are a few caveats:

1) Your MySQL databases must be running on a LVM. This is usually set up at boot time.

2) You must have some unallocated space available in your volume group. For example, if your Volume Group is 100gb. And you create a 95gb Logical Volume, and leave the other 5gb unallocated so that ZRM can use this space during the backup window.

Please feel free to download and try the community edition.

You can also find more documentation at http://wiki.zmanda.com

Thanks!
-Shailen

uvdevnull
December 22nd, 2009, 03:14 PM
You must have some unallocated space available in your volume group. For example, if your Volume Group is 100gb. And you create a 95gb Logical Volume, and leave the other 5gb unallocated so that ZRM can use this space during the backup window.


Since most people won't have any free unallocated space in the vg, follow this guide to resize and reclaim the free extents that this type of backup requires:

http://forum.nest-solutions.com/viewtopic.php?f=2&p=174