My website has a very heavy read traffic than write traffic.To improve the performance of my website i have decided to go with master/slave database configuration.
while searching on the internet about master/slave configuration for rails i came across the
octopusgem. This gem is very nice and provide the great interface for distributing query across different master and slave servers.
But the issue is that my rails application is very big and if i use
octopus gem then i can’t go though a millions of source code line to change the query distribution(sending read query to slave server and write query to master server) across master and slave servers.
MySQL Proxy seems to be a great way to resolve this issue but since it is in alpha version i don’t want to use it.
So my question is what is the best way to split read/write query across master/slave server?? is it possible to split read/write query without using any gems in rails??