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 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. > -- 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.
