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.

  • Thanks, that link was useful. I tried doing this on testing environment. Definitely, this requires to allow modifications to read replica. – K D Mar 18 '19 at 11:50
  • How can I allow modifications on the read replica? Modifications made on the read replica are copied automatically to the Master? – Andrea Gorrieri Jun 27 '19 at 10:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.