2014-04-29 10:36 AM - edited 2015-12-18 12:23 AM
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.
2014-05-17 05:25 AM
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?