Hi all,

Feedback for future user stumbling on this thread: we're using
something similar to ben's setup at the moment (subject to change soon
as we're moving to chef-package setup).
Of the settings he mentioned, we found: pid_file, searchd_file_path,
searchd_log_file, query_log_file are essential and need to be the
paths on the remote server.
We use postgres on the same machine, sql_sock was not necessary for
us.

Since immediate update is not necessary, we went with a cron job on
the remote server to do indexing every minute (may change if too
heavy), like so:
* * * * * /home/user/ts_index
with in ts_index an update of all the indexes (one line per index)
indexer --config "sphinx config path" --rotate table_delta
a capistrano task updates this script as well.

namespace :ts_remote do
  task :ts_cron, :roles => :sphinx do
    run "rsync --progress  user@#{productionserver}:#{current_release}/
my_app/config/cron/sphinx /home/user"
    run "rsync --progress  user@#{productionserver}:#{current_release}/
my_app/config/cron/ts_index /home/user"
    run "chmod +x /home/user/ts_index"
    run "crontab /home/msq/sphinx"
  end
end

hope this helps,

Elise

-- 
You received this message because you are subscribed to the Google Groups 
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/thinking-sphinx?hl=en.

Reply via email to