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 at 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 ++++++++++++++++++++++++++++++++++++++++