From: Luis Motta Campos Date: October 31 2011 5:38pm Subject: Re: add index to slave but not master List-Archive: http://lists.mysql.com/mysql/226209 Message-Id: MIME-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable On 31 Oct 2011, at 08:46, Jeff Pang wrote: > Hello, >=20 > 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 (behind a load balancer) and give = each different pool a different, custom-tailored index set optimized for = the workload expected. Be warned that if you promote a new master without ensuring = index-compatibility with the master workload you will (obviously) = observe performance variations. Good luck. Cheers! -- Luis Motta Campos is a DBA, Foodie, and Photographer -- Luis Motta Campos is a DBA, Foodie, and Photographer