Table creation question (v4.0.6)

RT Users
1

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@vanderbilt.edumailto:dale.poulter@vanderbilt.edu

2

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.

Sphinx should be close to DB. RT sends requests to DB and DB sends
requests to sphinx. RT doesn’t talk to sphinx directly.

–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@vanderbilt.edu

Best regards, Ruslan.