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@xxxxxxxxxx
> 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
++++++++++++++++++++++++++++++++++++++++
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
https://lists.centos.org/mailman/listinfo/centos
