Running mySQL on second drive

[NickFritz]

Is it possible to run MySQL on a second drive to speed up the hard drive problem?

so mysql on the second drive and apache on the first drive?

 

[nobaloney]

Yes, with symlinked directories.

Of course if you're using Linux software RAID the kernel should be able to use different drives for successive reads to spead things up and you get the other advantages of RAID as well.

Jeff

 

[NickFritz]

Ok i fdisk -l and this is what i get.

fdisk -l

Disk /dev/sda: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14         144     1052257+  82  Linux swap
/dev/sda3             145       19457   155131672+  83  Linux

Disk /dev/sdb: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System

Does this mean the second drive isnt even partitioned?

How do i go about making the second drive active for mysql running off of it

 

[NickFritz]

No problem, i got it partitioned