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-from-slave-mysql-database.html 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.
