Connecting Rails 3.1 with Multiple Databases

To Wukerplank’s answer, you can also put the connection details in database.yml like usual with a name like so: log_database_production: adapter: mysql host: other_host username: logmein password: supersecret database: logs Then in your special model: class AccessLog < ActiveRecord::Base establish_connection “log_database_#{Rails.env}”.to_sym end To keep those pesky credentials from being in your application code. Edit: If … Read more