Connecting to multiple databases in ruby on rails

by

For multiple database connection, you need to add the following codes to the database.yml file. Here, I am giving the example of connecting two databases from a rails application

config/database.yml

development:
  adapter: mysql2
  database: db1_dev
  username: root
  password: xyz
  host: localhost

development_sec:
  adapter: mysql2
  database: db2_dev
  username: root
  password: xyz
  host: localhost

production:
  adapter: mysql2
  database: db1_prod
  username: root
  password: xyz
  host: your-production-ip

production_sec:
  adapter: mysql2
  database: db2_prod
  username: root
  password: xyz
  host: your-production-ip

Here I have used two databases for the development and production environment.

Now we need to connect the model to databases. When you are running your application in development and production mode, all the models will be mapped through the development and production db parameters those been mentioned in your database.yml. So for some model we need to connect to other database.

Lets assume that, we have two models User and Category. The users table is in db1_dev and db1_prod, the categories table in db2_dev and db2_prod.

Category model

class Category < ActiveRecord::Base
  establish_connection "#{Rails.env}_sec".to_sym
end

Similarly, when you adding the new migration for the second database, need to add following code to it.

class CreateRewards < ActiveRecord::Migration
  def connection
    ActiveRecord::Base.establish_connection("#{Rails.env}_sec".to_sym).connection
  end

  def change
    # your code goes here.
  end
end

Hope it will work for you 🙂 .

More Related Contents:

  1. Difference between rake db:migrate db:reset and db:schema:load
  2. Rails :include vs. :joins
  3. Using Rails, how can I set my primary key to not be an integer-typed column?
  4. PG::ConnectionBad – could not connect to server: Connection refused
  5. Why can you not have a foreign key in a polymorphic association?
  6. Postgres could not connect to server
  7. Composite primary keys versus unique object ID field
  8. PG undefinedtable error relation users does not exist
  9. Alias for column names in Rails
  10. Change from SQLite to PostgreSQL in a fresh Rails project
  11. Multiple databases in Rails
  12. What is the best way to seed a database in Rails?
  13. Cannot add a NOT NULL column with default value NULL in Sqlite3
  14. A migration to add unique constraint to a combination of columns
  15. Using Rails Migration on different database than standard “production” or “development”
  16. How do I set up the database.yml file in Rails?
  17. delete_all vs destroy_all?
  18. How to implement Active Record inheritance in Ruby on Rails?
  19. How do I avoid a race condition in my Rails app?
  20. Rails: store translations in database
  21. Convert url from https to http [closed]
  22. Rails ExecJS::ProgramError in Pages#home?
  23. Nested attributes unpermitted parameters
  24. Is there a clean way to avoid calling a method on nil in a nested params hash? [duplicate]
  25. Rails 3, has_one / has_many with lambda condition
  26. Validation for URL/Domain using Regex? (Rails)
  27. Form Submit button only works after reload
  28. Controller spec unknown keyword: id
  29. Best way to generate slugs (human-readable IDs) in Rails
  30. unable to install pg gem

Leave a Comment