Perfect! Thanks for your assistance Pat :) I'll throw the rails app on the database server and give the rake command a try!
On Sunday, 17 June 2018 22:07:45 UTC-5, Pat Allan wrote: > > 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 <camer...@gmail.com > <javascript:>> 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 <camer...@gmail.com> 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 thinking-sphi...@googlegroups.com. >> To post to this group, send email to thinkin...@googlegroups.com. >> Visit this group at https://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 thinking-sphi...@googlegroups.com <javascript:>. > To post to this group, send email to thinkin...@googlegroups.com > <javascript:>. > Visit this group at https://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 thinking-sphinx+unsubscr...@googlegroups.com. To post to this group, send email to thinking-sphinx@googlegroups.com. Visit this group at https://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
