No need to reply to this one. We've gone ahead and switched away from using the slave DB for indexing. It got to the point where the changes necessary were outweighing the performance benefits.
On Aug 25, 11:19 am, Garrett Dimon <[email protected]> wrote: > We're in the process of switching Sphinx over to do indexing from the > slave DB based on this blog post... > > http://www.mendable.com/2010/05/31/thinking-sphinx-performance-index-... > > However, we've been running delayed deltas, and it appears that the > database user needs more than select access in order to manage the > delta flags. Since it's a slave db, we obviously don't want to enable > any write access. > > I had kind of expected this, but before we ditch delayed deltas, I > wanted to follow up and make sure that there wasn't a great solution > out there that I was missing. > > I'm guessing we should just use Datetime Deltas or simply increase our > indexing frequency. We're currently running full indexes 4 times a > day, but we could bump that up to hourly without any problems on the > new setup. Indexing is now running entirely on its own job server > (along with a few other background processing things), so it's not too > big of a deal to just increase our indexing frequency. > > Any recommendations would be appreciated. :) -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
