From: Philip Amadeo Saeli <psaeli@Zorodyne.COM>
To: LVM general discussion and development <linux-lvm@redhat.com>
Subject: [linux-lvm] LVM snapshot setup for mysql-zrm backups problem
Date: Tue, 27 Jan 2015 23:46:22 -0600 [thread overview]
Message-ID: <20150128054622.GA25330@zorodyne.com> (raw)
I'm not sure where is the best place to ask this so, since I am using
LVM, I am asking here in the hope that someone can at least direct me to
the appropriate place to ask this. This is my first time setting up
LVM snapshots for mysql-zrm backups.
CentOS-6.6
MySQL-5.6.22
MySQL-zrm-3.0 (EPEL).
Short version:
I am unable to tell if the MySQL-zrm LVM snapshots are indeed taking
place, or if the backup is being taken directly from the main database
LVs. The log file info isn't giving me enough info to tell one way or
another.
Some more info:
I am setting up a database server with all of the database files on LVM
LVs and am using mysql-zrm for logical backups using LVM snapshots to
reduce the database lock times.
I have followed all of the various setup instructions very closely, and
am using the default "lvm-snapshot.pl" plugin. However, the only log
file lines mentioning snapshot are the following:
mysql:backup:INFO: Running snapshot verification using command /usr/share/mysql-zrm/plugins/lvm-snapshot.pl --action verify-config 2>/home/tmp/xH8KKpsF2O
There are no other log entries following this one that seem to have
anything to do with snapshots. There are no errors. The backups
succeed. Both "--verbose" and "--noquiet" are enabled.
Here are the salient entries from the mysql-zrm.conf file:
backup-level=0
backup-mode=logical
lvm-snapshot=20G
snapshot-plugin="/usr/share/mysql-zrm/plugins/lvm-snapshot.pl"
backup-type=regular
destination=/home/mysql-zrm
retention-policy=4W
compress=1
Any info or help would be much appreciated!
Thanks,
--Phil
--
Philip Amadeo Saeli
psaeli@zorodyne.com
next reply other threads:[~2015-01-28 5:46 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2015-01-28 5:46 Philip Amadeo Saeli [this message]
2015-01-28 10:39 ` [linux-lvm] LVM snapshot setup for mysql-zrm backups problem Marian Csontos
2015-01-29 0:18 ` Philip Amadeo Saeli
2015-01-29 15:37 ` Marian Csontos
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20150128054622.GA25330@zorodyne.com \
--to=psaeli@zorodyne.com \
--cc=linux-lvm@redhat.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).