Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

MySQL database disk repartition on Linux

Hello,

I have 30 disks of 2,8GB each. i'm looking to handle a big database on Linux using all of these disks. (40GB)
Is there a way to tell mysql to use an unique database spreaded on all of these disks ?

Thanks for your help.
0
weberpal
Asked:
weberpal
  • 5
  • 2
1 Solution
 
drittichCommented:
Go here:

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

and read up on the RAID_TYPE option.  You spread out individual tables on the disk, rather than just specifying the whole database.  This gives you finer granularity of control.
0
 
weberpalAuthor Commented:
Ok, i understand. this is a possibility. But my first purpose is to tell mySql to handle itself the wole database on these disks ? Any other suggestions ?  
0
 
weberpalAuthor Commented:
Ok, i understand. this is a possibility. But my first purpose is to tell mySql to handle itself the wole database on these disks ? Any other suggestions ?  
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
drittichCommented:
Well, the other suggestion is to use a hardware or software RAID disk configuration dedicated to the database. E.g., buy a RAID SCSI controller.  Or use the software RAID built in to Windows NT or Linux, or whatever you are runnning.
0
 
weberpalAuthor Commented:
Thanks. I discover another idea to do that using LVM.
0
 
weberpalAuthor Commented:
Thanks. I discover another idea to do that using LVM.
0
 
weberpalAuthor Commented:
Thanks. I discover another idea to do that using LVM.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now