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.
