LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 11-28-2008, 10:15 AM   #1
edenCC
Member
 
Registered: May 2006
Location: China
Distribution: Debian
Posts: 198
Blog Entries: 1

Rep: Reputation: 32
snapshot on LVM: reserved volume size for changes


Hi, ALL,

I just tried to use LVM snapshot to backup my INNODB databases.

My database is about 200GB in size, and the query is really heavy.
Each of my innodb data files are of 2GB, that means there about 100 data files in total.

As mentioned, I tried to snapshot these 200GB data, and then copy them away in 2 hours.

So my question is:
As for your experience, how much volume should I reserve for the changes that would happen in the following 2 hours?

(Hope I'm clear enough on my question.)
Thanks & Regards

Joseph
 
Old 11-28-2008, 08:17 PM   #2
edenCC
Member
 
Registered: May 2006
Location: China
Distribution: Debian
Posts: 198

Original Poster
Blog Entries: 1

Rep: Reputation: 32
I got this link from a careful google search:

http://www.mysqlperformanceblog.com/...-lvm-snapshot/

It meets m issue quite well!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Fedora LVM volume group & Physical Volume resize problem gabeyg Fedora 1 05-14-2008 11:26 AM
About LVM Snapshot geethusari LinuxQuestions.org Member Intro 1 12-03-2007 07:11 AM
LVM: The Impact of Reducing a Logical Volume Size? muff Linux - General 0 07-27-2007 02:18 AM
LVM Snapshot question sjtushi Linux - Software 3 03-12-2006 09:41 AM
LVM snapshot creation error haertig Linux - Software 1 01-30-2006 09:14 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:09 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration