Best Practice for Backing Up Linux VMs

Availability for the Always-On Enterprise

Best Practice for Backing Up Linux VMs

Veeam Logoby tinto1970 » Fri Jan 10, 2014 11:49 am 2 people like this post

Hi all, since it's my first topic let me introduce me: I'm Alessandro and i'm writing from Italy. I'm a newbie with Veeam, and a couple of years of experience with VMware.
I'm happy to join this Community :)

At the moment I'm running my first jobs both on Windows and Linux guests. With Windows, where I'm mostly running VSS aware applications, i feel more comfortable.

On Linux it's a bit more complicated because VSS is not available. I've studied the documentations and an interesting, popular post which is http://www.virten.net/2012/05/filesyste ... th-vmware/

I think i have understood the various level of consistency in backups (crash, file level, application) but i still have difficulties to decide how to proceed with Linux VMs. Creating the jobs with "all defaults" the VMware tools quiescence is not enabled, so backups taken are crash-consistent. Is it better to enable quiescence on any Linux VM, or it's better to enable only when running particular applications (i.e. MySQL)?

Another question is about that blog's post: it refers about enabling VMware FileSystem Sync Driver (vmsync) in VMware Tools configuration. I'm running on lastest buld of vSphere 5.1u1 (1312873) and i have performed the installation of VMware Tools on a VM today, searching for that "experimental" option to enable. I did not see it: the sync driver is out of experimental so enabled by default or become unavailable?

Thanks in advance
Alessandro Tinivelli aka Tinto
@tinto1970
tinto1970
Enthusiast
 
Posts: 63
Liked: 25 times
Joined: Thu Sep 26, 2013 8:40 am
Location: Bologna, Italy
Full Name: Alessandro Tinivelli

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby Vitaliy S. » Fri Jan 10, 2014 1:02 pm

Hi Alessandro,

Welcome to the community forums!

tinto1970 wrote:Is it better to enable quiescence on any Linux VM, or it's better to enable only when running particular applications (i.e. MySQL)?

We do recommend using VMware Tools quiescence with pre-freeze/post-thaw scripts when backing up Linux/Unix VMs with mission critical applications. Please search these forums for some script usage examples.
tinto1970 wrote:Another question is about that blog's post: it refers about enabling VMware FileSystem Sync Driver (vmsync) in VMware Tools configuration. I'm running on lastest buld of vSphere 5.1u1 (1312873) and i have performed the installation of VMware Tools on a VM today, searching for that "experimental" option to enable. I did not see it: the sync driver is out of experimental so enabled by default or become unavailable?

That's almost a two years old post. According to VMware KB articles they have replaced SYNC driver with VSS option for Windows. Cannot find what is used for Linux, but, anyway, it's better to have this option (VMware Tools quiescence ) enabled for the backed up VM to quiesce Linux file systems.

Hope this helps!
Vitaliy S.
Product Manager
 
Posts: 18986
Liked: 1046 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby tinto1970 » Fri Jan 10, 2014 5:56 pm 1 person likes this post

thank you Vitaly,
in fact we have already tested in a couple of Linux VMs running MySQL the use of pre-freeze/post-thaw scripts to set the daemon in a status similar to the "backup mode" of Oracle (unfortunately MySQL doesn't have this feauture).

My doubt about using the VMware Tools quiescence derives from the fact that one (of many) linux VM (Centos 6.x) which was backed up with quiescence enabled this night has "crashed" (system not responsive, needing a power cycle to restart it). I need to do a deeper analysis about this fact, which worries me a bit.

thanks again
Alessandro Tinivelli aka Tinto
@tinto1970
tinto1970
Enthusiast
 
Posts: 63
Liked: 25 times
Joined: Thu Sep 26, 2013 8:40 am
Location: Bologna, Italy
Full Name: Alessandro Tinivelli

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby v.Eremin » Mon Jan 13, 2014 8:08 am 1 person likes this post

Hi, Alessandro,

in fact we have already tested in a couple of Linux VMs running MySQL the use of pre-freeze/post-thaw scripts t

I don't know whether you've seen it already, but there is a white paper that describes how Linux VM running MySQL application should be backed up; might be useful for you.

My doubt about using the VMware Tools quiescence derives from the fact that one (of many) linux VM (Centos 6.x) which was backed up with quiescence enabled this night has "crashed" (system not responsive, needing a power cycle to restart it). I need to do a deeper analysis about this fact, which worries me a bit.

You might want to open a ticket with our support team, and they will be able to confirm whether everything is set up correctly.

Thanks.
v.Eremin
Product Manager
 
Posts: 12370
Liked: 892 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

[MERGED] Linux VM backup without VMware tools quiescence

Veeam Logoby erth111 » Thu May 29, 2014 1:34 pm 1 person likes this post

Hi,
I'm configuring backup for a linux VM without any database inside. By default the "VMware tools quiescence" setting is disabled. Is this setting making the backup any worse compared to a backup with "VMware tools quiescence" enabled? Can you provide a link, or explanaition of what exactly happens inside the vm with and without this setting?
erth111
Influencer
 
Posts: 19
Liked: 3 times
Joined: Mon Jan 20, 2014 3:11 pm

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby foggy » Thu May 29, 2014 1:57 pm 1 person likes this post

If the VM has VMware Tools installed, then the best practice is to enable VMware Tools Quiescence. However, most of the Linux applications can handle backups without pre-freeze preparation.
foggy
Veeam Software
 
Posts: 13899
Liked: 1012 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby erth111 » Thu May 29, 2014 2:55 pm 1 person likes this post

Why isn't it enabled by default then?
erth111
Influencer
 
Posts: 19
Liked: 3 times
Joined: Mon Jan 20, 2014 3:11 pm

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby Vitaliy S. » Thu May 29, 2014 8:00 pm 1 person likes this post

Hi Tomasz,

This option is not enabled by default because you might have Windows VMs added to the job and best practice for these VMs is to use "application-aware image processing" instead and not VMware Tools Quiescence. Based VMs type you add to the job, you should enable either of the options.

Thanks!
Vitaliy S.
Product Manager
 
Posts: 18986
Liked: 1046 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby Gostev » Sun Jun 01, 2014 5:53 pm 2 people like this post

Historically, VMware Tools quiescence caused too many support issues, even corrupting production application in the early days due to the way it did quiescence, so at some point we simply disabled it by default.
Gostev
VP, Product Management
 
Posts: 20961
Liked: 2239 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

[MERGED] : How to backup microsft sql database; mysql (linux

Veeam Logoby nufael » Wed Jun 25, 2014 4:41 am

Hi,

I've run through some of articles on how to do backup for VM database but it seem not really helpful in my situation. Appreciate if someone could assist me on how to do VM database backup (windows SQL and MYSQL linux) and restore it without affecting any single data. **I'm using Vsphere 5.5 as my virtual platform

One of the article suggested to use sureBackup feature and make us of U-AIR to restore Microsoft SQL database.

My question:
1) How about Linux database?
2) For windows database, do I need to do local VM backup (using SQL server management studio) before I do backup on the VM database server using VBR? Or I shouldn't do that?
3) If I use standard tool backup by Veeam (run backup job) on my database server, can it be use as my recovery plan and restored if needed?

