Hi - I have an index that is updated fairly frequently (every few seconds), and I'm replicating to several slave servers.
Because of the frequent updates, I'm usually pushing an index that is not optimized. And, as it takes several minutes to optimize, I don't want to do it every time I replicate (at least not on the master). I was wondering if it make sense to replicate to a slave instance, optimize it there, and then distribute the optimized index from the first level slave? Any thoughts? Thanks, Tom