Hi, Is possible to read data from two different database servers? I created two different mysql nodes, each connecting to its database and they do work individually, but if I enable both of them, one node changes its configuration by taking over the other node's settings. TIA [Cap]

When you edit one of the nodes make sure you click the down arrow and select Add new Database in order to set up the second connection. (and then make sure each the nodes are configured to point to different ones) [image]

Which database node are you using?

Sorry, forgot to mention it: mysql.

[image] ebolisa: no avail. Maybe because I'm using two different servers not two instances. That should not matter. It should work with multiple configs. Does your drop-down have 2 entries, set for different servers?

Yes. I used one mysql node with two entries, but I've to choose only one at the time for it to work. [Captura]

Ok, I separed the nodes maintaining the multiple config and worked!! Thank you! [Captura]

Using 2 nodes with 2 different DB servers

General

ebolisa 24 February 2022 22:35 5

I did that by following a prior post (https://discourse.nodered.org/t/two-different-sqlite3-databases-in-one-flow/41601/2?u=ebolisa) with no avail. Maybe because I'm using two different servers not two instances.

Topic		Replies	Views
MSSQL 2 instances same server, 2 different databases General	11	2039	27 May 2019
MYSQL - Some connect and some don't General	13	454	13 February 2021
Connect to multiple oracle DB's General	3	555	2 November 2020
Influx DB Out node with two databases General	5	985	13 May 2019
Please contact us regarding Postgres settings General	2	298	11 December 2020

Using 2 nodes with 2 different DB servers

Related topics