On 31 Oct 2011, at 08:46, Jeff Pang wrote:
> Hello,
>
> I have a question that, if I add the index to the table in slave, but
> don't do it in master, will it make problems?
Jeff,
I manage some big data here and this is my preferred strategy - shard the
workload in different mysql pools (behin
Functionally not a problem. Many people use a slave for different work
loads then their master. Different indexes for different queries make
sense. Be aware that should you intend to make backups off the slave or
even leave yourself open to promoting slave to master as a HA strategy then
things wil