Going to next level of Aquarium Automation...who's with me?

Well since my reef angel water level sensor seems to be acting up and the joystick on it has stopped working I think its time to move it all over to homeassistant.

I have a spare pi2 that will probably suffice for the separate aquarium functions. I guess where I plan on starting is switching the auto top off to homeassistant. I wanted to use the sonic distance sensors set up through ESPhome but I’m wondering if that is the best method? With my reef angel it used a water level sensor that would measure pressure in a pvc tube (there’s probably a way to migrate these over to homeassistant but I haven’t looked into that.)

What’s everyone think the best idea is for auto top off?

1 Like

The pressure based PVC tube sounds interesting. If it uses 1-wire or I2C or something like that, it should be easy to migrate over, I think.

I simply use multiple float sensors, both vertical and horizontal versions, and haven’t had any problems with them in 3 years. I do have places to mount those sensors which are mostly salt-creep free zones. That said, I used to have two different Tunze Osmolators in our aquarium setup in our old pre-2005 house, and in that setup, there was no salt-creep free zones as it was a very small setup. And still, the Osmolators optical sensor still ended up with gunk and overflowed a few times.

I can explain what I’ve done in my current setup and you can decide from there.

This is the detailed (normally hidden) overview panel of all my water level sensors:

Normal Ops Waterlevel: This is a horizontal (thru-hole design) swing arm float valve design, which I mounted on a recycled Mag-Glass Cleaner, that way it’s very secure, but easily adjustable and/or relocatable. This sensor is set to the height I want to maintain the water level at when all pumps are ON. The magnet had become too weak for the thick glass on my 1000 litre tank, but on my plastic tub sump, which is very thin relative to the glass, the mag has a lot of holding power. When the sensor measures low, then the Reverse Osmosis Top Up dosing pump is activated. (Bonus Feature with this sensor: Not only does this control RO Water Top off, but if the Saltwater Transfer Pump is activated while the Main Circulation Pump is running, it will cut off the Saltwater Transfer Pump once the sensor triggers. This is handy when I scoop out either large corals, rocks or water from the display aquariums in the next room - particularly if I’m vacuuming the sand-bed. Then without having to leave what I’m doing in the Living room, I can toggle the Transfer Pump to replace the lost water/mass I took out of one of the display aquariums and HA will take over turning the pump off. (Before HA, I used to have to run back and forth between rooms to do this manually.)

Sump Overflow Status: Again, a thro-hole swing arm sensor which is permanently mounted into the side of the plastic tub. This is set to the “Oh F***!!!” Water-level, which is what you might say when water is just 2cm from the top of the sump and still rising. When this activates, Home Assistant heroically and valiantly turns on the Purge Sump Pump, only de-activating the Purge Sump Pump when the sensor indicates it’s returned to returned to sane levels for more than 15 seconds. This sensor also activates a WAV file of a specific “fish ops alarm” to be played throughout the house & TTS spoken description of what alarm event has occurred and what to do (for like house / tank sitters, etc.). And push notifications to my phone.

Sump Full Cutoff Status: Same sensor and mounting as above, but this is mounted just a little below the Overflow Status sensor, and is used mainly for Automated Batch Water Changes. (FWIW, I also have Automated Continuous Water Changes using dosers also setup, but now I digress). This is used to cut off the Saltwater Transfer Pump from my 180L mixing barrel during batch water change operations. This also triggers informational TTS and sound effect alarms & push notifications.

What is not listed here, but is an important part of my Redundancy; I already had two Aqua-Medic Auto-Top-Up dosing pumps with vertical float sensors. I installed both of theses, dedicating one to use for Reverse Osmosis Top Up, and the other for Kalkwasser Top Up. Each pump is hardwired to it’s own vertical float sensor and I mounted both of these about 1-2 inches above the level the HA controlled swing arm sensor is mounted. This way, if that HA sensor fails (or let’s assume that HA RPI fails), the vertical sensor of the AquaMedic Dosers will act as a backup. The power lines from the Aqua Medic Dosers are plugged into one of my network controlled powerbars which HA integrates with and controls.

Salt Water Mix Status: same sensor and perm mounting on my 180ltr mixing barrel, because even the filling of the barrel is automated by Home Assistant. (Literally, I pour in 5 litre size cups of Salt, close the top, hit the Mix Salt & WaterChange function on Home Assistant and walk away. Home Assistant fills the barrel, mixes the salt, brings it to temp, and then executes the whole batch water change process.

Skimmate Bucket Status: Again, I choose for the swing arm designs here because I find them the most resilient / reliable design. And the stuff collected in this 20 litre bucket can get quite gunky. When water level is achieved (approx half full), it simply pumps the bucket down the drain. The size of this bucket is a hold-over from the days I used to empty this manually approx every other week. Notifications occur so I can easily tell if it’s not pumping / purging on a bi-weekly basis, something has gone wrong / needs cleaning. :slight_smile:

Salt creep isn’t a problem on my aquariums, and here I use standard vertical sensors, which is the rest of the sensors on this list. However, these do get a fair amount of use. I have a healthy self-sustaining population of snails. And I have 4 x 40cm pipes under the floor, making runs as long as 15 meters (x4) of pipes between 3 Aquariums in the Living & Dining rooms, and the sump / refuge / working tanks located in the dedicated fishland infrastructure room. And big snails can create quite a drag on the currents in those returns back to the sump. Once in a blue moon, an air bubble can get down there and slow things down. So if any of these trigger for longer than 30 seconds, Alarms start playing announcing in 30 seconds the main circulation pump between the tanks will be cut off, and then it does it. If the water level returns to normal, it’ll wait 60 seconds and alarm that it’s going to fire the pump back up again, and repeat this process up to 5 times in an attempt to clear the line. If it cannot succeed it stops trying and waits for manual intervention.

Next stop - Kalkwasser as a component of AutoTopUp
This is my detailed control panel for all Top Up functions, including Kalkwasser

Originally, I had Kalkwasser in serial with RO water. Meaning, it would dose Kalkwasser up to the setup point and switch over to RO once it hit the dialled in amount. But what would happen, particularly in spring and fall, it would end up dosing Kalkwasser still throughout the Light On period, since not as much water would evaporate during the evenings / night. So now it works in parallel during the night from 12am until 12PM (my tank lights come on at 2pm and go off at 11pm). This balances my pH Day/Night shifts a lot better.

And all the important stuff described above is minimised and displayed more succinctly on my Dashboard overview like this (I have another page tab for detailed controls view separate from the Dashboard monitoring view. Because 5 x cats & keyboards are bad mix.):

Oh, and of course, I have HA to raise alarms (and attempt a shutoff) if for some-reason the AutoTopUp runs for more than 2 hours. The advantage of using dosers to do auto-top up is when they go wrong, they go wrong in slow-motion; giving on the benefit of time to detect and react to those undesirable events, before they become incidents and impacts. :smiley: Additionally, as you’ve probably noticed, you can also calculate / track how much water you’re consuming as a factor of evaporation that way.

A thought for your ideas…why not use both Sonic sensor and float sensor together? You could have your float sensor as the actual control, and create a sanity check in Home Assistant using your Sonic sensor to raise an alarm if they disagree. If they agree, run normal TopUp functions. And you get precise information what your water levels are to boot.

1 Like

Curious on how you got Free Ammonia and Ammonium levels in your tank? I have a freshwater tank I am attempting to do the same. So far my system has 2 temp readings, IR controller for lights, TD Sensor, display for showing tank properties, water leak sensor, and warning light. All this controlled with a ESP32. I was killing myself trying to find the ammonia levels in tanks. Any help on that?

Hey @agengr1293,

Apologies for the delayed response; I just now saw your inquiry. I think something went wrong with notifications or something.

Yeah, the NH3 monitoring I’m doing is from the Seneye Sensor.

Do you have one of these? Did you setup the integration component? Details about that integration can be found here.

https://community.home-assistant.io/t/adding-support-for-seneye-aquarium-pond-sensors-removing-the-need-for-a-seneye-web-server/

This is my first code on Python :)))

