My Rails 3.1 application connects to 2 databases, one is the default, the other is an Amazon RDS MYSQL instance.
The current database.yml contains two production database connections. The models that need to pull from the second database simply use
Unfortunately Heroku overwrites your database.yml, and only seems to inlcude one database connection. Does anyone know how I can add or configure my second?
Running "heroku config" I can see there are 2 DB's listed but cant seem to configure to connect to both. Perhaps somehow set my default to the SHARED_DATABASE_URL db on Heroku and set the alternate to the DATABASE_URL which points to Amazon...
Working off of the previous responses, but incorporating some Rails 3 advantages with the configuration and simplifying the parsing...
# config/application.rb module MyApp class Application < Rails::Application ... other configs config.secondary_database_url = ENV['SECONDARY_DB_URL'] end end
We may want to override this in development / test
# config/environments/development.rb module MyApp class Application < Rails::Application ... other configs config.secondary_database_url = 'SOME_CONNECTION_STRING' end end
Now to setup the class we'll have our models inherit from...
# lib/active_record/secondary.rb module ActiveRecord class Secondary < ActiveRecord::Base self.abstract_class = true # prior to AR 3.2.1 url = URI.parse( MyApp::Application.config.secondary_database_url ) establish_connection( :adapter => 'mysql', :host => url.host, :username => url.userinfo.split(':'), :password => url.userinfo.split(':'), :database => url.path[1..-1], :port => url.port || 3306 ) # as of AR 3.2.1 establish_connection(MyApp::Application.config.secondary_database_url) end class SecondaryMigration < ActiveRecord::Migration def connection ActiveRecord::Secondary.connection end end end