[rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?

[ktm at rice.edu]

On Thu, Mar 13, 2014 at 02:47:10PM +0000, Mark Goodge wrote:
> On 13/03/2014 14:32, Kevin Falcone wrote:
> >On Thu, Mar 13, 2014 at 02:06:40PM +0000, Mark Goodge wrote:
> >>On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote:
> >>>We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL
> >>>5.5.35. Management is now asking me to enable full text searching on the
> >>>sites so we can search inside the body of the tickets. From what I've
> >>>read, our current configuration won't support it due to MySQL 5.5.x not
> >>>supporting it natively.
> >>
> >>MySQL has supported fulltext indexes since version 5.0. What makes you
> >>think otherwise?
> >
> >It supported InnoDB Full Text indexing in 5.0?
> 
> No; you need to use MyISAM until 5.6.
> 
> But that should not be an issue here; I know that RT uses InnoDB by
> default but there should be no reason why the table you want to
> search can't be converted to MyISAM.
> 
> Mark

Hi Mark,

I do not use MySQL here, but the table that is to be indexed can be
very large and I certainly would not want to wait for a myisamchk to
complete after a crash. The sphinx option is the only viable one for
use with mysql. Moving to PostgreSQL would work but as suggested by
others, if your expertise is with MySQL, stick with MySQL.

Regards,
Ken