Which DB should I use? Mysql, PostgreSQL or Oracle?
Hi! I'm in a project where we are going to install an OTRS to a huge university here in Rio de Janeiro (Brazil). They are expecting about 5,000 tickets per day. I don't if this is a lot of information for a MySql installation, so I have this question: Is a MySql installation a good choose for us? Or should I consider another DB for this project? Why some people prefer to choose PostgreSQL or Oracle sometimes? Thanks!! Ronaldo Richieri Brazil +55 15 8818-2009
Hi Ronaldo, it's not really a developer question, but anyway. ;) My personal feedback is MySQL, because I already saw really fast installations with about 20k ticket a day. MySQL is lacking some enterprise features this makes the database really fast. One more info, if you have so many tickets a day, you should think about to use the file system storage for attachments. So backup and restore of your database (in case of 200GB :-D ) this will be easier (about 90% of the database size are attachments of email or notes). I also recommend you the OTRS Support addon, which shows you several system checks depending you your system (also performance tips, recommended settings, ... ). Just install it over the package manager in the admin interface from ftp.otrs.org. Greetings to Brazil! ;) -Martin On Apr 6, 2009, at 17:59 , Ronaldo Richieri wrote:
Hi!
I'm in a project where we are going to install an OTRS to a huge university here in Rio de Janeiro (Brazil).
They are expecting about 5,000 tickets per day. I don't if this is a lot of information for a MySql installation, so I have this question:
Is a MySql installation a good choose for us? Or should I consider another DB for this project?
Why some people prefer to choose PostgreSQL or Oracle sometimes?
Thanks!!
Ronaldo Richieri Brazil +55 15 8818-2009 --------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Martin, thanks!!!
How about the table type. Are you using MyIsam or InnoDB?
Thanks again,
Ronaldo
On Mon, Apr 6, 2009 at 1:23 PM, Martin Edenhofer
Hi Ronaldo,
it's not really a developer question, but anyway. ;)
My personal feedback is MySQL, because I already saw really fast installations with about 20k ticket a day. MySQL is lacking some enterprise features this makes the database really fast.
One more info, if you have so many tickets a day, you should think about to use the file system storage for attachments. So backup and restore of your database (in case of 200GB :-D ) this will be easier (about 90% of the database size are attachments of email or notes).
I also recommend you the OTRS Support addon, which shows you several system checks depending you your system (also performance tips, recommended settings, ... ). Just install it over the package manager in the admin interface from ftp.otrs.org.
Greetings to Brazil! ;)
-Martin
On Apr 6, 2009, at 17:59 , Ronaldo Richieri wrote:
Hi!
I'm in a project where we are going to install an OTRS to a huge university here in Rio de Janeiro (Brazil).
They are expecting about 5,000 tickets per day. I don't if this is a lot of information for a MySql installation, so I have this question:
Is a MySql installation a good choose for us? Or should I consider another DB for this project?
Why some people prefer to choose PostgreSQL or Oracle sometimes?
Thanks!!
Ronaldo Richieri Brazil +55 15 8818-2009 --------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
--------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Hi Ronaldo, On Apr 6, 2009, at 23:47 , Ronaldo Richieri wrote:
How about the table type. Are you using MyIsam or InnoDB?
IMO MyIsam is a little bit faster but is locking table, InnoDB is a little bit slower but is only locking rows. So starting with MyIsam should be a good choice. -Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97505 Chairman of the Supervisory Board: Burchard Steinbild Executive Board: André Mindermann (CEO), Martin Edenhofer NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (2)
-
Martin Edenhofer -
Ronaldo Richieri