Thanks and Regards
nufael
Influencer
 
Posts: 24
Liked: never
Joined: Wed Jun 18, 2014 8:06 am
Full Name: nufael

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby v.Eremin » Wed Jun 25, 2014 8:50 am

Your post has been merged into existing discussion. Please, see answers provided above and ask for additional clarification, if needed.
v.Eremin
Product Manager
 
Posts: 12370
Liked: 892 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby vmniels » Wed Jun 25, 2014 9:19 am

MySQL can be done with the scripts as mentioned above. There are also a lot of people who just use the VMware snapshot and use the virtual labs or instant VM recovery (with a different IP) to get data from a MySQL database. This works fine and MySQL is a very easy database in that point of view.
VCP-DCV
Veeam Certified Engineer
http://foonet.be
vmniels
Veeam Software
 
Posts: 1178
Liked: 284 times
Joined: Mon Jul 15, 2013 11:09 am
Full Name: Niels Engelen

111 Re: Best Practice for Backing Up Linux VMs

Veeam Logoby nufael » Mon Jun 30, 2014 6:36 am

To be very clear:

For MySQL database:

Due to VSS unavailable in LINUX platform, I need to use VMware Tools quiescence with pre-freeze/post-thaw scripts when backing up Linux/Unix VMs. To do this, Vm tools must be install in my virtual machines and I need to create the pre-freeze/post-thaw scripts. By referring to the white paper written by Ricky El-Qasem, there are 2 options:

a) Suspended MySQL service
- VMware tools installed
- create 2 scripts for pre-freeze/post-thaw scripts
- For pre-freeze file, insert the service mysql stop
- Post-thaw, insert service mysql stop

b) Use online backup dump
- create 2 scripts for pre-freeze/post-thaw scripts
- For pre-freeze file, insert the service mysql stop and sudo mysqldump –uroot –pveeam –h localhost test >
test.sql

**It doesn't mention what to insert in post thaw scripts. Can someone help me on this?

For MS SQL database:

1. Enabling Application-Aware Image Processing option
2. Enabling log truncation

My questions:

1) Can I use U-AIR wizard to restore both databases (MS SQL and MySQL)?
2) By using the U-AIR wizard, it will recover a specific object. Does it sounds I need to run the database backup using Microsoft management studio for MS SQL and mysql dump for MySQL database before I backup the database server?

Thanks and Regards
nufael
Influencer
 
Posts: 24
Liked: never
Joined: Wed Jun 18, 2014 8:06 am
Full Name: nufael

Re: Best Practice for Backing Up Linux VMs

Veeam Logoby Vitaliy S. » Mon Jun 30, 2014 2:48 pm

Hello,

1. You should be using Linux commands you use to stop and start services.

BTW, there is a couple of blog post with more examples on this:
http://www.hiperlogic.com/blog/?p=803
http://www.virtuallifestyle.nl/2013/03/ ... -database/

2. If you want to restore database files, then you can just use FLR restore wizard to pull database files out of the backup files.

3. If you want to do point-in-time restores then you can use these tools. If you just want to backup the entire VM with all the databases, then Veeam backup job should be enough.

Thank you!
Vitaliy S.
Product Manager
 
Posts: 18986
Liked: 1046 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

[MERGED] Linux Backup

Veeam Logoby Rohail2004 » Fri Oct 24, 2014 1:46 pm

hello,

we're moving our main production database to Linux OS. Is there anyone out there who's been backing up Linux via Veeam? Anything I need to be aware of? I'll be pausing the database through a script, and then Veeam take the backup. Any advice on successful implementation would be greatly appreciated. thank you,
Rohail2004
Enthusiast
 
Posts: 41
Liked: never
Joined: Wed Oct 06, 2010 6:54 pm

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Gostev and 11 guests