Using 2 nodes with 2 different DB servers

[ebolisa]

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

[knolleary]

Which database node are you using?

[ebolisa]

Sorry, forgot to mention it: mysql.

[dceejay]

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)

[ebolisa]

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.

[Steve-Mcl]

@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?

[ebolisa]

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

[ebolisa]

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