how do i connect 3 node Mongo 4.2 DB cluster where i have replica set as well.

Question

how do i connect 3 node Mongo 4.2 DB cluster where i have replica set as well.I am configuring controller. i found old KB

https://community.alteryx.com/t5/Alteryx-Server-Discussions/connect-alteryx-server-to-mongodb-replica-set/m-p/28442

replicaset/Ip:port, IP:port, it is working.

Also,

can i use new URI  for host :
"mongodb1.example.com:27317,mongodb2.example.com:27017/?replicaSet=mySet&authSource=authDB"

Chandler_Bing · Answer

hi @hdkarki

Are you trying to configure standalone gallery  with Mongo 3 set replica?

If thats the case then u should remove rs0 from the replica set.

eg: For controller u will configure it as rs0\replicaaset1:27017,replicaset2:27017,replicaset3:27017

But for gallery it will be : replicaset1:27017,replicaset2:27017,replicaset3:27017

Hope this helps

Samuel_To · Answer

Hi @hdkarki ,

Gallery will not connect to MongoDB directly.

In the system config, it just need to input the controller host name.

For the URL of Alteryx Gallery, it should be https://hostname/gallery or https://DNSname/gallery.

Best Regards,

Samuel

hdkarki · Answer

I have Alteryx server installed on Windows server and mongo db (3 node) installed on Linux server with replica set.  Controller works with replicatset/host:port, host:port but gallery is not working