mysql consistent backup

Availability for the Always-On Enterprise

mysql consistent backup

Veeam Logoby cda » Tue Aug 02, 2016 1:20 pm

Hi all,
I'm trying to backup a VM with mysql database, hosted on a GNU/linux guest.

I've just read https://www.veeam.com/wp-hot-backup-of-mysql-on-a-linux-vm.html whitepaper written by Ricky El-Qasem but I've still some doubts.
In the aforementioned whitepaper, Ricky suggest to install VMware tools and to create two files (pre-freeze-script and post-thaw-script) on guest VM, located in /usr/sbin.
In my case script contents are very simple (stock files): "service mysql stop" and "service mysql start"

So far so good, but here starts my doubts.

1) Why script filenames has no extension (.sh)?
2) How to tell Veeam to use this scripts lauching a new job? Maybe ticking following flag?
Image
3) Should I create a full path to "service" command eg. "/usr/sbin/service mysql start" or "service mysql start" is enought?

On this forum I found another post that suggest to enable "application-aware processing"
Image
and copy freeze and thaw scripts on Windows server running Veeam Backup.
Image

4) Can both methods ("VMware tools quiescence" and "application-aware processing") coexist?
5) Which is the best way to backup a GNU/linux mysql guest VM?

Sorry for long post.
Best regards
cda
cda
Novice
 
Posts: 8
Liked: never
Joined: Mon Dec 17, 2012 12:17 pm
Full Name: cda

Re: mysql consistent backup

Veeam Logoby Vitaliy S. » Tue Aug 02, 2016 2:58 pm

Hello,

1. Script formats are suggested by VMware, but they should have an "sh" extension. See this blog post for more info > https://www.virtuallifestyle.nl/2013/03 ... -database/
2. Yes, you need to enable VMware Tools Quiescence if you want to use VMware Tools pre-freeze and post-thaw scripts.
3. I guess it should be a full path
4. No, for all Windows VMs we highly recommend to use AAIP instead of VMware Tools Quiescence.
5. Feel free to use VMware Tools Quiescence option with pre-freeze and post-thaw scripts as it is described in the blog post above.

Hope this helps!
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: mysql consistent backup

Veeam Logoby vmniels » Tue Aug 02, 2016 3:58 pm

Do keep in mind that stopping the services also means it becomes unavailable. It's better to either look at mysqldump or putting the database in a read only mode.
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be
vmniels
Veeam Software
 
Posts: 1623
Liked: 360 times
Joined: Mon Jul 15, 2013 11:09 am
Full Name: Niels Engelen

Re: mysql consistent backup

Veeam Logoby Vitaliy S. » Tue Aug 02, 2016 4:19 pm

Yep, this is what advised in the referenced blog post ;)
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: mysql consistent backup

Veeam Logoby vmniels » Tue Aug 02, 2016 4:28 pm

An additional note is that if you want to do point in time restores don't look at the methods used in the blog post but enable the binary log as described on http://dev.mysql.com/doc/refman/5.7/en/ ... overy.html
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be
vmniels
Veeam Software
 
Posts: 1623
Liked: 360 times
Joined: Mon Jul 15, 2013 11:09 am
Full Name: Niels Engelen

Re: mysql consistent backup

Veeam Logoby cda » Wed Aug 03, 2016 5:17 am

Thanks all for your kind help.
I will try suggested hints.
Best regards
cda
cda
Novice
 
Posts: 8
Liked: never
Joined: Mon Dec 17, 2012 12:17 pm
Full Name: cda

[MERGED] Red HAT Database Pause script help

Veeam Logoby Stevet170 » Tue Nov 15, 2016 12:23 pm

Hi
I am trying to pause a Unidata database running on Red Hat. There are unidata commands /db/unidata/bin/dbpause and /db/unidata/bin/dbresume but I cannot get them to run. Now this may well be my lack of Linux knowledge rather than Veeam but has anyone any ideas how I could run dbpause and dbresume from a script?

Thanks
Stevet170
Lurker
 
Posts: 1
Liked: never
Joined: Tue Nov 15, 2016 11:05 am
Full Name: Stephen Threlfall

Re: mysql consistent backup

Veeam Logoby PTide » Tue Nov 15, 2016 2:21 pm

Hi,

Please review the thread to see an explanation of how to use VMware Tools Quiescence if you want to use VMware Tools pre-freeze and post-thaw scripts. Also there is an option to leverage Veeam pre-freeze/post-thaw scripts.

Thanks
PTide
Veeam Software
 
Posts: 3230
Liked: 269 times
Joined: Tue May 19, 2015 1:46 pm

[MERGED]Application Consistent Snapshots/replication for Uni

Veeam Logoby Mouis Yafeh » Mon Nov 06, 2017 6:52 am

Hello,

Has anyone created a pre-freeze/post-thaw scripts for Unidata database? I greatly appreciate it,

Thanks,

Mouis Yafeh
Mouis Yafeh
Lurker
 
Posts: 1
Liked: never
Joined: Mon Nov 06, 2017 6:45 am
Full Name: Mouis Yafeh

Re: Application Consistent Snapshots/replication for Unidata

Veeam Logoby DGrinev » Tue Nov 07, 2017 10:16 am

Hi Mouis and welcome to the community!

Please review this thread as it contains useful considerations on how to achieve what you're after. Thanks!
DGrinev
Veeam Software
 
Posts: 608
Liked: 71 times
Joined: Thu Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Yahoo [Bot] and 4 guests