Re: remote backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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



[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux