Database to choose

Marius Vaitiekunas

9 Nov 2010 9 Nov '10

11:53 a.m.

Hello, We are going to use OTRS:ITSM. At the moment i am thinking which database to choose: mysql or postgresql. Any expierences about performance, stabiity? Thank you for answers. -- mv

Attachments:

attachment.html (text/html — 221 bytes)

Show replies by date

David Boyes

9 Nov 9 Nov

4:36 p.m.

Both are equally stable and functional. MySQL has a slight advantage that it is easier to cluster than Postgres, but has the downside of having a lot of uncertainty about if and when Oracle is going to screw us over. Postgres does not have that sword hanging over our heads. I've been going with Postgres for new installs. n Db n From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marius Vaitiekunas Sent: Tuesday, November 09, 2010 6:54 AM To: otrs@otrs.org Subject: [otrs] Database to choose Hello, We are going to use OTRS:ITSM. At the moment i am thinking which database to choose: mysql or postgresql. Any expierences about performance, stabiity? Thank you for answers. -- mv

Stuart Hall

10 Nov 10 Nov

7:29 a.m.

We've got *lots* of MySQL boxes at our site and rarely have problems with it. OTRS was trivial to configure and use with an off-box MySQL database (RPM install needs a --nodeps to stop it from insisting that there should be a local MySQL) and we've had no problems to date. No experience with postgres to compare, sadly. SH On Tue, Nov 9, 2010 at 11:53 AM, Marius Vaitiekunas < mariusvaitiekunas@gmail.com> wrote:

...

Hello, We are going to use OTRS:ITSM. At the moment i am thinking which database to choose: mysql or postgresql. Any expierences about performance, stabiity?

Thank you for answers.

-- mv

--------------------------------------------------------------------- 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

Michael Mayaka

8:04 a.m.

I've deployed OTRS on postgresql and Solaris 10...works perfect Michael ________________________________ From: Stuart Hall To: User questions and discussions about OTRS. Sent: Wed, 10 November, 2010 10:29:47 Subject: Re: [otrs] Database to choose We've got *lots* of MySQL boxes at our site and rarely have problems with it. OTRS was trivial to configure and use with an off-box MySQL database (RPM install needs a --nodeps to stop it from insisting that there should be a local MySQL) and we've had no problems to date. No experience with postgres to compare, sadly. SH On Tue, Nov 9, 2010 at 11:53 AM, Marius Vaitiekunas wrote: Hello,

...

We are going to use OTRS:ITSM. At the moment i am thinking which database to choose: mysql or postgresql. Any expierences about performance, stabiity?

Thank you for answers.

-- mv

--------------------------------------------------------------------- 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

5364

Age (days ago)

5365

Last active (days ago)

List overview

Download

3 comments

4 participants

participants (4)

David Boyes
Marius Vaitiekunas
Michael Mayaka
Stuart Hall