- Community Home
- >
- Storage
- >
- HPE Nimble Storage
- >
- Array Performance and Data Protection
- >
- Script to Backup MySQL Database to Nimble
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2014 12:04 PM
тАО07-23-2014 12:04 PM
I need to stop and start MySQL database, take snapshots, and then restart My SQL database. Using Bash (RedHat Linux)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2014 06:30 AM
тАО07-24-2014 06:30 AM
Re: Need help writing a script to backup MySQL database to Nimble.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2014 06:41 AM
тАО07-24-2014 06:41 AM
Re: Need help writing a script to backup MySQL database to Nimble.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2014 08:31 AM
тАО07-24-2014 08:31 AM
SolutionHey 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2014 09:38 AM
тАО07-24-2014 09:38 AM
Re: Script to Backup MySQL Database to Nimble
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2014 09:51 AM
тАО07-24-2014 09:51 AM
Re: Script to Backup MySQL Database to Nimble
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...