[rt-users] What software is recommended for high-loaded RT3.8-latest?

Agnislav Onufrijchuk Agnislav.Onufrijchuk at portaone.com
Thu Apr 2 09:58:34 EDT 2009


Kenneth Marshall wrote:
> Are these 4000 tickets per day or 4000 updates total? 100000 tickets
> is not very many if you actually generate 4000 tickets per day. Do
> you "shred" old tickets to remove them from your DB?
> 
4000 Transactions, not tickets per day.

>> - File system: Ext3/XFS/JFS/...?
> Use the supported/recommended one for your chosen OS.
> 
Even if I'll choose FreeBSD, I will not use UFS :)  It's too slow.

>> - apache 2.2 or nginx?
> Apache all the way.
> 
What advantages does it have?

>> - MySQL or Postgresql?
> We use PostgreSQL here because the release quality does not vary
> as wildly and MySQL. Check the mailing list for problems caused by
> particular versions of MySQL. If you pick a tested version, it will
> work well. PostgreSQL also support full text index support that make
> searching ticket body content extremely fast. We also use the Slony
> replication software to keep a warm spare RT system ready to go, in
> case the primary system has a hardware problem. We really want to
> have redundancy in our ticket system because it should be up even if
> everything else is down. :)
> 
FTS - is one of the advantages of PostgreSQL we look for.

Thank you for help!

-- 
Agnislav Onufrijchuk
PortaOne, Inc., RT Developer
Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670

   Meet us on April 14-15 at Booth 1202
   Billing & OSS World Conference & Expo
   Rio All-Suite Hotel & Casino, Las Vegas



More information about the rt-users mailing list