On Thu, June 9, 2016 3:03 pm, Gordon Messmer wrote:
On 06/09/2016 11:43 AM, Valeri Galtsev wrote:
When databases are concerned, I would never rely on a snapshot of their storage files. Either stop relevant daemon(s), then do fs snapshot, or better though do dbdump and restore databases from dump when you need to restore it.
Dumping and restoring files can be *really* slow, so "better" is highly subjective.
Agree. In my case I used it in a meaning of least questionable consistency of database records (and least questionable again from my own point of view of a sysadmin who definitely has restricted knowledge of database server in question internals). I didn't write it in that level of detail, sorry: usually I'm tempted to write as short and simple as I can - at the expense of accuracy -, just to save effort to whoever is kind enough to read what I wrote ;-)
Valeri
Instead, you could quiesce your databases to get a filesystem snapshot. I wrote a framework for doing this that is filesystem and application agnostic, which I mentioned in a previous message. _______________________________________________ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
++++++++++++++++++++++++++++++++++++++++ Valeri Galtsev Sr System Administrator Department of Astronomy and Astrophysics Kavli Institute for Cosmological Physics University of Chicago Phone: 773-702-4247 ++++++++++++++++++++++++++++++++++++++++