Recently I decided to use a separate Raspberry Pi 4 for my Z-Wave (Aeotec Gen 5) stick as well as Zigbee stick (Conbee II). As for now I plugged them in my Pi 4 where Hass OS is running and used Deconz and the Z-Wave integration. The goal is to place the Pi 4 with both sticks in an other floor instead of being limited to the place where the Pi 4 with Hass OS is.
So I setup both applications as per these awesome guides from flemmingss:
Everythings works fine (side-by-side) and I am really happy with this config, it is way better than Deconz and the Z-Wave integration. One downside is that I am using a SD-card and I concerned that the state/event changes shorten to life of the card dramatically.
I already moved the database for Hass OS on Maria DB running on a Synology. I asked myself it is also possible to move the database for both Zigbee2MQTT and Z-Wave2MQTT to Maria DB. Unfortunately I could not find much information in the internet. There were some attempts of a feature request but it hasnt really been answered. https://github.com/Koenkk/zigbee2mqtt/issues/4947
Has anyone already tried to move the database from these integrations in Maria DB? If not, is there anyone with knowledge on how to do so? I would be happy to assist in testing it, unfortunately I dont have much know-how on developing/programming.
thanks for the quick reply. do you mean on another storage like an attached SSD to the Pi 4 where Zigbee2MQTT and Z-Wave2MQTT runs? another option would be to run Docker on the NAS and attach both sticks to the NAS (in the hope that they are being recognized)
Yes, you could use an SSD attached to the Pi, or network storage like CIFS or NFS. Of course, once you start using network storage, you lose the “independence” you gain by using the Pi.
got ya, actually I already use a SSD for my HASS OS install, as I learned Zigbee2MQTT or Z-Wave2MQTT dont use any SQL-engine, so the SSD or network-storage is the only option.