I've been searching without success a plugin that might split Joomla's read queries to one endpoint and write queries to another endpoint. This would enable us to use Amazon RDS's read replicas (MySQL).
Does anybody know how to achieve this, or if there is some plugin/extension available?
UPDATE: I tried to do my own driver based on what was suggested in one of the answers, I did not suceed to make it work. I created a gist so anybody can easily help me solve the issue: https://gist.github.com/siran/77d65f9375cf7b787c83/revisions