MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: MySQL on readonly LVM snapshot fs
Posted by: Thomas Weeks
Date: April 11, 2006 11:36PM

You don't need to leave it read only... Snapshots just take a second. What filesystem are you using? Here's how to do it in XFS:
http://xcssa.org/files/MYSQLBACKUPS/img23.html

I did an article on this in this months' Sys-Admin magazine...
"Production MySQL Backups in the Enterprise: Part I"
http://www.samag.com/articles/2006/0605/

The June issue will have Part-II where more of the specifics are covered.

Tweeks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL on readonly LVM snapshot fs
4033
Rob Ostrander
March 08, 2006 10:41PM
Re: MySQL on readonly LVM snapshot fs
2480
Thomas Weeks
April 11, 2006 11:36PM
Re: MySQL on readonly LVM snapshot fs
3086
Rob Ostrander
April 28, 2006 10:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.