Hi Elise, as Ben suggested, you can just rsync/scp the config file to your DB server and then just run the indexer as shown here: http://sphinxsearch.com/docs/manual-1.10.html#ref-indexer. Be careful to use the --rotate flag if you do seamless rotating. Probably you also want to use --all to recreate all indexes.
- Clemens On Apr 19, 2011, at 10:29 AM, Elise Huard wrote: > Hi Pat, > thanks for answering so quickly :) > > ben, > I like your solution, I agree the app code (and ruby and gems) should > not be required on the backend server, and would be grateful for any > code you'd want to share (in a blog post or otherwise). > Thanks all, > > Elise > > On Apr 19, 3:48 am, ben <[email protected]> wrote: >> My team solved something very similar by choosing to rsync the conf >> file over to the database server upon deployment, and creating a rake >> task that SSHs into the database server and runs the Sphinx 'indexer' >> command directly. We decided it was more elegant than having to run >> the app on the db server. If you want some code I'd be happy to share. >> >> On Apr 18, 7:09 pm, Pat Allan <[email protected]> wrote: >> >> >> >> >> >> >> >>> Hi Elise >> >>> You'll need to run all the TS tasks from your database server - Sphinx only >>> serves search requests remotely, but it will not index remotely. >> >>> So, this means you'll need a copy of the app on the db server for that >>> purpose. >> >>> Also, you'll probably want to add the explicit version to your sphinx.yml >>> file: >> >>> production: >>> version: 0.9.9 >> >>> (Change to 0.9.8 or 1.10-beta if necessary). >> >>> Let me know if you've got any other questions. >> >>> Cheers >> >>> -- >>> Pat >> >>> On 19/04/2011, at 1:46 AM, Elise Huard wrote: >> >>>> Hi, >> >>>> we're working with a classical setup with one back-end server >>>> containing the database(s) and one or more front-end application >>>> servers. Both are on Ubuntu 10.10 on amd64 >>>> thinking_sphinx version: 2.0.2 >>>> sphinx version: 0.9.9 (Ubuntu default) >>>> database: postgresql-8.4 >> >>>> In our heads it seemed like a logical idea to have sphinx and the >>>> index centralized on the database server as well. >>>> As configuration on the application server we have: >> >>>> production: >>>> address: ip_address >>>> port: 9312 >> >>>> On the backend server sphinx is running on the default port. We also >>>> added ThinkingSphinx.remote_sphinx = true in our environment. >> >>>> When we run rake ts:index however, it comes back with >>>> sh: indexer: not found >>>> while indexer is on the default location on the remote server ... >>>> changing the bin_path doesn't change anything, it still can't find it, >>>> so I'm wondering if it's looking locally. >>>> Is indexer supposed to run locally ? How to have a centralized index >>>> in that case ? >>>> Thank you, >> >>>> 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 >>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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. > -- 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.
