Hi- I have a requirement for a system that does 10M+ read/writes a day. I haven''t done work with this volume before. It translates to 100+ read/ writes per second. Can anyone recommend a rails DB back end for a system of this volume? Can I get performance like this with mysql clusters? What else should I be looking at? Thanks for any advice, Kevin -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Before you go any further is that 99 read and 1 write per second or 1 read and 99 writes. Writes are expensive and reads can be cached. Some idea as to the reads to writes ratio would be useful if anyone is going to give you any advise. On 9 October 2011 14:27, KevinC <kevinchugh-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi- > > I have a requirement for a system that does 10M+ read/writes a day. I > haven''t done work with this volume before. It translates to 100+ read/ > writes per second. Can anyone recommend a rails DB back end for a > system of this volume? Can I get performance like this with mysql > clusters? What else should I be looking at? > > Thanks for any advice, > Kevin > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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. > >-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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.
I agree with Peter''s suggestion. I would also suggest googling "how well does [databasename] scale?" So, you could check on MySQL, PostgreSQL (my personal fave), Sybase, Oracle, object DBs like CouchDB, MongoDB, intersystems (Caché), .. etc... You might also want to go really crazy and look at multivalue databases like universe/unidata, and objecache, etc. etc. J. On Sun, Oct 9, 2011 at 10:20 AM, Peter Hickman <peterhickman386-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:> Before you go any further is that 99 read and 1 write per second or 1 > read and 99 writes. Writes are expensive and reads can be cached. Some > idea as to the reads to writes ratio would be useful if anyone is > going to give you any advise. > > On 9 October 2011 14:27, KevinC <kevinchugh-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> Hi- >> >> I have a requirement for a system that does 10M+ read/writes a day. I >> haven''t done work with this volume before. It translates to 100+ read/ >> writes per second. Can anyone recommend a rails DB back end for a >> system of this volume? Can I get performance like this with mysql >> clusters? What else should I be looking at? >> >> Thanks for any advice, >> Kevin >> >> -- >> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. >> >> > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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. > >-- http://gplus.to/jsf http://about.me/joshuafreeman http://joshuasfreeman.me -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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.
On Oct 9, 2011, at 3:27 PM, KevinC wrote:> I have a requirement for a system that does 10M+ read/writes a day. I > haven''t done work with this volume before. It translates to 100+ read/ > writes per second. Can anyone recommend a rails DB back end for a > system of this volume? Can I get performance like this with mysql > clusters? What else should I be looking at?You requirement is a bit fuzzy. After all, SQLite could handle this easily, depending on the specific scenario at hand. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.