# Opennebula 5.4: can sqlite be used for HA frontend setup?

**URL:** <https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633>\
**Category:** Product Support\
**Created:** [July 21, 2017, 11:42pm UTC](https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633 "2017-07-21T23:42:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcindulak](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@marcindulak](https://forum.opennebula.io/u/marcindulak)\
**Post date:** [July 21, 2017, 11:42pm UTC](https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633/1 "2017-07-21T23:42:23Z")

</div>

[https://docs.opennebula.org/5.4/advanced\_components/ha/frontend\_ha\_setup.html](https://docs.opennebula.org/5.4/advanced_components/ha/frontend_ha_setup.html)

Requirements state: Working database connection of the same type, MySQL is recommended.

---

<div class="post-metadata">

**Author:** ![atodorov\_storpool](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/atodorov_storpool/32/5327_2.png) [@atodorov\_storpool](https://forum.opennebula.io/u/atodorov_storpool)\
**Post date:** [July 22, 2017, 11:02am UTC](https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633/2 "2017-07-22T11:02:57Z")

</div>

Hi,

Still not tested it, but it should work. Also, there is a hint in the [release notes](http://docs.opennebula.org/5.4/intro_release_notes/release_notes/whats_new.html) too:

> In both cases (Federation and HA) no support is needed from MySQL to create a clustered DB, so admins can forget about MySQL replication.

If database replication is not needed there is no reason sqlite to not work.

Best Regards,  
Anton Todorov

---

<div class="post-metadata">

**Author:** ![ruben](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/ruben/32/19_2.png) [@ruben](https://forum.opennebula.io/u/ruben)\
**Post date:** [July 27, 2017, 8:02am UTC](https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633/3 "2017-07-27T08:02:53Z")

</div>

Yes it should work. It is better not to mix both backends (servers in MySQL, servers in sqlite), although it should work as SQL commands generated by oned are compatible for both backends this has not been tested.

Cheers

---

<div class="post-metadata">

**Author:** ![marcindulak](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@marcindulak](https://forum.opennebula.io/u/marcindulak)\
**Post date:** [August 8, 2017, 3:08pm UTC](https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633/4 "2017-08-08T15:08:38Z")

</div>

Frontend HA with sqlite seems to work initially for me in a test setup: [https://github.com/marcindulak/vagrant-opennebula-ha-tutorial-centos7](https://github.com/marcindulak/vagrant-opennebula-ha-tutorial-centos7)

---

<div class="post-metadata">

**Author:** ![ruben](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/ruben/32/19_2.png) [@ruben](https://forum.opennebula.io/u/ruben)\
**Post date:** [August 9, 2017, 2:21pm UTC](https://forum.opennebula.io/t/opennebula-5-4-can-sqlite-be-used-for-ha-frontend-setup/4633/5 "2017-08-09T14:21:19Z")

</div>

Yes it should work