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: [email protected] [mailto:[email protected]] On Behalf Of Mark Goodge Sent: Thursday, March 13, 2014 10:07 AM To: [email protected] 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 -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
