Rightio - for anyone else coming across this, the full index needs write privileges (to update the delta flag). Delta indexes can get by on just read access, I'm pretty sure - and full index too if you're not using deltas.
-- Pat On 27/08/2011, at 3:36 AM, Garrett Dimon wrote: > 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. > -- 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.
