Re: add index to slave but not master

2011-10-31 Thread Luis Motta Campos
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

Re: add index to slave but not master

2011-10-31 Thread Andrew Moore
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