Re: [PLUG] Thoughts on MySQL from a developer

[Rich Freeman via plug <plug@lists.phillylinux.org>]

On Mon, Dec 6, 2021 at 1:27 PM Keith via plug
<plug@lists.phillylinux.org> wrote:
>
> I don't generally do LVM snapshots but I do run nilfs2 volumes on systems where I need filesystem snapshotting.  I haven't tested that with Pg or MySQL since I handle such tasks at the system or VM level but I like the idea of using quiesce.  I'll have to read up more on that.
>

I suspect those instructions work fine for mysql/lvm, but I would
check the docs to ensure that there is an official way to ensure the
files are quiescent.  Just locking and flushing the tables doesn't
necessarily ensure the files are "clean," though it could.  I'd think
this would be fairly software-specific.

I would look at the database vendor/developer documentation for
supported backup methods.  This will ensure that your scripts don't
mysteriously break, probably between the time of disaster recovery
testing and an actual disaster.  Backup is usually a consideration
everybody looks at when choosing a database so any reputable product
will have plenty of documentation on how to do it in a supported way.
It is common that databases can be very large and take a long time to
dump, so they'll have some mechanism to do so safely.

-- 
Rich
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug