-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 23/02/16 15:45, Dennis Pallett wrote:
Hi all,
Is it possible to create a file system level backup of a running MonetDB database? What are the downsides of doing this?
For what it's worth, our databases are generally never updated outside of pre-fixed windows so only SELECT queries will be executed during any file system level backup.
Best regards, Dennis Pallett
At any point in time, the disk image of the database should be consistent. All committed transactions should be safe on disk. But MonetDB makes use of atomic file system operations to commit transaction s. Since making a file system backup takes time, it could start before a transaction commits, and end after. If this happens, there cannot be any guarantees about the backup. Another potential for problems is when the server decides to do some database maintenance. Every once in a while, the write-ahead log (WAL) is cleaned up. It this happens during a file system backup, again there are no guarantees. If neither of these events (transaction, WAL cleanup) happens during the backup, you're probably ok. But this is not something we can guarantee in any way, so to be sure of a proper backup, you should also create a sql-level backup (msqldump) in case the file system backup gives weird results after it is restored (which one of course hopes is never needed). - -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJWzH8zAAoJEISMxT6LrWYgeagH/3TV//5Qa2l/ZKae7xjda4NP 5cXw4yzOGNA0ONnBL+yGN5bRPr4Mz+J6dGoWWdnFv6VZkeH4ZPzi4zQkHZdX5idH LgRliVvUq37wyYKJwjNtyBWV7zAnDMofpeayuBapFVa/3G8KH4+T1otG0JmRC13w XKpe7kmaxFZoCtrGleLQ4Iy7cYdigbkVi+w4O/pS/e9lt9g+AmF0Nf/IZOM1AAS1 Z/Klu9jOZ4WUqRtqFD1XOGCnn7A82Zx1XsDUWW2Gd92FSwB2SdCSI3wA1FT4Ma07 HkdF+LotwprN231V28qeIzOp9oXJKXnyx7P/9/YeippcJoZyTmxcP0ya2ANQL5A= =Z7zN -----END PGP SIGNATURE-----