MySQL on FreeBSD with Veeam

[Nestea1]

Hello
I am very new on the Veeam Production, sorry about that.

I have two FreeBSD 10 Server with MySQL, one is the master and the other the slave (replikation)
How i can backup this two server without have problems?

i make a test and give a command to fill the MySQL database and at the same test i make a backup...i had no problem...no downtime...is this correct?

Thank you for your help

[Vitaliy S.]

Hello,

Not sure I fully understand what command you're referring to, but I would recommend enabling VMware Tools quiescence and using pre-freeze and post-thaw scripts to have a consistent-state of the application during backup job run. Please search these forums for some examples of these scripts.

Thank you!

[nielsengelen]

If you have an active/passive setup just backup both servers. As mentioned VMware Tools quiescence and the scripts is advised but it's not required as MySQL is very easy to recover data from by using virtual labs or instant VM recovery.

[Nestea1]

If i want no downtime on production system i make only a backup from slave server.
Is this a good solution or has anybody this realziert

And which script do you mean? The Script who is descript on this white paper?
http://veeampdf.s3.amazonaws.com/whitep ... nbOaQgY%3D
(Is a whitepaper for mysql and Linux but i think it works on freebsd)

My problem is how can configurate veeam to start the script everytime i make the backup and start the mysql after the backup?

Thank you for your help

[foggy]

Yes, you should use the same approach described in this paper. Pre-freeze and post-thaw scripts are triggered each time VM snapshot is created during backup.

[veremin]

And in order to use pre-freeze, post-thaw scripts don't forget to enable VMware tools quiescence in the job settings. Thanks.