OTRS + CentOS + MSSQL

Moderator: crythias

Locked
mrt3385
Znuny newbie
Posts: 1
Joined: 22 Feb 2014, 03:14
Znuny Version: 3.3.4

OTRS + CentOS + MSSQL

Post by mrt3385 »

Hello,
Looking to get some thoughts...
We are getting ready to start an implementation of OTRS and we are thinking of using a linux front end and a MSSQL backend. This will be a customer-facing system.
We are mostly a Microsoft shop and want to take advantage of the always-on replication capabilities of MSSQL2012 (replicate DB to multiple sites, stand up 2nd OTRS as failover). My main concerns are performance and reliability; hoping this combination will net me the best of both worlds. Questions, comments, concerns?

Thanks in advance.
Trent
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS + CentOS + MSSQL

Post by jojo »

as there is no good working database driver for PERL and MS SQL you need to use ODBC. This is very slow.

SO I suggest not to use MS SQL
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked