How to scale mysql servers for a rails application?

Rails
21

Oh, additionally, as you add app servers to the
system, the DB will become loaded, while the
app server load will remain fairly constant.

This would tend to skew loaded results toward
higher DB time ratios.

Of course you can scale the DB through a variety
of methods, but generally speaking, DBs don’t
scale as easily as the application layer.

–
– Tom M.

22

On Fri, Mar 10, 2006 at 07:38:49PM -0800, Tom M. wrote:

Interesting data, Justin!

My experience suggests that most applications
don’t generate large numbers of rendered images,
but my view may be hopelessly Web 1.0.

I thought SVG would get some more traction sooner, but it hasn’t
really caught on.

–
- Adam

** Expert Technical Project and Business Management
**** System Performance Analysis and Architecture
****** [ http://www.adamfields.com ]

[ Adam Fields (weblog) - - entertaining hundreds of millions of eyeball atoms every day ] … Blog
[ Adam Fields Resume ]… Experience
[ Adam Fields | Flickr ] … Photos
[ http://www.aquicki.com/wiki ]…Wiki

23

On Fri, Mar 10, 2006 at 07:45:05PM -0800, Tom M. wrote:

Oh, additionally, as you add app servers to the
system, the DB will become loaded, while the
app server load will remain fairly constant.

This would tend to skew loaded results toward
higher DB time ratios.

Of course you can scale the DB through a variety
of methods, but generally speaking, DBs don’t
scale as easily as the application layer.

We’ve come full circle - this discussion started with a question about
how to scale MySQL to multiple servers.

It’s easier if you have a real db connection pool broker. :slight_smile:

–
- Adam

** Expert Technical Project and Business Management
**** System Performance Analysis and Architecture
****** [ http://www.adamfields.com ]

[ Adam Fields (weblog) - - entertaining hundreds of millions of eyeball atoms every day ] … Blog
[ Adam Fields Resume ]… Experience
[ Adam Fields | Flickr ] … Photos
[ http://www.aquicki.com/wiki ]…Wiki