Help: Partitioning.. 2 scsi.. mysql?

[NetFXMedia]

What do you recommend for partitioning with mysql over 2 10k SCSI drives on RedHat Linux.

Should Mysql go on the second harddrive alone? Or..

Should All OS files go on Harddrive 1, and website files and mysql go on Harddrive 2.

Or what do you suggest?


How should I partition it?

[Dave#]

Originally posted by NetFXMedia
What do you recommend for partitioning with mysql over 2 10k SCSI drives on RedHat Linux.

Should Mysql go on the second harddrive alone? Or..

Should All OS files go on Harddrive 1, and website files and mysql go on Harddrive 2.

Or what do you suggest?


How should I partition it?

Mysql data files on the second disk would be preferable -

[NetFXMedia]

Where are mysql datafiles kept?

Should I Raid 1 them?

Both harddrives are 9.6gb.

[eva2000]

Originally posted by NetFXMedia
What do you recommend for partitioning with mysql over 2 10k SCSI drives on RedHat Linux.

Should Mysql go on the second harddrive alone? Or..

Should All OS files go on Harddrive 1, and website files and mysql go on Harddrive 2.

Or what do you suggest?


How should I partition it? depends on how larger your database is to justify a 2nd disk

but yes it's preferrable to have mysql data residing on it's own disk

you can when you install mysql specify a custom path to where mysql data files are stored or you can change it in /etc/my.cnf

i.e. under

[mysqld]
datadir=/var/lib/mysql


where datadir is the path to where mysql is

on my new server i have

Dual AthlonMP 2000+
2GB ECC PC2100 DDRAM
2 x 18GB SCSI
1 x 80GB EIDE

where the 2nd drive is dedicated to the /var partition where mysql resides

i did this first because my databases occupy several gigs of space and growing but also for performance reasons :)