one rails, multiple DBs

29 views
Skip to first unread message

Marcelo Barbudas

unread,
Feb 10, 2010, 10:56:50 AM2/10/10
to Ruby on Rails: Talk
Hi.

I'm in a situation where I have to provide a hosted Rails App
solution. I'm running Apache with passenger in the backend.

What is the proper way to change the DB depending on the subdomain?
Should I use data_fabric?

--
R.

Marnen Laibow-Koser

unread,
Feb 10, 2010, 11:05:59 AM2/10/10
to rubyonra...@googlegroups.com

Generally, you don't need a separate DB for each subdomain. One big DB
is usually better.

>
> --
> R.

Best,
-- 
Marnen Laibow-Koser
http://www.marnen.org
mar...@marnen.org
--
Posted via http://www.ruby-forum.com/.

Marcelo Barbudas

unread,
Feb 10, 2010, 12:58:43 PM2/10/10
to Ruby on Rails: Talk
Hi,

> Generally, you don't need a separate DB for each subdomain.  One big DB
> is usually better.

It's a high volume app, that's written as a standalone service.
Extending it as a hosted solution and keeping updates nice is a big
part of what the project is about.

--
Cheers,
M.

Marnen Laibow-Koser

unread,
Feb 10, 2010, 1:02:48 PM2/10/10
to rubyonra...@googlegroups.com

And all of that would be easier with one big DB, at least as far as
you've described.

>
> --
> Cheers,
> M.

Marcelo Barbudas

unread,
Feb 10, 2010, 1:34:18 PM2/10/10
to Ruby on Rails: Talk
Hi.

>
> > It's a high volume app, that's written as a standalone service.
> > Extending it as a hosted solution and keeping updates nice is a big
> > part of what the project is about.
>
> And all of that would be easier with one big DB, at least as far as
> you've described.
>

You are right, it would definitely be easier if this App was written
with a hosted version in mind. Unfortunately it isn't.

Still, the volume of traffic and DB size of the app means that if
someone grows bigger we want to be able to quickly move it to
something dedicated.

--
Cheers,
R.

myobie

unread,
Feb 10, 2010, 1:51:05 PM2/10/10
to Ruby on Rails: Talk
DataMapper out of the box will let you use multiple databases,
although these need to be known at app boot time.

For ActiveRecord, this article might lead you somewhere:
http://tomayko.com/writings/rails-multiple-connections

Nathan

Reply all
Reply to author
Forward
0 new messages