Data Backup and Recovery

Using SnapCreator during business hours, minimizing downtime.



We are using Snapcreator to create snapshots of our MySQL database in a lab environment.  We would like to use it in production to snapshot and snapmirror the database every hour on the hour, but we've seen lock/unlock times as high as 33 seconds.  Anybody have any ideas as to how to reduce this time, or experiences using Snapcreator under these conditions?  Right now we use the built in plugin to take a snapshot of mysql.  We then have a post quiesce scripts that grabs the log position(perl script on the server), then we let the service re-quiesce and initiate the snapmirror.




As bad as it sounds, you can setup a mysql slave and run the backups against it. I do this and it works, but doesn't scale very well if you have lots of individual mysql instances.

Would you be able to provide more info on your method? What storage engine? What is the purpose of recording binlog position?




Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner