Hello All, I am trying to evaluate the OTRS for meeting our ITSM requirements. I am posting this question to esteemed member to know whether OTRS supports MySql. We want to run MySql because we have the good hands-on over this database and have seen this growing. Could please some of the members share their input on OTRS with MySql? Did anyone face any issues on MySql while running OTRS? Regards Sudhir Garg
OTRS works fine with MySQL, but I would question the wisdom of relying heavily on MySQL-based infrastructure until Oracle demonstrates whether it intends to actually continue to invest in it. It's not trivial to change DB engines mid-flight, and until the other shoe drops, I consider the risk fairly high that Oracle will not do the right thing.
Thanks David for your response. Could you please share if any big enterprises rollout out OTRS on Mysql and running successfully till date? I am asking because we don't have choice other than going to Mysql due to future standardization of the technology rod-map. Regards Sudhir -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of David Boyes Sent: 12 December 2010 10:38 To: User questions and discussions about OTRS. Subject: Re: [otrs] OTRS and MySql OTRS works fine with MySQL, but I would question the wisdom of relying heavily on MySQL-based infrastructure until Oracle demonstrates whether it intends to actually continue to invest in it. It's not trivial to change DB engines mid-flight, and until the other shoe drops, I consider the risk fairly high that Oracle will not do the right thing. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Hi Sudhir, Political questions aside, I believe most OTRS installations runs on MySQL with no plans to change that. We have deployed three enterprise installations of OTRS on MySQL so far, one of them handling 80,000+ tickets a year. They run just fine. Lars -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sudhir Garg Sent: Sunday, December 12, 2010 11:15 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] OTRS and MySql Thanks David for your response. Could you please share if any big enterprises rollout out OTRS on Mysql and running successfully till date? I am asking because we don't have choice other than going to Mysql due to future standardization of the technology rod-map. Regards Sudhir -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of David Boyes Sent: 12 December 2010 10:38 To: User questions and discussions about OTRS. Subject: Re: [otrs] OTRS and MySql OTRS works fine with MySQL, but I would question the wisdom of relying heavily on MySQL-based infrastructure until Oracle demonstrates whether it intends to actually continue to invest in it. It's not trivial to change DB engines mid-flight, and until the other shoe drops, I consider the risk fairly high that Oracle will not do the right thing. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Thanks David for your response. Could you please share if any big enterprises rollout out OTRS on Mysql and running successfully till date?
I know of several I've done (600-700 agents, 2500-3000 significant issues/day, fairly large CMDB). Key issues are hardware performance (the OTRS front end can be resource intensive if heavily used; good idea to NOT run it on the DB servers...) and planning for fault management in the DBMS itself; eg clustering, replication. The ITSM add-ons are quite good, actually; change management will take some thought to implement, but that's not MySQL related (CM is hard on any tool). Pretty much the standard issues for any incident management system.
I am asking because we don't have choice other than going to Mysql due to future standardization of the technology rod-map.
Gotta do what you gotta do. I personally have suspended new MySQL deployments for OTRS until Oracle shows their cards, but YMMV.
participants (3)
-
David Boyes -
Lars Jørgensen -
Sudhir Garg