remote mysql server with a 18 gig hard drive, is this a reasonable format?

[WebHostPro]

I need to run a remote mysql server for about 500-1000 small data bases. (.3-.5 megs each)

The remote server only uses a 18 gig hard drive.

my disk set up is:

/boot --100
/usr ----8000
/var ----5000
/home -1000
/tmp ---1000
/swap --1000

Just your opinion please on the format a mysql only back end server will need?

I will do remote back ups through cpanel on the server daily so it might need some space moved around for that.

Thanks for the help.

Chaze

 

[chirpy]

Looks OK. You could just as easily have /var /usr and /home on the same partition if you wanted to so you don't have to worry about space issues.

 

[WebHostPro]

Oh so would format one and symlink the others to it?

 

[chirpy]

My mistake, I thought you were looking at a prospective partition scheme, not an existing one. Since it is already setup, I'd just go with it, it should be fine.

 

[WebHostPro]

Actually your right I have not set it up yet.

So you think:

/boot --100
/usr ----5350
/var ----5350
/home -5350
/tmp ---1000
/swap --1000

migh be better?

The home partition will get used some?

Thanks again for your input.

 

[jester.ro]

for this purpose, i would just create a
/tmp partition (very small, 500 mb)
/boot - 200 mb
swap (twice the ram)
/ - the rest

 

[dave9000]

for this purpose, i would just create a
/tmp partition (very small, 500 mb)
/boot - 200 mb
swap (twice the ram)
/ - the rest

except we make /boot 100meg and /tmp 1gig this is how we setup all our boxes then you never have to worry about running out of space on any single partition you just have to worry about running out of disk space

 

[pshepperd]

My choice for you would be this aproximatly

/boot --100
/usr ----2300
/var ----1500
/home -the rest goes here
/tmp ---500
/swap --600

 

[jester.ro]

from what i understood this server will be only a mysql server.

there's no reason in setting that much space to /home

mysql goes to /var, that's where he needs space.

and i chose a small partition fro /tmp oly because mysql doesn't need acces to tmp, so there's no reason in increasing that too much.