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

[Parish, Brent]

I personally went the Sphinx route because I already have so much MySQL running (and familiarity with) here.

I documented most of it here:  http://parishnetworks.blogspot.com/2013/10/using-mysql-and-sphinx-for-rt-full-text.html

- Brent


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Mark Goodge
Sent: Thursday, March 13, 2014 10:07 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?

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?

Mark
--
My blog: http://mark.goodge.co.uk
--
RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training