The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by DWHS.net, Sep 16, 2005.

  1. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    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
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    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.
     
  3. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Oh so would format one and symlink the others to it?
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    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.
     
  5. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    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.
     
  6. jester.ro

    jester.ro Well-Known Member
    PartnerNOC

    Joined:
    Feb 6, 2004
    Messages:
    304
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bucharest, Romania
    cPanel Access Level:
    DataCenter Provider
    for this purpose, i would just create a
    /tmp partition (very small, 500 mb)
    /boot - 200 mb
    swap (twice the ram)
    / - the rest
     
  7. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    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
     
  8. pshepperd

    pshepperd Well-Known Member

    Joined:
    Feb 12, 2005
    Messages:
    147
    Likes Received:
    0
    Trophy Points:
    16
    My choice for you would be this aproximatly

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

    jester.ro Well-Known Member
    PartnerNOC

    Joined:
    Feb 6, 2004
    Messages:
    304
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bucharest, Romania
    cPanel Access Level:
    DataCenter Provider
    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.
     
Loading...

Share This Page