topic Script to Backup MySQL Database to Nimble in Array Performance and Data Protection

Script to Backup MySQL Database to Nimble

jmcgary103 — Wed, 23 Jul 2014 19:04:52 GMT

I need to stop and start MySQL database, take snapshots, and then restart My SQL database. Using Bash (RedHat Linux)

Re: Need help writing a script to backup MySQL database to Nimble.

Thu, 24 Jul 2014 13:30:09 GMT

Im sure you could do this with the PowerShell module... although I haven't had the chance to use it yet. If it facilitates snapshotting (which it looks like it does), you could simply use PowerShell to call plink.exe and pass your MySQL service stop, take the snap, start MySQL.

Re: Need help writing a script to backup MySQL database to Nimble.

Thu, 24 Jul 2014 13:41:21 GMT

I'll be honest... I'm extremely new to the Nimble community and not aware of CLI/API capabilities yet. If you can ssh from Linux directly to Nimble then that would obviously be your choice.

Forgot to add... ping me offline at mike@runningohio.com if you need some help writing this. Both PowerShell and Bash.

Mike

Re: Need help writing a script to backup MySQL database to Nimble.

rfenton4 — Thu, 24 Jul 2014 15:31:41 GMT

Hey Jeffery,

Check out the excellent script written by Tom Dau:

https://connect.nimblestorage.com/docs/DOC-1302

It specifically pertains to Oracle but the genesis of the operations is identical - Tom's script puts Oracle into and out Archive logmode in order to get the consistency but you should be easily able to substitute that for the MySQL equivalent or the shutdown/restart of the service.

Cheers
Rich

Re: Script to Backup MySQL Database to Nimble

jtmoree23 — Thu, 24 Jul 2014 16:38:55 GMT

I wrote my own snapshot utility similar to the oracle one. I already have custom backup scripts for mysql so I added this process to the same project. The basic idea goes like this:

* process on DB server locks database

* forked process starts snapshot on nimble

* after snap DB tables are unlocked

https://sourceforge.net/projects/mysqlarchives/

I posted the code here. Feel free to take a look.

Re: Script to Backup MySQL Database to Nimble

rfenton4 — Thu, 24 Jul 2014 16:51:14 GMT

JT Moree - you should post that to the main forum as well - there is a nice promotion running for the community for tips, suggestions and scripts...