Hey @Xinil I’m going to rope you back over onto the main thread since the High Availability topic is a bit off-topic for the Autodoser thread, if that’s okay with you. I’ll quote your latest comment on the autodoser thread here, just to make it easier to follow.

Thanks so much for the detailed walkthrough of your home system, cowboy! You’ve got an amazing setup and a seriously impressive workflow of failure-triggers, backups and redundancies.

You’re welcome. :slight_smile:

FWIW, this setup began itself life in 2003 as a single 250litre tank which I adopted from a previous owner who was moving back to Germany. In a way, it was more of a rescue case as they had let it fall into neglect and it had Old Tank Syndrome after 5 years, and just wanted to get rid of it all. I nursed it back to health, and started growing it out slowly by just adding more and more tanks to the overall system through the years. At some point, I realised I had so much time and labor invested in it, I really wanted to have the same kind of reliability in the aquarium automation controller that I was familiar with building in my day job working at mobile phone network operators, where network & system uptime HAS to be better than 99.97% available. And I’d already been scratching my head wondering why wasn’t there any commercial or open source aquarium controller that offered this kind of guarantee. Since there wasn’t any, that’s why I resorted to building it myself.

First things first, I need to set up a secondary/backup HA! I don’t know why I haven’t done this yet but I guess I needed to see other people doing it first to know it was possible. I run HA in a VM as well using the qcow2 image. So my plan would be to install HA on a separate machine (I have two Unraid servers each running VMs/dockers) and set up a similar set of ‘secondary node conditions’ so that nothing runs without first confirming the primary is down. Do you have any more details on how you set up those conditions? I use Node-Red/MQTT for 90% of my automations.

