[lxc-users] Online container backup

[Fajar A. Nugraha]

On Thu, Jun 11, 2015 at 2:07 PM, Narcis Garcia <informatica at actiu.net>
wrote:

> Why is a snapshot better with database services?
> (time matter apart)
>
>
That question is better suited for relevant db list/forum/support. Googling
"database backup inconsistent" should give you good reference (add "mysql"
or whatever db you use for more db-specific results).

Short version, copying files take a long time. Some files can be copied
early, while others can be copied some time later (e.g. several minutes or
hours later). If the database files are modified (e.g. you have an insert
query) during the copy operation, the db will most likely be corrupted.
Oracle should be able to work around this when runnning archivelog mode,
other db may not be able to.

Snapshot is different. All files in a snapshot can be seen as a "copy"
result taken entirely at the same, so there is no issue of "database files
modified during copy operation", since the "copy" process is instaneous.
This would result in the same state as if the server suddenly experience a
crash or power loss, and most dbs can recover cleanly from that condition.

-- 
Fajar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.linuxcontainers.org/pipermail/lxc-users/attachments/20150611/31e25e96/attachment.html>