Hi Alex Probably the easiest way to do this would be to add another environment to your app with those replica database credentials, and ensure any sphinx.yml settings for production are copied to the new environment as well. Then always use that environment when running the index task.
Granted, I've not done this myself, but I'm pretty sure it should work. -- Pat On 18/09/2012, at 12:20 AM, Alex Kahn wrote: > Hi, > > We have an index that is very expensive to generate and we want to instead > query our database replica to generate the index. This way the expensive, > long-running query won't have impact on our users in production. How can I > tell Thinking Sphinx's configure task to write this alternate database host > to the Sphinx configuration file it generates? I can see that Riddle has a > sql_host configuration option, but I'm not sure how to set that via Thinking > Sphinx. > > Thanks for any help, > Alex > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/8gwCefWdmFIJ. > 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.
