I haven't the time now to do a formal blog post (mostly since I don't have a formal blog) but here's the relevant snippets:
https://gist.github.com/928090 Let me know what you guys think! -ben On Apr 19, 7:36 am, Pat Allan <[email protected]> wrote: > Would love to see something like this put into a script that's reusable :) > > Shouldn't be too hard to check if a pid and/or process is running to add the > --rotate flag. > > -- > Pat > > On 19/04/2011, at 6:40 PM, Clemens Kofler wrote: > > > > > > > > > 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 > >> 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 > > 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.
