Hi Cam, Your current setup is fine (once you add a copy of the Rails app onto the database server) - especially if you’re using SQL-backed indices, because then Sphinx doesn’t have as much network overhead when it’s talking directly to the database.
If you’re using real-time indices, then it’s up to you. It might be more a matter of balancing the resources needed - I feel like the app server could be more demanding, so keeping things as you’ve got now is perhaps best? Certainly, I’d start with that and see how things go. Cheers — Pat > On 18 Jun 2018, at 10:02 am, Cameron McKay <[email protected] > <mailto:[email protected]>> wrote: > > Hey Pat, > > Thanks for the quick reply! At the moment my architecture consists of two > servers: App Server (Rails app) and Database Server (Sphinx and MySQL). > > Is this a best practice architecture to use with Sphinx? Based on your > response, I am wondering if I should move Sphinx to the App Server or if I > should maintain a copy of the rails app on both servers. > > Cheers, Cam. > > On Sunday, 17 June 2018 21:57:44 UTC-5, Pat Allan wrote: > Hi Cameron, > > It looks like you’re running the rake task on the app server. The server with > Sphinx needs to have a copy of the Rails app, and *that* is where you run all > the Sphinx-related tasks (as there’s no way to start or index Sphinx > remotely). > > Give that a shot, and let us know how you go! > > Cheers, > > — > Pat > >> On 18 Jun 2018, at 9:51 am, Cameron McKay <[email protected] <>> wrote: >> >> Hello, >> >> I have Rails application running on the app server and I am connecting it to >> a remote server that contains MySQL and Sphinx using ThinkingSphinx. >> >> I've updated my thinking_sphinx.yml file to point to the remote sphinx >> server. The thinking_sphinx.yml configuration is shown in the image below: >> >> >> <https://lh3.googleusercontent.com/-UPJexucayNM/Wycd2Wa_2OI/AAAAAAAAIvE/GpXQ2JiR-J0YDGFp0fvWiNzK-LaJZ59MwCLcBGAs/s1600/err2.JPG> >> >> I'm running the command "bundle exec rake ts:start" and am getting the error >> shown in the image below. >> >> >> <https://lh3.googleusercontent.com/-TxsKVON3pfY/WycdgFpdGHI/AAAAAAAAIu8/pXxB5L5TBWsoJ2a3y6j_dGqvxE3rKzVUwCLcBGAs/s1600/err1.JPG> >> >> I'm rather lost on this. Any help would be greatly appreciated! >> >> Cheers, Cam. >> >> -- >> 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 https://groups.google.com/group/thinking-sphinx >> <https://groups.google.com/group/thinking-sphinx>. >> For more options, visit https://groups.google.com/d/optout >> <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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/thinking-sphinx > <https://groups.google.com/group/thinking-sphinx>. > For more options, visit https://groups.google.com/d/optout > <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 https://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
