[rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?
bparish at cognex.com
Thu Mar 13 10:34:04 EDT 2014
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
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?
My blog: http://mark.goodge.co.uk
RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
More information about the rt-users