Yup, replication is what I wanted. Thanks everyone for helping me get to the right answer eventually!
On Thursday, September 15, 2022 at 4:52:25 PM UTC-5 nevilled...@gmail.com wrote: > 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/ca79f6a6-eca9-443b-8c2e-539ebf8ecf90n%40googlegroups.com.