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.
weberpalAsked:
Who is Participating?
 
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
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.