[rt-users] Table creation question (v4.0.6)
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.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu
Re: [rt-users] Table creation question (v4.0.6)
On Wed, Jun 13, 2012 at 7:02 PM, Poulter, Dale dale.poul...@vanderbilt.edu wrote: 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.poul...@vanderbilt.edu -- Best regards, Ruslan.