Comprehensive data protection for all workloads
Post Reply
Daveyd
Expert
Posts: 283
Liked: 11 times
Joined: May 20, 2010 4:17 pm
Full Name: Dave DeLollis
Contact:

Backing up MYSQL databases and VSS

Post by Daveyd » May 20, 2010 4:22 pm

I am in a trial version of Veeam and have several Windows 2008 x64 VMs that use MYSQL databases pretty hard. I would like to backup the enire VMs with precautions since theses are very important VMs. I was not sure is MYSQL is VSS aware or not and was not sure what option in Veeam to choose when doing the VM level backups...Enable VM Tools quiescence or Enable Veeam VSS integration. I would like a transactionally consistent backup if possible but don't know if that is possible for MYSQL.

Any thoughts?

Vitaliy S.
Product Manager
Posts: 22991
Liked: 1556 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backing up MYSQL databases and VSS

Post by Vitaliy S. » May 20, 2010 4:49 pm

Hello Dave,

Try running the following two commands in the VM and see if output contains any MySQL VSS related writers and providers:

Code: Select all

vssadmin list writers
vssadmin list providers
But as far as I know, MySQL doesn't have any VSS writers, so you should you use VMware Tools quiescence with pre-freeze and post-thaw scripts to keep your application in consistent state.

Here is a existing thread that that should be relevant for you:
http://www.veeam.com/forums/viewtopic.p ... sql#p15101

Hope it helps!

habibalby
Expert
Posts: 379
Liked: 24 times
Joined: Jul 18, 2011 9:30 am
Full Name: Hussain Al Sayed
Location: Bahrain
Contact:

Backing Up MySQL on Windows Server

Post by habibalby » Aug 11, 2011 10:49 am

[merged]

Hi Guys,

I have several Windows Servers installed with MYSQL, when I back them up using Application-Aware feature, will VSS consider MYSQL for the backup or I have to go through the batch script to backup the DB or VMToos post-script?

skydok
Veeam ProPartner
Posts: 68
Liked: 12 times
Joined: Jun 11, 2012 12:04 pm
Contact:

[MERGED] Is there Support for DB2 & MySQL ?

Post by skydok » Jan 24, 2013 11:50 am

Hello,
i Have a Customer with MySQL& DB2 Databases on Windows Servers and wanted to know if Veeam does know how to create a Consistent Backup? Also Regarding Replication.
Storage Solution Specialist
Veeam FAN
@shatztal
Blog: http://www.skydok.com

veremin
Product Manager
Posts: 16897
Liked: 1437 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up MYSQL databases and VSS

Post by veremin » Jan 24, 2013 12:44 pm

Additionally, there is a dedicated white paper regarding backing up MySQL server residing on Linux VM. It can be found here.

Same approach should be used for Windows instance as well, without any differences (same prefreeze/postthaw scripts as described).

Hope this helps.
Thanks.

mikents
Lurker
Posts: 1
Liked: never
Joined: Jan 24, 2013 10:34 pm
Full Name: Mike
Contact:

Re: Backing up MYSQL databases and VSS

Post by mikents » Jan 24, 2013 10:35 pm

The link seems to be broken.

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 18 guests