patternsqlMinor
Adding index only on read replica of MySQL RDS instance
Viewed 0 times
readreplicaaddinginstancemysqlrdsindexonly
Problem
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?
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?
Solution
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.
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.
Context
StackExchange Database Administrators Q#226987, answer score: 4
Revisions (0)
No revisions yet.