Ahhh awesome... Thanks Garry & Pat! Will give this a shot.
-J On Jan 6, 12:44 pm, Garry Tan <[email protected]> wrote: > I run sphinx on my db server, and I have two separate app servers that > both talk to the sphinx instance on the db server. Here's what I use > in my capistrano script: > > namespace :sphinx do > > desc "Reindex all" > task :index, :roles => :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake > ts:index" > end > > desc "Reindex just the past 15 minutes of stuff (based on delta last > modified time)" > task :delta, :roles=> :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake > thinking_sphinx:index:delta" > end > > desc "Merge deltas into main index. Not used because we just usually > reindex every morning." > task :merge, :roles=> :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake > thinking_sphinx:index:merge" > end > > desc "Create config. Generally not used since config gets > regenerated on index tasks." > task :config, :roles=> :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake > ts:config" > end > > desc "start sphinx daemon" > task :start, :roles=> :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake > ts:start" > end > > desc "stop sphinx daemon" > task :stop, :roles=> :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake ts:stop" > end > > desc "restart sphinx daemon" > task :restart, :roles=> :db do > run "cd #{current_release} && RAILS_ENV=#{rails_env} rake > ts:restart" > end > end > > If you need delta indexes, I suggest using bassnode's > branch:http://github.com/bassnode/thinking-sphinx/tree/master > > And the blog post describing how to use > it:http://blog.edhickey.com/2008/09/15/thinkingsphinx-rails-plugin-fork/ > > I have a crontab that runs every 15 minutes to re-index, and a daily > crontab that re-indexes the whole db every 24 hours. > > Hope that helps. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
