Hi Pat, So we still opted for a remote sphinx server. I was able to set up the server and connect to the production database remotely. I can therefor index the production db and thus generate the indices in the sphinx server. Thanks for the help once again. I am now faced with another 'big picture' issue.
1. So now that my app server will be sending search queries to searchd on the sphinx server, I'm guessing I need to open up the port on which Sphinx runs on the sphinx server? There's a mysqld41 setting that I have set to the mysql port on my sphinx server. This I'm assuming is the port that I need to open to get to searchd? Is this all that's needed in this server as far as configuration is concerned? Maybe my big picture looking at it from the app server is all wrong :) On Tuesday, March 18, 2014 3:31:01 PM UTC+3, Pat Allan wrote: > > 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] <javascript:>> > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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.
