Re: add index to slave but not master
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 (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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: add index to slave but not master
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=eroomy...@gmail.com > >
add index to slave but not master
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=arch...@jab.org