New Server, Two Drives, How to Mysql on one

[CrashdownGurl]

I just bought another server and this one has two 73 gig disks on it, I wanted to use mysql on one of the disks, and then put everything else on the other disk. I've heard this is a smart thing to do if you run a very high trafficed vbulletin board with multiple sites that all pull from that database, which I do. I figured my best option would be keeping one disk for mysql. Would this be a good idea?

If so, how do I go about putting just mysql on one drive and keeping everything else off of it?

Emma

[Alan @ CIT]

You don't mention whether your running on Linux or Windows, but the principle is the same either way.

Linux: Partition the 2nd drive as 1 big partition, and then use the mount tool to mount it to somewhere like /mysql. Once this is done, install MySQL to the /mysql directory (in essence, the 2nd drive), and be sure no to install anything else to it. You need to make sure when installing MySQL that it stores all it's DB's, etc on the new /mysql directory (check the mysql mannual for details of this).

Windows: As above - just give the 2nd harddrive a new drive letter (eg, M:), then install MySQL to this drive.

Many thanks,
Alan.

[Erwin]

If mysql is already installed, you can move the var/lib/mysql directory to the 2nd drive, do a symlink, and then chown so that mysql owns the moved directory, and make the appropriate changes in my.cnf to point to the new directory.