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 <[email protected] > <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 <[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. >> 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] <javascript:>. > To post to this group, send email to [email protected] > <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 [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.
