Hi everyone, I have two servers; one is a dedicated database server running MySQL, and the other is running a pack of mongrels with my Rails application logic. I have Sphinx running in my development environment where the database and application logic are on the same machine, and now I want to deploy into production where they are on different machines.
It seems like I should store the Sphinx index and run the Sphinx daemon on the database server, since they're both essentially storing data and handling queries. So presumably I would run the Sphinx search daemon there and access it from my mongrels when the user does a search. My question is: how do I get the initial index built without having to also install Rails and my logic onto the database server? Ideally, I'd like to keep the database server lean and mean and not install any Rails code there. It's not clear to me where the indexer has to run in relation to the Sphinx server and the relationship between where the indexer runs and the Rails application. Thanks! Graham --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