Well, if you have two Unraid servers running their own VM/docker containers, you’ve already got a good base to work from. I can’t advise on Unraid as I use XCP-NG (XenCloudPlatform-NextGen) as my VM hosts, largely due to 1.) I was already familiar with Citrix XenServer at the GSM Mobile phone companies I worked at, and 2.) XCP-NG had just launched as an open source project with intentions to reclaim Xen back from Citrix who was moving at the time to make Xen Server more proprietary and closed source, and 3.) If one builds the XenOrchestra Community Edition management tool from the sources (which is pretty easy), then one get’s ALL the enterprise management tools like Live Migrations between hosts & full backup suite and other functionalities.

One thing I forgot to mention in my previous reply, is for my VM install of HA, I actually broke out the Home Assistant DB SQL server & MQTT server into their own dedicated VMs, for a few reasons, and recommend others do the same. My primary HA node which runs on my VM, is the one node that runs all critical (i.e.- aquarium automations) and non-critical (i.e.-streaming beach & sunset cams, etc.) functions when everything is working properly. I want to keep a very long DB history (several months-to-a-year) of water parameters, and automation history, which I don’t want to lose if I use a snapshot / backup restore function of the Home Assistant VM itself.

Further, the reason for doing this for the MQTT server is that I want the other RaspberryPi nodes to be able to talk to each other, even if the VM HA host goes down or is being rebooted or upgraded. I’ve found that Mosquito MQTT server is very fast and very reliable in practice, but in that extremely rare case that it were to crash, my XCP-NG box is setup to reboot it (which takes just like 15 seconds) or spin it up on my secondary XCP-NG host. (I won’t go into detail here, but there is a way to have a redundant installation of MQTT server on a RaspberryPi in a cold-standby mode that only fires up if the primary MQTT server were to fail, but I do not use that at this time.)

I also do not use Node-Red at all. By the time I saw more people were starting to do this, I had become quite comfortable doing all my automations natively in YAML on HA and felt that NodeRed would just add more complexity to my solution, which I wanted to avoid. It might be possible to do this using NodeRed, but being I’ve never used it, I can’t advise on that myself.

I also thought Zwave was limiting / blocking in its capabilities and reliability. Others have had better experience with Zwave, but in my limited trials with an Aeotec Zwave dongle and one single Aeotec SmartSocket6 hooked up to our coffee maker, I had to many Zwave network issues despite the dongle & smart socket just being a few meters apart & clear line of sight. Also, since the dongle has to be plugged into a host, if said host were to die in the middle of the night, this could present problems. I found HTTP, MQTT and SNMP much more flexible, reliable and scalable in this regards compared to Zwave.

For the High Availability functions, I broke out each function as much as possible / practical to do so, for more granularity of control, specifically disabling specific HA-HA automations should the need arise, without disabling the full suite of HA-HA functions. For instance, maybe I want to turn off the Sound Alert automations for a failure, without disabling the shutdown of of the autodosers themselves.

For example, this is the function to safely shutdown any/all dosing operations (with extreme prejudice - i.e.- I just assume they may be running, rather than testing to see if they are running) if one of my RaspberryPi HA-HA nodes detects either the VM Host has gone offline, or if the HA VM has gone offline or if the HA application itself has stopped sending MQTT heartbeat signals.

  • alias: “NETMON: VM Node OFFLINE Doser Shutdown”
    initial_state: true
    trigger:

    • platform: state
      entity_id: sensor.vmhost_tracker
      to: ‘OFFLINE’
      for:
      seconds: 30
    • platform: state
      entity_id: sensor.ha_vm_tracker
      to: ‘OFFLINE’
      for:
      seconds: 30
    • platform: state
      entity_id: sensor.ha_vm_mqtt_heartbeat
      to: ‘OFFLINE’
      for:
      seconds: 30
    • platform: homeassistant
      event: start
      condition:
      condition: or
      conditions:
      • condition: state
        entity_id: sensor.vmhost_tracker
        state: ‘OFFLINE’
      • condition: state
        entity_id: sensor.ha_vm_tracker
        state: ‘OFFLINE’
      • condition: state
        entity_id: sensor.ha_vm_mqtt_heartbeat
        state: ‘OFFLINE’
        action:
    • service: switch.turn_off
      entity_id: switch.reefdoser1_pump1
    • service: switch.turn_off
      entity_id: switch.reefdoser1_pump2
    • service: switch.turn_off
      entity_id: switch.reefdoser1_pump3
    • service: switch.turn_off
      entity_id: switch.reefdoser1_pump4
    • service: switch.turn_off
  • alias: “NETMON: VM Node OFFLINE Sound Klaxons Voice Prompts”
    initial_state: true
    trigger:

    • platform: state
      entity_id: sensor.vmhost_tracker
      to: ‘OFFLINE’
      for:
      seconds: 30
    • platform: state
      entity_id: sensor.ha_vm_tracker
      to: ‘OFFLINE’
      for:
      seconds: 30
    • platform: state
      entity_id: sensor.ha_vm_mqtt_heartbeat
      to: ‘OFFLINE’
      for:
      seconds: 30
    • platform: homeassistant
      event: start
      condition:
      condition: or
      conditions:
      • condition: state
        entity_id: sensor.vmhost_tracker
        state: ‘OFFLINE’
      • condition: state
        entity_id: sensor.ha_vm_tracker
        state: ‘OFFLINE’
      • condition: state
        entity_id: sensor.ha_vm_mqtt_heartbeat
        state: ‘OFFLINE’
        action:
    • service: media_player.volume_set
      data_template:
      entity_id: media_player.node2_speaker
      volume_level: “1”
    • service: shell_command.vmhost_offline_siren
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’
    • service: shell_command.vmhost_offline_announcement
    • delay: ‘00:00:06’

So as you can see, while the triggers are the same, the automation actions (and automation labels) are different for that greater granularity of control - I can turn off a specific High Availability or Alarm function while leaving the rest remaining. This is useful for debugging, testing and even at times, during upgrades (because I tend to upgrade one host at a time).

BTW, in my professional experience, I’ve seen VM Host network stacks do a “half-crash” - where the VM’s keep running & can keep talking to each other & keep existing open connections to external boxes open, but any new connections made from an external box to a VM host get denied / dropped. It’s an extremely rare condition, but having seen it happen in enterprise environments, that is why I reply on pinging the VM host, the VM container, and an MQTT heartbeat from the VM container - this can reveal the nature of the failure that occurred & how to react.

Like the above examples, I have another automation with the same triggers but a different automation action that toggles an input boolean for the locally implemented (on that RaspberryPi) autodoser automations. These local automations are the very same ones which are already shared on the AutoDoser thread with an extra condition added for that input boolean so they do not run unless the boolean is activated. The trigger also has a longer timeout (10 minutes) so that the dosers are not run from a secondary node in the event I’m just rebooting the VM (30-40 seconds) or VM host (5-6 minutes).

As for dosing…there’s a lot of consider. I’ve already installed a Reef Pi (running on a Pi Zero) and I have a pH probe reporting to my HA system. it works wonderfully.

FWIW, I investigated the ReefPi project, but at the time (end of 2016/early 2017) it had appeared the project development had stalled & documentation was kinda spotty, so I didn’t pursue that. However, I am glad to see it got picked up again and is moving forward once again. I’m familiar with several people on this thread here, whom have integrated the ReefPi with HA so I know it’s totally doable, but I never got into it myself.

Another contributor ended up writing the code to natively support Seneye devices (which I have 3 of) and I’ve been happy with that path the last few years for pH and NH3 Ammonia monitoring.

