Find the answer to your Linux question:
Results 1 to 6 of 6
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    What happens if a hard disk runs out?


    If I'm hosting, eg. a MySQL db, and it fills up the HD, how do I add another server seamlessly? i.e. make sure the data spreads across more than 1 HD?


    Thanks.

  2. #2
    Linux Guru
    Join Date
    Dec 2013
    Location
    Victoria, B.C. Canada
    Posts
    2,103
    If you are using the inno_db engine it is as simple as adding another directory path to the variable innodb_data_file_path in you config file (and restarting the db).

  3. #3
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,667
    But be careful.
    For the ibdata file on the current harddisk you should set a maximum size (so it wont grow beyond that)
    However, if that file is currently set to autoextend, then I am not entirely sure how mysql reacts to that attribute change.

    aka: Be sure your backup and restore works
    You must always face the curtain with a bow.

  4. $spacer_open
    $spacer_close
  5. #4
    Quote Originally Posted by gregm View Post
    If you are using the inno_db engine it is as simple as adding another directory path to the variable innodb_data_file_path in you config file (and restarting the db).

    So.... it could be storing a particular record, half on one disk and half on another...? My Gosh, that's ULTRA cool! How does it do it? Is this kind of thing similar to LVM?

    Btw, has there been any improvement to this type of thing (feature I mean) since MySQL went MariaDB?

  6. #5
    Quote Originally Posted by Irithori View Post
    But be careful.
    For the ibdata file on the current harddisk you should set a maximum size (so it wont grow beyond that)
    However, if that file is currently set to autoextend, then I am not entirely sure how mysql reacts to that attribute change.

    aka: Be sure your backup and restore works
    What do you mean "it wont grow beyond that"? If there are more people signing up to my site, do you want me to tell them to go away?

    What is an "ibdata" file btw?

  7. #6
    Linux Engineer docbop's Avatar
    Join Date
    Nov 2009
    Location
    Woodshed, CA
    Posts
    949
    Quote Originally Posted by gregm View Post
    If you are using the inno_db engine it is as simple as adding another directory path to the variable innodb_data_file_path in you config file (and restarting the db).
    After being told you're now the DBA at my last gig, I liked a lot with MySQL was moving data to larger drives was so easy create the space, backup the config, mod the config, copy the files and stop and restart the DB. Plus there is so much MySQL documentation online. By time I left the gig had clustered MySQL databases running.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •