Ruby on Rails Tuesday, April 7, 2015

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??

Thanks,

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/84266d53-de66-4716-b995-3de975f59d3d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment