Spreading MYSQL database over couple hard drives

Discussion in 'MySQL' started by deriklogov, Oct 25, 2010.

0
  1. #1
    I know that its possible to spread MYSQL databases over couple hard drives if you storing database folders over different hard drives and creating symbolic links to /var/lib/mysql/databasename

    but how safe is that over time ?
     
    deriklogov, Oct 25, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    Use hardware raid1 instead of any software solutions
     
    netload, Oct 28, 2010 IP
  3. cDc

    cDc Peon

    Messages:
    127
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    look into mysql partitioning - you can elect to store data on different physical drives and improve performance
     
    cDc, Dec 17, 2010 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    What do you want to achieve from it? Performance or something else?
     
    mwasif, Dec 20, 2010 IP