You could dedicate a database server and use fuzed (http:// fuzed.rubyforge.org) for scaling the webserver threads. It should be pretty easy to get a fully working cluster with redundancy. I have not tried to cluster MySQL, but it looks a bit complex.
http://assets.en.oreilly.com/1/event/6/Build%20Your%20Own%20Distributed,%20Self-Configuring%20Rails%20Cluster%20Presentation.pdf Copy paste from http://en.oreilly.com/rails2008/public/schedule/detail/2031 "Existing Rails applications are deployed using a combination of Mongrel and a reverse proxy. This architecture provides good performance, but is brittle and difficult to disasterproof. This architecture also affords site developers little comfort or ease in deployment or management of new code versions, and requires significant amounts of work to port to extremely distributed platforms like EC2. We will demonstrate a new, self-managing system written in Erlang called “Fuzed” that mirrors the structure of existing Rails applications, replacing both Mongrel and reverse proxies like Nginx. It dramatically reduces the complexity of deploying and maintaining a rails application, even on extremely distributed platforms. Being written in Erlang, it allows for realtime exploration and customization of the infrastructure as it is running, without interrupting service. Fuzed also attempts to provide better reliability and multiple strategies for coping with Rails resource exhaustion by opening this mechanism to the application developer for evaluation and replacement." On Apr 9, 8:07 pm, Owen Dall <[email protected]> wrote: > Any time. The Hobo group is full of talented and knowledge developers... > > On Fri, Apr 9, 2010 at 1:43 PM, [email protected] <[email protected] > > > > > wrote: > > Wow -- this is all great info. You guys have been great at answering > > my very noobish questions, and I want to let you know that it is > > really appreciated. I look forward to learning much more about rails > > and hobo and to picking your brains about some easy and maybe some > > harder questions in the future ... thanks again :-) > > > --jeremy > > > On Apr 9, 10:17 am, Matt Jones <[email protected]> wrote: > > > On Apr 9, 2010, at 10:05 AM, [email protected] wrote: > > > > > Well, I just went through the Agility tutorial - all I can say is WOW! > > > > This is truly good stuff, and I can see that I've got quite a bit to > > > > learn. > > > > > I'm curious as to how scalable this might be ... lets say that I have > > > > 1000 users, and each user has 130 tasks of their own, along with 300 > > > > contacts of their own plus several other tables of data where each > > > > user may have lets say 100 records. You are already up to over 500 > > > > records per user, and over 500,000 records total ... my question is > > > > whether or not using rails + hobo + apache + mysql is a good, > > > > scalable, and fast performing solution for such an application ... or > > > > would some other solution be better? > > > > > I realize that not all users will be accessing their data at the same > > > > time, but how long will it take to retrieve each users set of 300 > > > > contacts from a table that has 300,000 entries? > > > > Not long, if the table is properly indexed. Fortunately, Hobo tries > > > pretty hard to ensure that you get the indexes likely to help - if you > > > declare Contact belongs_to User, the migration generator will > > > automatically add an index on user_id. > > > > As far as the DB goes, MySQL apparently scales well past millions of > > > records, and the Postgres crowd does even more AFAIK. Actually, the > > > biggest problem in database scaling comes from when you start having > > > cross-relations between the data. The basic setup you've described > > > (without links between the users) is highly susceptible to advanced > > > techniques like shardin. > > > > Hope this helps! > > > > --Matt Jones > > > -- > > You received this message because you are subscribed to the Google Groups > > "Hobo Users" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<hobousers%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/hobousers?hl=en. > > -- > Thanks, > - Owen > > Owen Dall, Chief Systems Architect > Barquin International > Cell: 410-991-0811 -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
