Adding index only on read replica of MySQL RDS instance
If by any chance you are using AWS MySQL RDS as your database infra, you can refer this:


  To further maximize read performance, Amazon RDS for MySQL allows you to add table indexes directly to Read Replicas, without those indexes being present on the master.