MySQL Forums
Forum List  »  Backup

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4033
March 08, 2006 10:41PM
Re: MySQL on readonly LVM snapshot fs
2480
April 11, 2006 11:36PM


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.