I have two Rails3 servers "rails-01" & "rails-02" and an app server which runs all of our background tasks such as rake tasks and delayed_job and the sphinx service. It's name is "app-01". In addition to this, I have another server for mysql, named "mysql-01". So here's what my setup looks like:
haproxy-01 <-- load balancer rails-01 rails-02 app-01 <-- sphinx/searchd run here mysql-01 As of right now, I have my system setup to update the columns with the delta field as true any time one is updated, but since I don't have the whole thing setup properly, those records become invisible to my rails servers (sphinx search) until I run rake thinking_sphinx:rebuild RAILS_ENV=production Since delayed_job already runs on the app server, I could install the thinking sphinx delayed job gem and update my delta indexes like that, but I don't feel very good about that setup. I would rather have it setup where the delta index is updated immediately when the user updates the record - what does this take? Is it as simple as sharing the db/sphinx/production folder of the app-01 server (which has all of the .spa, .spd, sph, etc... files) and then consuming that share on each of the rails web servers? Ex: db/ sphinx/<remote_share_of_production> If so, can you elaborate on this and tell me any negatives of this? Also, would the searchd process need to be running on my web servers if it were setup like this? If not, what would? Thank you in advance for your help! Br -- 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.