Given I can do more with this Reef Pi, my two options are:

A) Add a Reef Pi doser and make it part of that system - independent of HA and open to failures on its own (adding redundancy here seems very difficult and I’m honestly very if the risk is worth the ‘simplicity’ reward.)

or B) get an AC powered doser and trigger it via HA and Z-wave. I need to set up my secondary HA before I’d be comfortable going down this route.

I can’t comment much for option A, but could speculate if you go this route, you have two sub options with this path - run the doser logic from HA through ReefPi or have the doser logic run natively in ReefPi itself.

For option B, there’s two options actually - you can buy a Sonoff 4CH that supports just AC switching (my existing doser was AC…so the choice was that) or if you want to use DC pumps, Sonoff makes a variant of the 4CH that is AC/DC switching compatible.

What I can say is while MQTT is extremely fast, it’s not atomic fast. There is a tiny, tiny bit of network latency. In practice, and because my dosing pumps pump rather slowly (just 0.41667ml every 1 second for my MG/CA/Alk/Iron dosers & double that for my Reverse Osmosis and Kalkwasser dosers) this tiny bit of latency doesn’t translate into much in the way of variation. For instance, my Kalkwasser is set to dose 6 Liters over the night period, split up 12 times every hour. At the end of the day in practice, this comes out to maybe 6002ml dosed one day, the next day might be 5997ml, the next day it might be 5999ml, etc. So the deviation in practice is quite small. The smallest amount of daily dosing is the Iron doser, which is set to 22ml a day - in practice, the daily deviation is less than just 0.2ml (i.e. - 21.85ml, 21.92ml, 22.05ml, etc.). In practice, these tiny deviations do not make themselves apparent in my chemistry testing of my reef. In fact, my Iron has ridden the last 3+ years extremely stable at my target of 0.1ppm. And I would expect they wouldn’t be measurable in your smaller system either, however, I do want to be very honest and transparent about this.

On the flip side, I can imagine some of that latency is also from the Linux OS itself, as Linux is not an atomic real time OS, so it’s possible even with direct hardwired GPIO from a ReefPi, you might still see some tiny bit of latency & variation in what actually gets dosed.

One way around this would be to implement the doser control logic directly on the ESP chip of the Sonoff 4CH itself & simply use HA to push the variable runtime parameters to the ESP chip. I just never got around to doing this myself, because I’ve not come across the need to have that level of accuracy.

But you do have lots of options to choose from for your own implementation here, I think. :slight_smile:

I hope that helps in deciding which way you want to go. Again, keep us updated what you decide and how your implementation goes. I always appreciate hearing about other people’s journeys with this, and if you feel inclined to do so, feel free to share a few pictures of your Tank and your HA solution implementation.

1 Like

@cowboy, although I have nothing to do with aquarium automation, I really do appreciate how you have explained your setup and the redundancies that are in place. I was wondering if you have done any posts or blogs on the methods you have done for these?

Just on here on the Home Assistant Community Forum, on Facebook in different Aquarium and HA groups (i.e.- ReefControl, MyReef, etc.) and was just invited to start blogging on the ReefHacks website.

2 Likes

Hi @cowboy , sorry, I mean’t have you posted anywhere about how you did the redundancies for HA itself, not so much about the aquarium automations, if that makes sense?

That’s what I was answering you about - the redundancies. I’ve described them in the above thread, and on the other forums I described in my first reply to you.

When I first sat out to do this, nobody in the home automation / aquarium automation sphere was doing anything like this; commercial or open source. In 2017, most people on HA were still just automating lights and media centres; High Availability seemed over kill for a lot of people just beginning with HA, which was also a much smaller user base back then. Most were just annoyed SmartThings and some other IoT clouds weren’t even 95% available. Aquariums are a little more mission critical than lights and media centres however, and so that’s why I posted & described my builds there; that’s where the larger potential audience came from.

On the flip side, I knew home automation user base would come, eventually. Once HA gets embedded in people’s lifestyles, when support for more mission critical devices like Diabetic and Health monitors got picked up & depended on, more interests would eventually come for HA-HA implementations. And it finally seems interest in Application Level redundancies is growing, finally.

What’s your use case? What kind of High Availability solution are you looking for?

