Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySQL database disk repartition on Linux

Posted on 2001-07-03
7
Medium Priority
?
388 Views
Last Modified: 2006-11-17
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
Comment
Question by:weberpal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 8

Accepted Solution

by:
drittich earned 300 total points
ID: 6250987
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
 

Author Comment

by:weberpal
ID: 6254577
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
 

Author Comment

by:weberpal
ID: 6254689
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 8

Expert Comment

by:drittich
ID: 6256444
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
 

Author Comment

by:weberpal
ID: 6276805
Thanks. I discover another idea to do that using LVM.
0
 

Author Comment

by:weberpal
ID: 6276809
Thanks. I discover another idea to do that using LVM.
0
 

Author Comment

by:weberpal
ID: 6276814
Thanks. I discover another idea to do that using LVM.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What we learned in Webroot's webinar on multi-vector protection.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question