Advice wanted for a production OTRS ubuntu install

Moderator: crythias

Locked
Romaing
Znuny newbie
Posts: 60
Joined: 30 Mar 2012, 15:20
Znuny Version: 3.1.5

Advice wanted for a production OTRS ubuntu install

Post by Romaing »

Hello everyone, (by the way, please excuse my english as it's not my native language^^)

i wanted to discuss what good practice should be used for an install of OTRS 3.13 to be done in May of this year :)

First, would you recommend the use of ubuntu 12.04 or stay on 10.04 if you were to do a proper production install of OTRS in May of this year ?
I'm guessing some of you must have tried to install otrs 3.13 on the lastest 12.04 beta, is it better ?


Second point, i've read the hardware and software requirements: http://doc.otrs.org/3.1/en/html/softwar ... ments.html
But what about disk partitionnement ?
For OTRS, is there better practices than other ?

If you were to install OTRS for about a hundred employees as users and about 5 people working as agents, with maybe 20 tickets created everyday, how quickly will the database grow ? (Bear in mind, there will never be any ticket deleted, they'll stay forever). How much hard disk space should be used ? I know on vmware you can expand har disk size but still that's the kind of info i'm looking for.

Hope you'll have some info to share, thanks in advance.

Best regards,
Romain
OTRS 3.1.5 on Ubuntu 12.04
Database: MySQL
Module: FAQ
Romaing
Znuny newbie
Posts: 60
Joined: 30 Mar 2012, 15:20
Znuny Version: 3.1.5

Re: Advice wanted for a production OTRS ubuntu install

Post by Romaing »

Weird, i would have thought many people would have liked to share their personal experience or to give good advices on the DOs and DON'Ts of a otrs install... :-|
OTRS 3.1.5 on Ubuntu 12.04
Database: MySQL
Module: FAQ
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Advice wanted for a production OTRS ubuntu install

Post by crythias »

OS won't matter for performance. Don't worry about that. (maybe. Consider it negligible all other things (ram, hd, 32 bit vs 64bit) considered)Also, consider that the latest released version of an OS could be better able to handle system patches for a longer period of time than the "stable" version you might consider. Check the End of Life support for more information. What you don't want to do is to install something "stable" that "works" but you have to rip and replace the OS when you're ready/forced to upgrade because the patches for the OS aren't there any more.

From what I've encountered, though, I just upgraded through natty to the latest version of Ubuntu on my (crappy, home, non-production) system and aside from a small tweak in apache, I was back in action. (hours of upgrade of OS notwithstanding). Even upgrade MySQL 5.1 to 5.5 seemed to be okay.

Without attachments, your database will grow relatively slowly. With attachments, and if your db handles attachments in database instead of File System, your db could grow quite large. How large? depends, of course, on attachments and how many, but in your smaller (?) environment, you might reach 1gb in a year or 2.

The VM (virtual box) I had distributed for 3.0.10 was less than 2GB including OS. You should consider installing the server version of your OS of choice instead of the desktop version. You don't want or need, necessarily, X-windows/Gnome/wobbly windows, Open Office, games, etc.

How much hard drive space? Again, depends on attachments. For your environment, I would say you could start and be happy with 20gb for quite a while.

Another option I'd consider suggesting is installing automysqlbackup which does replicate your mysql backup, but it enables you to have monthly, weekly, daily backups of mysql with little effort. You'll probably still be okay with 20gb, but 50gb may be more breathing room.

Hope this helps. More RAM is better, but for your usage, whatever you throw at it will probably be adequate. Back up early, often, and maybe throw Nagios on your system to monitor everything.

Your results may vary. Your specific needs may exceed examples expressed here. Don't rely on this example as typical or even legitimate. Whatever you think is needed, more is okay, and probably cheap enough.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Romaing
Znuny newbie
Posts: 60
Joined: 30 Mar 2012, 15:20
Znuny Version: 3.1.5

Re: Advice wanted for a production OTRS ubuntu install

Post by Romaing »

Big thanks for your detailed answer. Very useful :)

We'll go the ubuntu 12.04 install, also tried it myself and everything seems OK although i was disappointed that an apt-get install couldn't do the job properly, and that i still had to go the same way as the 10.04 install.

For the attachments, it's planned to delete them periodically so i guess that won't be a problem.
OTRS 3.1.5 on Ubuntu 12.04
Database: MySQL
Module: FAQ
Locked