# Using 2 nodes with 2 different DB servers
**URL:** https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943
**Category:** General
**Tags:** database
**Created:** [24 February 2022 18:54 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943 "2022-02-24T18:54:37Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@ebolisa](https://discourse.nodered.org/u/ebolisa)
#### Post date: [24 February 2022 18:54 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/1 "2022-02-24T18:54:38Z")
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
---
### Author:  [@knolleary](https://discourse.nodered.org/u/knolleary)
#### Post date: [24 February 2022 19:06 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/2 "2022-02-24T19:06:44Z")
Which database node are you using?
---
### Author:  [@ebolisa](https://discourse.nodered.org/u/ebolisa)
#### Post date: [24 February 2022 19:14 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/3 "2022-02-24T19:14:50Z")
Sorry, forgot to mention it: mysql.
---
### Author:  [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [24 February 2022 20:08 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/4 "2022-02-24T20:08:09Z")
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)
---
### Author:  [@ebolisa](https://discourse.nodered.org/u/ebolisa)
#### Post date: [24 February 2022 22:35 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/5 "2022-02-24T22:35:04Z")
I did that by following a prior post ([https://discourse.nodered.org/t/two-different-sqlite3-databases-in-one-flow/41601/2?u=ebolisa](https://discourse.nodered.org/t/two-different-sqlite3-databases-in-one-flow/41601/2)) with no avail. Maybe because I'm using two different servers not two instances.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [24 February 2022 22:40 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/6 "2022-02-24T22:40:47Z")
> [@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?
---
### Author:  [@ebolisa](https://discourse.nodered.org/u/ebolisa)
#### Post date: [24 February 2022 22:57 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/7 "2022-02-24T22:57:26Z")
Yes. I used one mysql node with two entries, but I've to choose only one at the time for it to work.
---
### Author:  [@ebolisa](https://discourse.nodered.org/u/ebolisa)
#### Post date: [24 February 2022 23:12 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/8 "2022-02-24T23:12:47Z")
Ok, I separed the nodes maintaining the multiple config and worked!!
Thank you!
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [10 March 2022 23:12 UTC](https://discourse.nodered.org/t/using-2-nodes-with-2-different-db-servers/58943/9 "2022-03-10T23:12:51Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.