PDA

View Full Version : Cold backup or Physical backup



robranmar
March 23rd, 2007, 07:47 AM
Hello, I am using MySQL 5.0 with InnoDB tables stoted in a SUSE Linux server but the database size is very big right now, arround 8 GB.

We have been using logical backups but at the moment when we try to recover the database, it takes a lot of time, I have been reading that there is something named Pysical backup also named Cold backup, and it is like copying the files without the necessity to dump the database, does your product perfom this task or something similar?

Basically our necessity is to recover the database coming from a backup is a short period of time, that is our objetive.

Thanks and I will be waiting for your response.

Regards,

Roberto Rangel

shailen
March 23rd, 2007, 10:40 AM
Hi Roberto,

The other option for protecting an InnoDB database is using LVM snapshots.

ZRM interfaces with the operating system to create a snapshot of your database and then it temporarily mounts the snapshot so that it can copy your database and back it up.

This allows for HARDLY NO read locks to be issued on your database.

The only requirements for this are the following:

the MySQL database should reside on an XFS filesystem (xfs supports freeze and thaw operations)

Your MySQL Server should be running LVM (logical volume manager)

and you must have approx 100 m of raw space available (more if in your backup window you expect to have a lot of writes on your database)

I hope that helps to answer you questions.

Thanks!
-Shailen