[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: [linux-lvm] XFS_freeze and LVM


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,

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: [linux-lvm] XFS_freeze and LVM

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:

      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.??


      Service informatique
      Assistant informatique
      LIPPI Management La Fouillouse
      16440 Mouthiers sur Boheme
      Courriel: antony martineau lippi fr


      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
      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

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]