[rt-users] Table creation question (v4.0.6)

[Poulter, Dale]

Good morning,

We are upgrading to  4.0.6 and changing our architecture a little.  We will be running RT on one server and connect to the database on another server.  This works fine for most functions but I am attempting to determine how the sphinx server should be setup.  This is how I THINK is should be but would like to hear back from anyone that has attempted this scenario

DB server:  mysql
Sphinx should run on the RT server and not the Sphinx server.

Creation of Attachementsindex should be

CREATE TABLE AttachmentsIndex (
        id     INTEGER UNSIGNED NOT NULL,
        weight INTEGER NOT NULL,
        query  VARCHAR(3072) NOT NULL,
        INDEX(query)
    ) ENGINE=SPHINX CONNECTION="sphinx://rtserver.org:9312/rt" CHARACTER SET utf8


Is this correct or should the SPHINX CONNECTION be the localhost?  Thanks.

--Dale

---------------------------------------
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu<mailto:dale.poulter at vanderbilt.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120613/9c7d3f08/attachment.htm>