ThnkingSphinx (sphinxd) on a remote delta index database server?

Question

I am working on setting up a simple tiered configuration of Rails 3.1 - web applications on one or more servers, the postgresql database and our Sphinx search indexes on a remote server.

On a single-server installation, we use ThinkingSphinx and delta indexes (using delayed_job), and then a night cron to update the main index. It works great.

So: the user creates indexed content; The application reports delayed_job to schedule an update; delta-indexer adds new content to the delta index; Searches look for how to correctly search a search query; night work recreates a single core index.

The documentation for ThinkingSphinx says here below below

The best approach is to have all Sphinx, the database, and the deferred task processing task run on the same machine.

But I do not understand how to send the information necessary for the slow-motion process to one server that will be launched. I read something about having a common file system (yuck - really?). I have not read the code yet, but maybe there is an easy way?

We hope here!

Answer 1

A deferred worker (running on your DB / Sphinx server) refers to the database in the context of your Rails application - so you need an application on your DB / Sphinx server, but just to start the DJ worker.

, TS .

: config/application.rb:

ThinkingSphinx.remote_sphinx = Rails.env.production?

Sphinx config/sphinx.yml:

production:
  version: 2.0.1-beta