[CentOS] Seeking pointers to info about LVM migration and performance

2007-07-06 Thread Bart Schaefer
We have a large MySQL database currently running on a CentOS 3.x server with an external SCSI RAID device. This is currently an ext2 filesystem because it was migrated once previously from an even older RedHat system. We need to add storage capacity to this database and prepare for additional fu

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-06 Thread John R Pierce
Bart Schaefer wrote: We have a large MySQL database currently running on a CentOS 3.x server with an external SCSI RAID device. This is currently an ext2 filesystem because it was migrated once previously from an even older RedHat system. umount /dev/sdb1 tunefs -j /dev/sdb1 vi /etc/fstab(

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-07 Thread Johnny Hughes
Bart Schaefer wrote: > We have a large MySQL database currently running on a CentOS 3.x > server with an external SCSI RAID device. This is currently an ext2 > filesystem because it was migrated once previously from an even older > RedHat system. We need to add storage capacity to this database a

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread Bart Schaefer
On 7/6/07, John R Pierce <[EMAIL PROTECTED]> wrote: umount /dev/sdb1 tunefs -j /dev/sdb1 vi /etc/fstab(and, change ext2 to ext3 on the mount line for this filesystem) mount /dev/sdb1 and voila, its EXT3 now, with journalling. Thanks, John, but is that really the whole answer? Once it's

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread John R Pierce
Bart Schaefer wrote: Thanks, John, but is that really the whole answer? Once it's ext3 it can be put into a volume group with no further ado? I would think that (particularly with a striped LVM such as Johnny mentioned) there has to be something else invovled. the file system and the volume m

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread Johnny Hughes
Bart Schaefer wrote: > On 7/6/07, John R Pierce <[EMAIL PROTECTED]> wrote: >> >> umount /dev/sdb1 >> tunefs -j /dev/sdb1 >> vi /etc/fstab(and, change ext2 to ext3 on the mount line for this >> filesystem) >> mount /dev/sdb1 >> >> >> and voila, its EXT3 now, with journalling. > > Thanks, John,

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread Bart Schaefer
On 7/8/07, Bart Schaefer <[EMAIL PROTECTED]> wrote: On 7/6/07, John R Pierce <[EMAIL PROTECTED]> wrote: > > and voila, its EXT3 now, with journalling. Thanks, John, but is that really the whole answer? Once it's ext3 it can be put into a volume group with no further ado? I should have read th

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread Bart Schaefer
On 7/7/07, Johnny Hughes <[EMAIL PROTECTED]> wrote: Bart Schaefer wrote: > - What kind of performance can we expect from an LVM group as compared > to mounting the RAID array directly? OK, the answer to this question is ... RAID and LVM can be used together, or individually. Thanks for confir

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread Johnny Hughes
Bart Schaefer wrote: > On 7/7/07, Johnny Hughes <[EMAIL PROTECTED]> wrote: >> Bart Schaefer wrote: >> > - What kind of performance can we expect from an LVM group as compared >> > to mounting the RAID array directly? >> >> OK, the answer to this question is ... >> >> RAID and LVM can be used togeth

Re: [CentOS] Seeking pointers to info about LVM migration and performance

2007-07-08 Thread Bart Schaefer
On 7/8/07, Johnny Hughes <[EMAIL PROTECTED]> wrote: Well ... if you are using hardware RAID, then striping LVM will likely not give you any benefit speed wise. (Unless multiple controllers are used and read/write can be done in parallel). The speed benefit happens if LVM can stripe the sectors