Hi,
IIRC sometime around 2005 developments in LVM meant that using xfs_freeze
before creating a snapshot became the wrong thing to do. See the entry in
the changelog for revision 0.15 of the LVM how-to at
http://tldp.org/HOWTO/LVM-HOWTO/ . You will probably find that authoritative
recommendations to use xfs_freeze relate to versions of LVM from before this
time. (Please correct me if I am wrong about this, someone.)
Also bear in mind that filesystem transactions do not correspond to database
(i.e. MySQL) transactions. To get a reliable backup using a snapshot you may
need to allow uncommitted database transactions to complete or roll back
while preventing new ones from being started, then take the snapshot. Oracle
has a way of doing this that doesn't need the database to be completely shut
down, but I have no experience with MySQL so I can't be more specific.
Good luck,
Peter.
On Thu, 27 Nov 2008, Falko Zurell wrote:
Date: Thu, 27 Nov 2008 09:54:14 +0100
From: Falko Zurell <falko.zurell@idmedia.com>
Reply-To: LVM general discussion and development <linux-lvm@redhat.com>
To: LVM general discussion and development <linux-lvm@redhat.com>
Subject: Re: XFS_freeze and LVM
Hi,
are your LVM tools on the freezed file system? Is this the / partition you are
freezing? Bad idea ;-)
kind regards
Am 27.11.2008 um 09:48 schrieb Antony MARTINEAU:
Hello,
I want using LVM 2 and Mysql
So i have mounted /var/lib/mysql on /dev/vg0/mysql.
For doing a backup i want do
xfs_freeze -f /var/lib/mysql
and after : lvcreate --snapshot -n snap -L1G /dev/vg0/mysql.
But the problem is when i freeze xfs filesystem i can't use lvm commands...
When i unfreeze xfs lvm commands are available...
Do you know the problem?? is it a bug.??
Cordialement,
<ATT54517403.gif>
MARTINEAU
Antony
Service informatique
Assistant informatique
LIPPI Management La Fouillouse
16440 Mouthiers sur Boheme
Tel.: 05.45.67.34.35
Courriel: antony.martineau@lippi.fr
http://www.lippi.fr
[eco.jpg]
Ce message et toutes les pieces jointes sont etablis a l'attention
exclusive de ses destinataires et sont strictement confidentiels. Pour en
savoir plus cliquer ici
This message and any attachments are confidential to the ordinary user of
the e-mail address to which it was addressed and may also be privileged.
More information
_______________________________________________
linux-lvm mailing list
linux-lvm@redhat.com
https://www.redhat.com/mailman/listinfo/linux-lvm
read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/
Falko Zurell
Head of Application Management
/i-d media AG
Ohlauer Straße 43
D-10999 Berlin
--
Peter Keller Tel.: +44 (0)1223 353033
Global Phasing Ltd., Fax.: +44 (0)1223 366889
Sheraton House,
Castle Park,
Cambridge CB3 0AX
United Kingdom
_______________________________________________
linux-lvm mailing list
linux-lvm@redhat.com
https://www.redhat.com/mailman/listinfo/linux-lvm
read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/
