LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 03-03-2003, 01:44 PM   #1
cstovall
LQ Newbie
 
Registered: Feb 2003
Posts: 8

Rep: Reputation: 0
Is this the correct partition strategy for a database?


Installing Linux 7.2 for an Informix database.

I have installed Linux 7.2 on a IBM xseries 235 server. The server
has 5 scsi hard drives and uses a raid hardware controller.

I have set up raid 5 with 3 of the hard drives and raid 1 with the other 2.

All applications will be on the raid 5 array (sda). The database will
be on the raid1 array(sdb). Here is my partiton strategy.

sda1 100M /boot
sda2 10000M /
sda3 10000M /var
sda4 49000M extended
sda5 27000M /usr
sda6 2000M swap
sda7 10000M /datalog

The"/datalog partition" is for the database log files.



sdb1 17300M /opt

sdb1 is for the database.

How does this setup look? Any suggetions?
 
Old 03-03-2003, 03:04 PM   #2
cnjohnson
Member
 
Registered: Nov 2002
Location: Nashville
Distribution: FreeBSD, Linux, OS-X
Posts: 544

Rep: Reputation: 30
Re: Is this the correct partition strategy for a database?

Quote:
Originally posted by cstovall
Installing Linux 7.2 for an Informix database.

I have installed Linux 7.2 on a IBM xseries 235 server. The server
has 5 scsi hard drives and uses a raid hardware controller.

I have set up raid 5 with 3 of the hard drives and raid 1 with the other 2.

All applications will be on the raid 5 array (sda). The database will
be on the raid1 array(sdb). Here is my partiton strategy.

sda1 100M /boot
sda2 10000M /
sda3 10000M /var
sda4 49000M extended
sda5 27000M /usr
sda6 2000M swap
sda7 10000M /datalog

The"/datalog partition" is for the database log files.



sdb1 17300M /opt

sdb1 is for the database.

How does this setup look? Any suggetions?
Where will /home go, and how many users will you have? You will commit 17.3 gig to the database, and 10gig to the logs. That seems like a lot of space for the log files. We use 100 logs, with each 1 meg. We use continuous logging to tape. Of course, if you have lots of long transactions your needs can be vastly higher than ours. Looks good to me, otherwise.

Cheers--
Charles
 
  


Reply



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 On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Correct partition decision? web250 Linux - General 3 09-20-2005 11:31 PM
Partition strategy for 120 Gb ext. drive oomfoofoo Linux - General 4 08-26-2005 01:09 PM
What is the correct way of partition/format extra hard drives? ExCIA Linux - Newbie 6 05-01-2005 03:33 PM
Making Correct Partition ciyan Linux - Newbie 5 02-21-2005 06:45 AM
Partitionning strategy Dweezil Linux - Software 3 04-25-2001 10:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 03:40 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
Open Source Consulting | Domain Registration