# Virtual hosts not using their own databases

**URL:** <https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399>\
**Category:** Rails\
**Created:** [December 11, 2008, 2:38pm UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399 "2008-12-11T14:38:31Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 11, 2008, 2:38pm UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/1 "2008-12-11T14:38:31Z")

</div>

Hi there!

I just set up 3 instances of the same Rails app (nginx+mongrel\_cluster)  
– [http://pastie.org/336677](http://pastie.org/336677) – but for some reason site1 and site2  
(despite their own database.yml) end up using site3’s database.

What on earth is going on here?

Thanks y’all,  
RV

---

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 11, 2008, 9:05pm UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/2 "2008-12-11T21:05:27Z")

</div>

Redd V. wrote:

> 

Does each virtual host have its own instance of the database server  
running?

---

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 11, 2008, 11:55pm UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/3 "2008-12-11T23:55:16Z")

</div>

Norm wrote:

> Does each virtual host have its own instance of the database server  
> running?

No actually I’m only running one MySQL 5.1 server instance. The OS is  
FreeBSD.

Thank you.

---

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 12, 2008, 12:44am UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/4 "2008-12-12T00:44:33Z")

</div>

Redd V. wrote:

> 

When you say “their own database.yml” do you mean that you have  
differently named databases in each database.yml? Stupid question but  
stuff happens.

---

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 12, 2008, 10:07am UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/5 "2008-12-12T10:07:46Z")

</div>

Norm wrote:

> Redd V. wrote:
> 
> > 
> 
> When you say “their own database.yml” do you mean that you have  
> differently named databases in each database.yml? Stupid question but  
> stuff happens.

Yes, exactly, like site1\_production, site2\_production and so on.

---

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 14, 2008, 12:01pm UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/6 "2008-12-14T12:01:51Z")

</div>

John Y. wrote:

> So if you start only site2’s mongrel cluster it actually uses the data  
> site3\_production, though it’s database.yml specifies site2\_production?
> 
> also, I think you forgot the ‘t.’ in your rake tasks
> 
> task :install\_site3 =\> :environment do |t|  
> t.load\_database  
> t.create\_keys  
> t.create\_preferences  
> t.create\_admin  
> end

Actually I fixed it now though. It turned out running “rake  
install\_site1 RAILS\_ENV=production” also ran rake install\_site2 and rake  
install\_site3 since they were all in the same directory. Deleting the  
other rake scripts for each instance of my Rails app made everything  
work just fine.

Much obliged everyone!

---

<div class="post-metadata">

**Author:** ![reddvinylene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/4af34b/32.png) [@reddvinylene](https://www.ruby-forum.com/u/reddvinylene)\
**Post date:** [December 12, 2008, 10:36pm UTC](https://www.ruby-forum.com/t/virtual-hosts-not-using-their-own-databases/155399/7 "2008-12-12T22:36:01Z")

</div>

Redd V. wrote:

> Norm wrote:
> 
> > Redd V. wrote:
> > 
> > > 
> > 
> > When you say “their own database.yml” do you mean that you have  
> > differently named databases in each database.yml? Stupid question but  
> > stuff happens.
> 
> Yes, exactly, like site1\_production, site2\_production and so on.

So if you start only site2’s mongrel cluster it actually uses the data  
site3\_production, though it’s database.yml specifies site2\_production?

also, I think you forgot the ‘t.’ in your rake tasks

task :install\_site3 =\> :environment do |t|  
t.load\_database  
t.create\_keys  
t.create\_preferences  
t.create\_admin  
end