Re: MySQl and LVM

2008-12-02 Thread Shain Miley
Simon, Thanks for the info, that is very useful. I still have a few questions though...I am considering setting up a 200GB LVM partition for the mysql data and a 70 GB LVM partition for the snapshots. Am I able to store several snapshots on the 70 GB partition? or do I need to take one

MySQl and LVM

2008-12-01 Thread Shain Miley
Hello, I am trying to plan we in advance our methods for backup and recovery of our new MySQL replication cluster. After doing some research it looks like a lot of people are using LVM snapshots as their backup solution. We currently have two MySQL servers with 2 300 GB (Raid 1). What I

Re: MySQl and LVM

2008-12-01 Thread Simon J Mudd
[EMAIL PROTECTED] (Shain Miley) writes: I am trying to plan we in advance our methods for backup and recovery of our new MySQL replication cluster. After doing some research it looks like a lot of people are using LVM snapshots as their backup solution. We currently have two MySQL servers