Comments on: mylvmbackup HOWTO: minimal privileges & filesystem copy https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy Blog by Shlomi Noach Thu, 29 Jan 2015 19:22:40 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-306895 Thu, 29 Jan 2015 19:22:40 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-306895 @Harry, you can’t just use rsync on a running server (writes keep occuring even if idle). You may just shut down the MySQL server, than rsync (or just cp/netcat). Otherwise take a look at Xtrabackup, which can throttle I/O

]]> By: HarryKalahan https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-306561 Wed, 28 Jan 2015 11:26:59 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-306561 I would like to make a question about performance of mylvmbackup. We’ve experienced performance problems running backups of mysql databases using mylvmbackup. Moreover the mysql service process get zombie and monit tried to start the mysql several times. We could see backup process takes too time to finish (6 hours of a database of 48GB). Could rsync reduce impact in a production database?

]]> By: Creating MySQL backups using LVM — Effective MySQL https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-50570 Fri, 02 Sep 2011 21:39:11 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-50570 […] mylvmbackup HOWTO: minimal privileges & filesystem copy provides a detailed explanation of the minimum permissions required. Filed Under: Article […]

]]> By: Backing up a highly utilized MySQL db « "DZUB-NON TRUL-PAR" https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-44587 Fri, 24 Jun 2011 07:50:50 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-44587 […] https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy […]

]]> By: JBHoren https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-18559 Wed, 06 Oct 2010 21:13:56 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-18559 ישר כח, שלומי!

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-16805 Wed, 18 Aug 2010 19:27:27 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-16805 Hi Lenz,
My personal impression of writing open source tools, is that writing the documentation is the hardest part. Once can have so much to discuss even the smallest feature. It’s endless… 🙂

]]> By: LenZ https://shlomi-noach.github.io/blog/mysql/mylvmbackup-howto-minimal-privileges-filesystem-copy/comment-page-1#comment-16803 Wed, 18 Aug 2010 18:21:28 +0000 https://shlomi-noach.github.io/blog/?p=2839#comment-16803 Hi Shlomi,

Awesome! Thanks a lot for writing this up. I’ll add a link to your article to the links section of the mylvmbackup home page.

]]>