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.
