OTRS on Amazon RDS

Moderator: crythias

Locked
crons
Znuny newbie
Posts: 58
Joined: 17 Aug 2012, 06:11
Znuny Version: 3.3.x
Real Name: Cornelius Jackson

OTRS on Amazon RDS

Post by crons »

Hi ,

Can OTRS be installed on Amazon RDS?
https://aws.amazon.com/rds/

Regards
Crons
OTRS 3.3.x, Ubuntu, MySql 5.5
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS on Amazon RDS

Post by jojo »

If it behaves like a normal MySQL Database and works with DBD::MySQL -> yes
"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
crons
Znuny newbie
Posts: 58
Joined: 17 Aug 2012, 06:11
Znuny Version: 3.3.x
Real Name: Cornelius Jackson

Re: OTRS on Amazon RDS

Post by crons »

Thanks,
What about MYIASM Engine. I understand the OTRS uSes MYIASM by default.
http://mysqlha.blogspot.in/2009/10/mana ... n-rds.html

According the blog RDS is not so powerful for MYIASM?
OTRS 3.3.x, Ubuntu, MySql 5.5
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS on Amazon RDS

Post by jojo »

I suggest using InnoDB
"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
crons
Znuny newbie
Posts: 58
Joined: 17 Aug 2012, 06:11
Znuny Version: 3.3.x
Real Name: Cornelius Jackson

Re: OTRS on Amazon RDS

Post by crons »

According to the below forum

http://answerpot.com/showthread.php?270 ... +vs+InnoDB

He says few tables like article wont work with innodb and also full search doesn't work. is it so?
I haven't tried yet.:-(

Thanks
Crons
OTRS 3.3.x, Ubuntu, MySql 5.5
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS on Amazon RDS

Post by jojo »

Especially the article table should be InnoDB. Fulltext search will use an extra table if configured
"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
crons
Znuny newbie
Posts: 58
Joined: 17 Aug 2012, 06:11
Znuny Version: 3.3.x
Real Name: Cornelius Jackson

Re: OTRS on Amazon RDS

Post by crons »

Thanks,
So you mean to say OTRS will work with InnoDB engine as well? without any issues?
OTRS 3.3.x, Ubuntu, MySql 5.5
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS on Amazon RDS

Post by jojo »

yes, it works well with InnoDB. InnoDB is also suggested for large setups
"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
crons
Znuny newbie
Posts: 58
Joined: 17 Aug 2012, 06:11
Znuny Version: 3.3.x
Real Name: Cornelius Jackson

Re: OTRS on Amazon RDS

Post by crons »

Thanks Jojo. :-)
OTRS 3.3.x, Ubuntu, MySql 5.5
Locked