# Multiple databases - sites sharing same schema, code and webserver(webserver cluster)

**URL:** <https://www.ruby-forum.com/t/multiple-databases-sites-sharing-same-schema-code-and-webserver-webserver-cluster/119176>\
**Category:** Rails\
**Created:** [November 4, 2007, 11:39am UTC](https://www.ruby-forum.com/t/multiple-databases-sites-sharing-same-schema-code-and-webserver-webserver-cluster/119176 "2007-11-04T11:39:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![TomSSSSSSSS\_Klapka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/45deac/32.png) [@TomSSSSSSSS\_Klapka](https://www.ruby-forum.com/u/TomSSSSSSSS_Klapka)\
**Post date:** [November 4, 2007, 11:39am UTC](https://www.ruby-forum.com/t/multiple-databases-sites-sharing-same-schema-code-and-webserver-webserver-cluster/119176/1 "2007-11-04T11:39:39Z")

</div>

I solved multiple databases issue in my own project, kind of CMS for  
multiple sites each having its own db.

My solution works as usual if site request.host (site URL) is  
‘localhost’ or if db:migrate is called  
If browsed to [example.com](http://example.com) which is forwarded to the rails app then it  
connects to prefix\_example\_com database  
(where prefix\_ can be configured or be empty string)  
Added a new rake task db:migrate\_all which would migrate all site  
databases defined somewhere in sql  
Each developer (rails application copy) can have it’s own database  
settings in config/dblogin.yml which shell not be under version  
control

Code pasted at Paste: [Parked at Loopia](http://pastie.caboo.se/113886)