All, I know normally index should be optimized on master and it will be replicated to slave but we have an issue with the network bandwidth.
We optimize indexes weekly (total size is around 1.5TB). We have few slaves set up on local network so replication the whole indexes is not a big issue. However, we have one slave in another city too (on a backup network) which of course gets replicated over internet which is quite slow and expensive. We want to avoid copying the complete indexes every week after optimization and were thinking if its possible to optimize it independently on slave so that there is no delta between master and slave? We tried to do it but still the slave replicated from master. -- Regards, Salman Akram
