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

[Cena, Stephen (ext. 300)]

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. It looks like I have two options:
*       Migrate our databases from MySQL 5.5.x to Postgres SQL to get the full text index functionality
   *    Create a new MySQL Server that has the Sphinx add-on running & restore my databases into that.

Has anyone had to do this before? Suggestions? Warnings?

Stephen J. Cena
Systems Administrator - MIS/IT Dept
Quality Vision International
850 Hudson Ave
Rochester,NY 14620
Phone: 585-544-0450 x300
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Please report email problems to: postmaster at qvii.com

QVII MIS/IT Dept - We do what we must because we can.
"Thank you for helping us help you help us all."
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140313/93d54230/attachment.htm>