Nice, thanks ben. we had it working more or less, but it'll help good to check against what you've got. (and thank you Clemens)
Elise On Apr 19, 4:59 pm, ben <[email protected]> wrote: > 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.