My setup is by no means as critical as yours. I run all the house automation, which includes lighting, fans, etc. Some purely rely on MQTT & HA to function (I know, I know, it was a mistake). So I guess breaking out as many things as possible would be better to ensure the load on HA is low. I would eventually like to have the DB & MQTT server on it’s own. If there was a way of HA having a redundancy itself, then I would also look at that.

For the time being, I have 2 separate machines running that I could duplicate what I need to on each. One currently runs Proxmox and the other Unraid.

I guess if you have anything written up on your methods of doing what you have done that I can also implement, I would be interested :wink:

Apologies in advance if the answer is yes, but did you happen to read the reply I made to Xinil just 10 days ago? In fact, it was right before your initial post to me. The context function is about liquid dosing pumps, but the method is easily carried over to lights, sprinkler systems, media centres, coffee pots, deep fryers, etc.

And for what it’s worth, I don’t think pure HA / MQTT is a mistake (although I’m curious why you think so?). In some ways, it makes the setup of Application Layer implementation of High Availability a bit easier, as all instances of HA can be subscribed to the same topic (say Temp data from a specific probe which controls your home heater/AC) and your default primary HA VM node can be setup to act on that data, while your secondary HA VM node will only act on that Temp data when the primary HA node is offline, or fails to function properly within a certain time period.

And that latter point, is one of the strengths of Application layer High Availability offers over and above VM based High Availability. With VM based High Availability, I can set triggers to reboot a VM if that VM crashes or kernel panics, but it doesn’t give me the ability to sanity check the logic and functioning health of the Application itself. Application layer High Availability can be setup to constantly sanity check and monitor the functioning health of another node’s application and/or OS VM.

This is very similar to the Space Shuttle or Crew Dragon Flight control systems - 5 redundant computers which all are running the same program, one of which is controlling (primary) and the other 4 are monitoring (secondary) nodes, the later of which are all sanity checking the performance operation of the controlling node. The moment they see the primary go out of expected functional operation - whether do to a complete system crash or a more subtle dropped CPU instruction due to a low voltage condition (which is common on RaspberryPi’s using either underpowered or failing USB Power supplies), one of the designated secondaries will jump in, demote the primary, and take control as the new primary.

And we can do this, we can replicate this kind of functionality, easily and natively inside Home Assistant, because HA gives us the possibility to monitor and control another HA node almost just as if it was a light bulb or smart switch itself, but one that offers a lot more data input to make smart decisions about that HA node’s health and operational state.

The only major difference between my primary and my 4 secondaries is that my secondary nodes have additional bits of conditional evaluation functions in their HA automations to not trigger unless the condition has been meet that a failure scenario has occurred.

BTW, this is another strength of Application Layer High Availability - you can get very granular in deciding what functionality should be mission critical and offered as High Availability, while excluding others that are not. For instance, I like having my dozen security cameras streamed to HA’s interface, and my wife likes the dozen or so Sunset & Beach cams streaming to the HA interface. I have this setup on my VM based instance of Home Assistant, which can easily handle this. But do not have these cameras streaming setup on my RaspberryPi nodes, because they would overload the CPU of RPI’s and they are not mission critical. With VM based High Availability, it’s pretty much all or nothing.

However, there is a role for VM High Availability to play here: Your MQTT server, and this is a perfect scenario for that, because we are not really concerned with MQTT storing data, but we are concerned with MQTT always being available somewhere on the network.

If you want to go down this path, and you haven’t done so yet, I’d go ahead and split your DB servers onto their own VMs on their respective VM hosts, and do the same for the MQTT server. Setup duplicate MQTT servers on both VM hosts under their own VMs that are exactly identical down to the same IP address. The only difference between them is that one should be designated a primary MQTT server that is set to always boot up and run, and the secondary MQTT server will never run, unless the primary MQTT server has crashed / been offline. Unfortunately, I don’t run Proxmox or Unraid, so I’m not exactly sure of how to technically implement that on those platforms, so you might have to research to find out if this is even possible to use the native feature sets of these VM hosts to do that. If it’s not, let me know, and I think I have a work around for that - which is a way I had solved this issue when I first began my use of HA and everything was on only a pure RaspberryPi environment (and before my incorporation of VMs for my primary, primary DB server and MQTT server).

In the meantime, if you want to give me a copy and paste example of an automation you’d like to configure as a High Availability function, I can help show you through that how to set this up in your automations & sensors.

