# Is it possible to configure only one database?

**URL:** <https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179>\
**Category:** Module Development\
**Tags:** perspective, database, ignition81\
**Created:** [May 3, 2023, 5:59am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179 "2023-05-03T05:59:15Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![KIM\_SUNG\_HOO](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@KIM\_SUNG\_HOO](https://forum.inductiveautomation.com/u/KIM_SUNG_HOO)\
**Post date:** [May 3, 2023, 5:59am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/1 "2023-05-03T05:59:15Z")

</div>

hi.

There are a few questions about configuring the system.

first, I am trying to configure two ignition servers up to redundancy. Is it possible to link two servers with one database?

second, I am trying to configure the database as a separate hardware. Is it possible? (It is not a database inside the server.) If possible, is there a set model?

third, I can purchase the SQL Bridge module on the server, but what do you need to prepare for the database?

thanks for reading.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 3, 2023, 12:19pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/2 "2023-05-03T12:19:58Z")

</div>

> [@KIM\_SUNG\_HOO](#):
>
> Is it possible to link two servers with one database?

Yes, and recommended for redundancy. The DB itself should handle its own redundancy/high availability functionality.

> [@KIM\_SUNG\_HOO](#):
>
> database as a separate hardware

Yes, and **highly** recommended for production.

> [@KIM\_SUNG\_HOO](#):
>
> prepare for the database?

Nothing beyond the normal permissions (including table creation) for the user account Ignition connects with. The SQL Bridge module can create/alter tables for you within the transaction group operation.

---

<div class="post-metadata">

**Author:** ![KIM\_SUNG\_HOO](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@KIM\_SUNG\_HOO](https://forum.inductiveautomation.com/u/KIM_SUNG_HOO)\
**Post date:** [May 4, 2023, 1:05am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/3 "2023-05-04T01:05:18Z")

</div>

thanks for the answer.

Can you recommend a database model?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 4, 2023, 1:20am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/4 "2023-05-04T01:20:18Z")

</div>

> [@KIM\_SUNG\_HOO](#):
>
> a database model

Model? Module? What do you mean by "database model"?

---

<div class="post-metadata">

**Author:** ![KIM\_SUNG\_HOO](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@KIM\_SUNG\_HOO](https://forum.inductiveautomation.com/u/KIM_SUNG_HOO)\
**Post date:** [May 4, 2023, 1:33am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/5 "2023-05-04T01:33:28Z")

</div>

I'm curious about the model of the database I'm trying to configure with external hardware. The hardware model is correct.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 4, 2023, 2:56pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/6 "2023-05-04T14:56:59Z")

</div>

> [@KIM\_SUNG\_HOO](#):
>
> I'm curious about the **model** of the database ...

You didn't explain what you mean by "model". Maybe you mean brand? e.g., Oracle, MySQL, MariaDB, MS-SQL, PostreSQL, etc.

---

<div class="post-metadata">

**Author:** ![KIM\_SUNG\_HOO](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@KIM\_SUNG\_HOO](https://forum.inductiveautomation.com/u/KIM_SUNG_HOO)\
**Post date:** [May 7, 2023, 11:29pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/7 "2023-05-07T23:29:44Z")

</div>

> [@Transistor](#):
>
> Maybe you mean brand?

No, it mean HP, DELL etc . hardware brand.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 7, 2023, 11:41pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/8 "2023-05-07T23:41:21Z")

</div>

> [@KIM\_SUNG\_HOO](#):
>
> hardware brand.

Ignition doesn't care about hardware brand.

---

<div class="post-metadata">

**Author:** ![KIM\_SUNG\_HOO](https://avatars.discourse-cdn.com/v4/letter/k/977dab/32.png) [@KIM\_SUNG\_HOO](https://forum.inductiveautomation.com/u/KIM_SUNG_HOO)\
**Post date:** [May 8, 2023, 12:11am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-only-one-database/73179/9 "2023-05-08T00:11:23Z")

</div>

> [@pturmel](#):
>
> Ignition doesn't care about hardware brand.

okay. thanks for answers. 🙂
