Thu 02 Apr 2009 09:57:57 AM GMT Agnislav Onufrijchuk wrote: > Hi all. > > I'm going to migrate our rt installation to latest version. We'll install > clean > RT on new hardware and them migrate DB and custom modifications. > > Some points about our rt installation: > - db size - more than 30G; > - mostly 100000 tickets; > - 4000 transactions per day. > > Can you please advice software for serving such high-loaded system: > - FreeBSD or Linux?
Slackware Linux. Perfect balance of security and stability and with a custom-generic kernel the RAM footprint is comparatively tiny and makes for a very responsive server. Whatever OS you choose, make sure you do a manual RT install, don't rely on someone's pre-packaged system. Also, I recommend making sure all of your perl modules are installed via CPAN not a packaging system to ensure no upstream modifications and a simple upgrade path. In Slackware both of the above are a given. > - File system: Ext3/XFS/JFS/...? Debatable. I would probably say Ext3 myself, but then for the level of transactions you're talking about you are on the border where J/X/Reiser could prove themselves useful. Wouldn't hurt to do some benchmarking. For what it's worth, don't take recoverability into account in your decision, just make backups. Trying to perform file-system data recovery in that type of environment is a waste of time on any FS. > - apache 2.2 or nginx? Apache. No Question. > - MySQL or Postgresql? Debatable. I think for me it would depend on what is in use in the rest of your architecture. If you are a fully MySQL house, as we are here, then it makes sense to keep it all the same since you can share primary/failover servers and your people-processes are harmonious. If you don't really have a dependency on either then... well it's up to you. I'm used to MySQL and having it at the core of nearly all DB-dependant applications here has been useful, but many would argue that for a larger system like yours PG wouyld give you better performance. Again, a bit of benchmarking wouldn't go amiss. -- Kind Regards, __________________________________________________ Mike Peachey, IT Tel: +44 114 281 2655 Fax: +44 114 281 2951 Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK Comp Reg No: 3191371 - Registered In England http://www.jennic.com __________________________________________________ _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
