[rt-users] Taking RT offline required for enabling sphinx fulltext 'only'?

[Subin]

Noted it. Thanks Kevin.

Re,

On Sunday 27 January 2013 10:51 PM, Kevin Falcone wrote:
> On Sun, Jan 27, 2013 at 07:04:11PM +0530, Subin wrote:
>>     1. Took the previous RT 3 offline and configured mail redirect.
>>     2. Re-compiled mysql-server 5.1 with 'sphinx' storage engine(sphinxse)
>>        for enabling fulltext support for RT 4.
>>     3. Installed RT 4 and restored the previous database backup. It was
>>        successful and the new RT interface was working fine after restoring
>>        mail flow. All good.
>>
>>     However I didn't enable fulltext although I compiled mysql with sphinxse support.
>>     I chose it to do another time since I wasn't sure of what all the RT tables to index
>>     and was a bit unsure of Sphinx stuff.
>>
>>     So my question is:
>>
>>     Q) If I intended to enable fulltext with RT4 later on like as mentioned here:
>>
>>     [1]http://www.bestpractical.com/rt/docs/4.0/full_text_indexing.html#Creating-and-configuring-the-index1
>>        starting from the step "sbin/rt-setup-fulltext-index --dba root --dba-password secret"
>>     would I be need to take RT
>>        offline like I did for the upgrade?
> I would recommend taking the webserver down. That script creates a new
> table in your database. You'll need to make the table, add in the
> configuration, restart apache, run an initial index, etc. These are all
> things best tested in a development environment and then deployed during
> a scheduled downtime.
>
> -kevin