It really depends on how many records (and how much data per record) you're indexing... Sphinx is generally pretty well-behaved, but I guess it depends on how limited the resources are on your app server. Whenever indexing happens, it will mean there's plenty of traffic between the indexer and your database, so having them share a machine is not a bad idea (instead of adding extra external network traffic).
On 18 Mar 2014, at 5:57 pm, Joram Okwaro <[email protected]> wrote: > Hi Pat, > > Thanks for the quick responses on both threads. I took on this task from a > colleague of mine so I don't know yet how much research he did on Sphinx > performance. That was the main reason why we opted for a remote server. The > idea was that Sphinx was too resource-heavy and therefore a risk for our app > server which we can't afford to be slow. I would appreciate your 2 cents on > this. Otherwise, thank you once again for your help. You have helped a great > deal. I'll let you know if I encounter any specific issues. > > Thanks! > > On Tuesday, March 18, 2014 9:18:15 AM UTC+3, Pat Allan wrote: > Didn't quite cover this in the other thread. > > On 18 Mar 2014, at 5:06 pm, Joram Okwaro <[email protected]> wrote: > > > Hi Guys, > > > > I've already replied to a thread that I hope Pat can reply to about this > > but I thought just in case he's too busy, someone here can help me out in > > the meantime. I'm having trouble finding concise documentation on how to > > set up a remote Sphinx server. My main questions are related to Sphinx > > 3.1.0 and maybe the answer might be that I need to go back to version 2 to > > set this up painlessly. > > > > 1. From my understanding, I need to set up Sphinx on my remote server and > > also a copy of my Rails application (with Thinking Sphinx of course) in > > order to index my models. Is this still the case? > > Yup. > > > 2. If point #1 is the case, how does the indexer index my database which > > lives on the app server. Unless I have to set up a database on the search > > server too which doesn't make sense. I'm pretty lost as you can see :) So > > please help. How would this generally work? That's the big question. > > You'll need to have your database accessible remotely - and have the > appropriate details in config/database.yml. > > If you're going to the effort of having Sphinx on its own server, do you have > the database on its own server too? Perhaps it's worth discussing why you > want to have Sphinx on its own server? > > Cheers > > -- > Pat > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
