How to connect 2 different hosts in mongodb

Question

I have a service in ruby and I trying to connect with two different hosts with two different databases

I'm trying something like this

mongoid.yml

development:
  clients:
    default:
      database: cpeTracking
      hosts:
       - development-shard.mongodb.net:27017
       - development-shard.mongodb.net:27017
       - development-shard.mongodb.net:27017
      options:
        user: my_user
        password: my_password
        auth_source: admin
        ssl: true
      database: testDb
        hosts:
        - localhost:27017

And my model

class Movies
  include Mongoid::Document
  include Mongoid::Attributes::Dynamic
  store_in database: "testDb"

  field :name, type: String
  field :year, type: Integer
  field :director, type: String
end

When I run the service, only connect with the first host. I also tried this solution Connecting to two databases Mongoid but didn't work

In your paste, all the hosts are the same though.

max pleaner
– max pleaner

2019-03-20 04:10:37 +00:00
Commented Mar 20, 2019 at 4:10 — max pleaner
– max pleaner, Commented Mar 20, 2019 at 4:10

Diego · Accepted Answer · 2019-03-20 19:53:25Z

I found the answer. First I have to create a new client at same level of default, I called it "secondary" with the info of database and host.

development:
  clients:
    default:
      database: my_db
      hosts:
        - development-shard.mongodb.net:27017
        - development-shard.mongodb.net:27017
        - development-shard.mongodb.net:27017
      options:
        user: my_user
        password: my_pass
        auth_source: admin
        ssl: true
    secondary:
      database: testDb
      hosts:
       - localhost:27017

Second. In the model I had to add the collection, the database and the client that will use

class Movies
  include Mongoid::Document
  include Mongoid::Attributes::Dynamic
  store_in collection: "movies", database: "testDb", client: "secondary"

  field :name, type: String
  field :year, type: Integer
  field :director, type: String
end

Collectives™ on Stack Overflow

How to connect 2 different hosts in mongodb

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related