Bill Walton
2008-Jan-20 18:22 UTC
scaling with multiple databases - which approach is ''best''?
Hi All, I''m looking at options for using multiple databases in a master-for-writes, slaves-for-reads config. I''ve Googled up multiple options including ActsAsReadonlyable, MagicMultiConnections, ActiveDelegate, and native MySQL. I''m looking for any real-world experience / advice on which of these (or others) are real options. Some background on my constraints... 1) the site is customer-facing and business-critical 2) development is done primariliy on WinXP boxes (corp standard) running local copies of MySQL. production is a clustered environment (except for a single DB box right now) 3) we have a DBA group that controls the production DB environment 4) all the ''normal'' Fortune 500 organization / process stuff Thanks in advance! Bill --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Keynan Pratt
2008-Jan-21 08:27 UTC
Re: scaling with multiple databases - which approach is ''bes
Simplist solution is to stick a load balancer in front of your DB servers. Select request get past to the server with least load, inserts, updates and deletes go to all of them -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---