From: Andrew Moore Date: October 31 2011 9:47am Subject: Re: add index to slave but not master List-Archive: http://lists.mysql.com/mysql/226204 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00151758b39804c16204b09522db --00151758b39804c16204b09522db Content-Type: text/plain; charset=ISO-8859-1 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 will differ from the original master and you might notice a performance difference as a result. Hth Andrew On Oct 31, 2011 7:47 AM, "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? > > Thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomydna@stripped > > --00151758b39804c16204b09522db--