# HA with Rqlite/Dqlite and Node-RED?

**URL:** <https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033>\
**Category:** General\
**Created:** [11 June 2021 13:58 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033 "2021-06-11T13:58:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![janedoe123](https://avatars.discourse-cdn.com/v4/letter/j/b19c9b/32.png) [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Post date:** [11 June 2021 13:58 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/1 "2021-06-11T13:58:48Z")

</div>

Hi all

I've buillt a small rqlite cluster (3 nodes) and I would like to use the sqlite node to connect to it.

Since this database is a distant one (I.e. not running in the same server where node-red runs) and provides HA, how can I fill in the "Database name" field of the sqlite node in node-RED?

Thanks

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [11 June 2021 14:41 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/2 "2021-06-11T14:41:00Z")

</div>

Something like this, ipaddress, path and filename.

```auto
192.168.1.127/home/pi/dbs/joshuadata.sqlite

```

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [11 June 2021 15:15 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/3 "2021-06-11T15:15:57Z")

</div>

I'd be interested in this - is there any more info ? Like which server (rqlite or dqlite) are you actually using ? I thought you had to use http to access rqlite ?

---

<div class="post-metadata">

**Author:** ![janedoe123](https://avatars.discourse-cdn.com/v4/letter/j/b19c9b/32.png) [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Post date:** [11 June 2021 15:25 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/4 "2021-06-11T15:25:27Z")

</div>

Ho wow thanks! I didn't know it would be that simple.

Are you using rqlite or dqlite with node-red ?

---

<div class="post-metadata">

**Author:** ![janedoe123](https://avatars.discourse-cdn.com/v4/letter/j/b19c9b/32.png) [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Post date:** [12 June 2021 01:07 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/5 "2021-06-12T01:07:14Z")

</div>

Small up 🙂 is it better to use a MySQL high availability cluster with my-SQL node instead?

Or... can we use rqlite with http node instead ?

---

<div class="post-metadata">

**Author:** ![janedoe123](https://avatars.discourse-cdn.com/v4/letter/j/b19c9b/32.png) [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Post date:** [16 June 2021 07:12 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/6 "2021-06-16T07:12:19Z")

</div>

@dceejay if you are interested,

I created flows to use RQLite with Node-RED, with HTTP nodes + HTTP 301 redirect support.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [15 August 2021 07:13 UTC](https://discourse.nodered.org/t/ha-with-rqlite-dqlite-and-node-red/47033/7 "2021-08-15T07:13:13Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.