Re: selected debian questions: raid & performance tips

2010-01-29 Thread Dino Vliet


--- On Wed, 1/27/10, Johannes Wiedersich  
wrote:


From: Johannes Wiedersich 
Subject: Re: selected debian questions: raid & performance tips
To: debian-user@lists.debian.org
Date: Wednesday, January 27, 2010, 11:59 PM


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dino Vliet wrote:
> Questions
> 
> 1) Can you show me the definitive debian lenny guide to create a
> software RAID-1 array from within the debian installer (I searched
> with google but wasn't that sucessfull and the manual is brief) The
> OS and data will be on the same disks as I don't have a spare OS
> disks only.

The "Debian GNU/Linux Installation Guide" [1] has always been sufficient
for my needs. You should get help from reading the section about
partitioning.

[1] http://www.debian.org/releases/stable/i386/ch06s03.html.en#di-partition

> 2) What OS tweaks do you advice, with my current setup plan (custom 
> kernel, setting values, other filesystems like ext2)?

None. You should be essentially fine with ext3 and the debian kernel for
your demonstration purposes. You might get a better performance by
tweaking, but for a proof of concept, I'd think that is overkill. YMMV.

- --
Johannes

Three nations have not officially adopted the International System
of Units as their primary or sole system of measurement: Burma,
Liberia, and the United States.

http://en.wikipedia.org/wiki/Si_units
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAktgxVIACgkQC1NzPRl9qEWh4gCeMqUEUr4XOvdiOYDZgRnO+ODO
FTEAnRckH0VK9ISqwwJfKHSKhtDLXZ7Y
=GvDJ
-END PGP SIGNATURE-


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Thanks!!
 
This was exactly what I need.
 
Are you sureb about ext3 though? I thought that ext2 would give better results 
on postgresql because I have raid and the database is ACID compliant.
 
Dino



  

Re: selected debian questions: raid & performance tips

2010-01-27 Thread Johannes Wiedersich
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dino Vliet wrote:
> Questions
> 
> 1) Can you show me the definitive debian lenny guide to create a
> software RAID-1 array from within the debian installer (I searched
> with google but wasn't that sucessfull and the manual is brief) The
> OS and data will be on the same disks as I don't have a spare OS
> disks only.

The "Debian GNU/Linux Installation Guide" [1] has always been sufficient
for my needs. You should get help from reading the section about
partitioning.

[1] http://www.debian.org/releases/stable/i386/ch06s03.html.en#di-partition

> 2) What OS tweaks do you advice, with my current setup plan (custom 
> kernel, setting values, other filesystems like ext2)?

None. You should be essentially fine with ext3 and the debian kernel for
your demonstration purposes. You might get a better performance by
tweaking, but for a proof of concept, I'd think that is overkill. YMMV.

- --
Johannes

Three nations have not officially adopted the International System
of Units as their primary or sole system of measurement: Burma,
Liberia, and the United States.

http://en.wikipedia.org/wiki/Si_units
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAktgxVIACgkQC1NzPRl9qEWh4gCeMqUEUr4XOvdiOYDZgRnO+ODO
FTEAnRckH0VK9ISqwwJfKHSKhtDLXZ7Y
=GvDJ
-END PGP SIGNATURE-


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org



selected debian questions: raid & performance tips

2010-01-27 Thread Dino Vliet

Dear debian people,
 
I need to configure a application/database server to proof the potential of 
open source business intelligence. I want to use a ETL tool like the java based 
Talend or Pentaho Kettle or maybe the unix tools awk, sed, perl to transform 25 
million records into 10 million records and loading them into a postgresql 
database server. Then I will use the java based Pentaho Report Designer to let 
users create reports or give the (power) users a query tool like pgadmin3 to 
access the database.
 
To design for maximum performance I've decided on the JFS or XFS filesystem, a 
raid 1 configuration where the OS en DATA will be on the same disks. 
 
The hardware will be a workstation:
 
1 single-core 64 bit's CPU
2 SATA-II harddrives
 
Of course, the OS i've chosen will be Debian Lenny (stability, speed, apt-get, 
helpfull mailing list etc etc, the usual:-)
 
Questions
1) Can you show me the definitive debian lenny guide to create a software 
RAID-1 array from within the debian installer (I searched with google but 
wasn't that sucessfull and the manual is brief) The OS and data will be on the 
same disks as I don't have a spare OS disks only.
 
2) What OS tweaks do you advice, with my current setup plan (custom kernel, 
setting values, other filesystems like ext2)?
 
Thanks in advanced,
 
Dino