• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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