search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
33.95k stars 3.66k forks source link

[Feature]: Mongo connection to a specific node #19769

Open felix-appsmith opened 1 year ago

felix-appsmith commented 1 year ago

Is there an existing issue for this?

Description

The problem presented is that when trying to connect from Appsmith to a specific node of my Mongo atlas replica, it executes the queries in the main node; however, if I make the connection to the same URI from Mongo compass, the queries are executed in the specified node.

Steps To Reproduce

  1. Create a Mongo replica in Mongo Atlas.

  2. Connect with the following URI to your cluster from Appsmith mongodb+srv://<User>:<Password>@<Host>/learningdb?appname=appsmith&readpreference=secondary&retrywrites=true&authsource=admin&minpoolsize=0

  3. Connect with the same URI but from Mongo compass.

  4. In Mongo atlas connect, see the View Monitoring.

  5. Run a simple query from Appsmith and see how it runs on the main node.

  6. Now eject a query from Mongo compass and see what it looks like if it is ejected on the specified node.

We attach a demo video made by a user: Video

Public Sample App

No response

Issue video log

https://www.loom.com/share/e195b22bb6e34e23802e8a8481218667

Version

Appsmith v1.8.16-SNAPSHOT

Front logo Front conversations

pruthvi-itribe commented 1 year ago

Hi, Any update on this issue ?

pruthvi-itribe commented 1 year ago

Hey, any update on this ? is there a work around?

sribalajig commented 1 year ago

@pruthvi-itribe I am from the Appsmith product team. We are picking this up for investigation, we will get back to you.

pruthvi-itribe commented 1 year ago

Thanks @sribalajig, do we have an ETA for this to be done ?

daaliachhak17 commented 2 months ago

hi-what is the status of this issue? please let us know if we have to pick this up?

Nikhil-Nandagopal commented 2 months ago

@daaliachhak17 are you confident in the solution for this issue? It seems too complicated for an external contribution. I suggest picking up issues marked as "Inviting Contribution"