Hi Yes I use SQL replication to a spare Raspberry pi, its is a live backup and I also use it as a second source of data in another weewx project I am building. I have used replication for years (on QNAP NAS and now Pi), and it is extremely reliable and recovers from power failures, device shutdowns etc without issue so far.
Neville On Thursday, September 15, 2022 at 11:42:23 PM UTC+10 Seth Ratner wrote: > Thanks Doug and Vince, > > It looks like the best solution is MySQL replication. I had been using the > backup option without realizing replication was built in. This will be more > than adequate, and will full account for the internet going in and out > between the locations. > > I also appreciate the tip on the extensions. I think the forecast one will > be useful in my integrations with Home Assistant. > > Cheers! > > On Thu, Sep 15, 2022 at 7:11 AM Doug Jenkins <do...@dougjenkins.com> > wrote: > >> Seth: >> >> I think you have a couple of options to choose from. One concern I would >> have with MQTT is that it always publishes the latest record, so if your >> farm location is down for 1 hour, your remote will not get the records up >> to the last archive. >> >> thinking about your use case now, It may make sense to setup the station >> on SQLite and rsync the database to your remote location after the archive >> period. that way if your farm location lost connection, you would know >> based on the last archive record at home and once you have a connection >> again, you would get all the data. >> >> here is a wiki article on the github weewx repo that kind of explains >> this : Using the RSYNC skin as a backup solution ยท weewx/weewx Wiki >> (github.com) >> <https://github.com/weewx/weewx/wiki/Using-the-RSYNC-skin-as-a-backup-solution> >> >> To answer your question about my other databases, for forecast and AQI, >> as Vince indicated earlier, there are a host of extensions available. The >> one I use for forecast is Weewx-Forecast by Matthew Wall ( >> matthewwall/weewx-forecast: >> forecasting extension for weewx (github.com) >> <https://github.com/matthewwall/weewx-forecast>) and I use a AQI >> extension to pull from my Davis Airlink AQI device ( >> chaunceygardiner/weewx-airlink: >> WeeWX extension to support Davis AirLink air quality sensor. (github.com) >> <https://github.com/chaunceygardiner/weewx-airlink>) >> >> hope this helps! >> >> Doug Jenkins >> >> On Wednesday, September 14, 2022 at 9:10:40 PM UTC-4 vince wrote: >> >>> On Wednesday, September 14, 2022 at 4:47:53 PM UTC-7 Seth Ratner wrote: >>> >>>> But I also run various programs at home that reference the archive, and >>>> they won't work when the WeeWx host has lost internet. >>>> >>> So I need two copies of the archive available at all times, one for each >>>> location. >>>> >>> >>> Still unclear why without knowing what you're running at the non-weewx >>> site. Can you run that on the weewx host and upload the results to home >>> occasionally ? Does the non-weewx site need to be totally up to date >>> always ? Is your internet 'slow' in terms of bandwidth or just unstable ? >>> >>> You're jumping to a solution but not really explaining the problem(s) >>> and why you have a split setup..... >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/PPGSbaoX_ns/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/9e98036d-592b-4ff4-8c7c-dc9ecbe3a7ffn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/9e98036d-592b-4ff4-8c7c-dc9ecbe3a7ffn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/f9a9dae1-e298-43ea-9762-273d4dc69844n%40googlegroups.com.
