Adding index only on read replica of MySQL RDS instance I have created read replica of RDS production database for reporting purposes. Cross-team is using the replica for their use.

Consumers of this replica are looking for additional indexes for faster search, but the developers are not in favour of that (adding these indexes to master) concerning more time for the insertion of records in the master database.

Is it possible to add index only on read replica of MySQL database?
How this is practised in the industry? Or what other ways this problem could be solved?
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.