Rails Multi-DB Connection Pool Management Goodness
UPDATE: It seems another option has come up, I’ve found this acts_as_with_readonly plugin which hooks into AR so you can then have AR read from a pool of slaves. http://revolutiononrails.blogspot.com/
“““““““`
So i’m sitting here in a internet cafe, enjoying my vacationing on the French Riviera and saw the great news in my feedreader. Rails DB connection pooling at last!
Oh yes, it seems a solution has finally arrived for accessing multiple databases in Rails.
Dr. Nic has posted an article detailing it. It requires the magic_multi_connections gem and a few modifications to your environment.rb file. You can then specify clones to connect to and distribute load on the database backend.
The best part is its simplicity and transparency of it all. To read from a pool of databases it will essentially look something like this:
class PeopleController < ApplicationController
def index
@people = conn::Person.find(:all)
end
end
The magic is in the conn:: method which in the background selects a clone at random. Though I do think maybe in the future there will be a more intelligent form of load-balancing and database selection.
It is not limited to just reading off clones, you can set all writes to go to just the master, but reading from all database servers can be setup as well. You can also customize the setup to fit your environment, for example if you did table segmentation for users (A-E on database1, E-M on database2 etc).
.
Posted on April 14, 2007
Filed Under Analytics, Business, Daily Thoughts, Design, Productivity, Ranting, Ruby on Rails, Tech, Web
Related Posts:
-
Ajax on Rails and some practical SVN goodness
RFacebook Rails Plugin
Rails Cookbook - Fresh off the Press
The Ruby on Rails Triad
SugarStats.com launches private-beta of online diabetes management site
SugarStats.com Redesign and New Features Rollout
Comments
Leave a Reply
-
Projects
-
Search it all
-
About
I'm Marston and here you'll find my rantings, rhetoric and other useful info. I dig tech, photography, quantum physics and organic food. I'm the founder of SugarStats.com and thats my days developing.
-
Flickr
www.flickr.com
This is a Flickr badge showing public photos from Marston A.. Make your own badge here.
-
Twitter
- Off to the airport for Cape Verde. 1 month. No Internet. No computer. No phone. Shocking right? I cant wait. See ya later ;) 21 hrs ago
- @brunofigueiredo oh yeah :-). Highly recommended. 1 day ago
- Suitcase packed. Now off to see Dark Night in IMAX before tomorrows flight to Cabo 1 day ago
- Trying to find Dark Night IMAX tickets for Wednesday night before we flight to Cabo Verde. Crossing my fingers... Must. See. In. IMAX. 4 days ago
- Watching "Young People F***ing". Freakin hilarious. 5 days ago
- @mbalara Oh yeah? Where to? 5 days ago
- @Reinier Off to coolhaven again? 5 days ago
- Looking at web conf apps like WebEx, DimDim and GoToMeeting. Any suggestions or other recommendations? 5 days ago
- More updates...