LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-17-2010, 08:58 PM   #1
albie17
Member
 
Registered: Jul 2010
Location: District 9
Distribution: OpenSuse, Fedora, CentOS, Ubuntu, RHEL
Posts: 31

Rep: Reputation: 0
How to Partition Apache and MySQL Database (IBM X3650 M3 6x300GB SAS)


Hi there LQ peeps,
Can someone help me on how to configure a web/database server.
Given:
IBM x3650 M3 with 6 x 300GB SAS and 16GB RAM
CentOS 5.5 (LAMP)
Software RAID with LVM haven't tried hardware RAID.

Here's the task:
Task 1. 3x300GB SAS will goes to /boot, /root, /var* and swap (RAID1 for /boot and RAID5 for the rest with LVM).
Task 2. 3x300GB SAS will goes to MySQL Database (RAID5 and LVM).
* My web content will be stored here. (/var/www/html)

I know how to perform Task 1, but I'm not familiar with Task 2. So how it can be done?
What specific directory should i used to store my database?

Best Regards

Last edited by albie17; 12-17-2010 at 09:37 PM.
 
Old 12-17-2010, 11:10 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,066
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Quote:
Hi there LQ peeps,
Can someone help me on how to configure a web/database server.
Given:
IBM x3650 M3 with 6 x 300GB SAS and 16GB RAM
CentOS 5.5 (LAMP)
Software RAID with LVM haven't tried hardware RAID.

Here's the task:
Task 1. 3x300GB SAS will goes to /boot, /root, /var* and swap (RAID1 for /boot and RAID5 for the rest with LVM).
Task 2. 3x300GB SAS will goes to MySQL Database (RAID5 and LVM).
* My web content will be stored here. (/var/www/html)

I know how to perform Task 1, but I'm not familiar with Task 2. So how it can be done?
What specific directory should i used to store my database?

Best Regards
Just a generic word of advice: for most RDBMS work-loads RAID5
is considered too slow. It's OK for read-mostly work-loads, but
once you start writing, or have concurrent read-writes you won't
be too happy.

And what metrics did you use to come up w/ that sizing?



Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Apache Connection to MySQL Database archerofthemoon Linux - Server 13 07-29-2010 03:54 PM
Can't change resolution on SUSE 10.2 IBM x3650 MoschopsUK Linux - Newbie 3 04-08-2008 08:58 PM
Fresh Install - Will Not Boot, OpenSUSE 10.2 on IBM System x3650 MoschopsUK Linux - Newbie 6 04-03-2008 03:42 AM
apache + mod_vhs [directives from database (mysql)?] nichu Linux - General 0 02-04-2008 05:43 AM
LXer: IBM, MySQL team up on database software LXer Syndicated Linux News 0 04-25-2007 03:16 PM


All times are GMT -5. The time now is 01:24 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration