Reuse DB server for same queries
-
In the event where a given query is run twice, it might be a good idea to always send that query to the same database server, in the event that MySQL query caching is enabled.
One could store a hash of the query and what DB server it went to, or better yet, determine which server to be used based off the hash of the query, so it’s deterministic.
From what I understand right now it picks a read server at random if you don’t have any open connections.
- The topic ‘Reuse DB server for same queries’ is closed to new replies.