BTW, I’m in the middle of painting my house at the moment, and am limited to periods of rain for time to post here. :slight_smile: If I don’t reply very quickly, that means it’s sunny / not raining here and I’m out painting - I will eventually return, provided I don’t fall off the scaffold and injure or kill myself. :slight_smile:

2 Likes

We would be over the moon if you use our platform to enlighten other hobbyists about how much more is actually possible with aquarium automation. The prices the category captain charges are astronomical and I wish more aquarists knew there were alternatives.

1 Like

@Faze_One Just an update to the last time we talked; revarnishing the exterior of the front side of my house has taken longer than expected due to weather / forgetting how long it takes to sand hard wood (compared to say, pine), and other surprise repairs that had to be made. As soon as I’m wrapped up with that, and enjoy a little bit of remaining holiday time with my wife, I’ll get on that.

Hi Ciwyn, any luck yet with the RA?

No I haven’t really messed around with getting that to integrate.
Now what I was told on the reef angel forums a while ago was that the RA star controller has an MQTT function built into it. So that can be integrated to HA via MQTT.

Unfortunately I think the reef angel controller is really losing ground to the mainstream controllers. So I’m not too keen on buying an RA star.

What I would like to do is set up something similar to what cowboy has done. I just feel like I lack the time right now and I also have to figure out a solution for pH monitoring for my calcium reactor.

I am interrested in knowing how you used a timer on the fluval 3.0.
What in term of hardware and software was used.

thank you

Hi!
This project looks awesome!
I’m completely new to HA, but not new to aquariums.
Where do I start?

I had planned on starting with ardunio / out of the box ATO switches/sensors from Aliexpress, but this thread, and @cowboy system looks incredible. I’m just not sure where/how to start in leveraging the work that has been done.

For example, I have two main tanks a 600L (angles and community) and a 300L (discus). I also have a 120L for a discus pair and a 100L for some angels who are breeding. I have two other tanks but are less concerning. The two breeding tanks are co-located, while the 600/300 are on opposite sides of my main living room.

Not sure where to start with (1) software and (2) hardware. Noting my use cases would be power monitoring and control (for air pumps/water pumps, heater control/fail safe), temp monitoring, pH, NH3 (less priority), water sensors, pump controls (drain x % and refill).

Kind regards,
Jezza

1 Like

Hi everyone,

Very cool thread, I have a long term plan to replace my APEX with HA. In the meantime, I have brought my apex data into HA and started doing some basic monitoring of a small tank in my office.

I wanted to know if anyone is using Bayesian to create new monitoring sensors. Idea - Low sump level

Context:
For example, my large planted aquarium has a automatic continuous water changer that uses an overflow drain in the sump to ensure the sump cannot overflow.

That said, when I have a power outage, some water drains out of the sump. In addition, the continuous water changing system runs for a couple minutes each night to refill evaporation and on saturdays does a 50% water change. This week I had an issue with my RO unit and forgot to reopen a bypass valve after fixing a leaking RO line. Several days later, I noticed that the water level was low in my sump.

A Bayesian sensor could look at the values of PH and ORP and given a sudden and large variation identify that the sump level is below the probes.

I just posted in another thread my issues with the Bayesian YAML code, but thought it might be interesting for this thread too. Would also love to know if anyone is using ML or advanced analytics on the aquarium. It seems like we deal with many stochastic situations that would be well served by applying a statistical control framework.

Thanks

1 Like

Update:
Just code the YAML to work, I still need to run tests to set the definitive parameters, but I was able to do a quick simulation and the binary sensor turned on.

Here is an example of the YAML that you can tweak for whatever use case you have. I highly recommend reading up on Bayesian algorithm and read the implementation parameters before copying this code.

binary_sensor:
  - platform: "bayesian"
    name: "Sump Low"
    prior: 0.01
    probability_threshold: 0.7
    observations:
      - platform: numeric_state
        entity_id: sensor.apex_ph
        prob_given_true: 0.5
        prob_given_false: 0.01
        above: 7.3
      - platform: numeric_state
        entity_id: sensor.apex_orp
        prob_given_true: 0.5
        prob_given_false: 0.01
        below: 440

The result of this is an entity that gives a true-false value for the sump level being low. As I mentioned, the parameters of PH and ORP as well as the probabilities would need to be tuned to your normal aquarium operating parameters. This obviously is not foolproof as other factors could change the parameters, but given that its only used for alerting, there is no danger in alerting me to visually inspect the status of my sump.

1 Like