https://stackoverflow.com/questions/16032825/method-to-replicate-sqlite-database-across-multiple-servers
On Wed, Sep 14, 2022 at 4:47 PM Seth Ratner <[email protected]> wrote: > My Weewx is somewhere with a pretty terrible internet connection. > Disconnects a lot. So I need a database on the WeeWx host, or I'd lose a > ton of intervals. 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. > > I use mariabackup, however that doesn't clone the database so much as > package it. It needs to be extracted to be used, and that would be > impractical to do every 5-10 minutes. There might be a way to mirror a > database (without querying the entire db each time), but I don't know it. > I'm open to ideas, and I really appreciate everyone taking the time to > respond. > > Thanks > > On Wed, Sep 14, 2022 at 6:01 PM vince <[email protected]> wrote: > >> On Wednesday, September 14, 2022 at 3:50:16 PM UTC-7 Seth Ratner wrote: >> >>> That's an option, though I would want the databases to be mirrored +/- >>> one or two archive intervals, and that might get messy with mariabackup. I >>> have some services that will run at another location (Home Server) using >>> the archive data, but due to a bad internet connection I can't rely on >>> accessing the database on the Weewx computer (Farm) directly. >>> >>> >> Not understanding the 'why' at all on this one...but perhaps MQTT might >> be one possibility. Publish from the weewx site and subscribe on the other >> site. >> >> >>> Separately, could you point me to any documentation on the AQI and >>> forecast databases in WeeWX? I'd like to go down that rabbithole a bit. >>> >>> >> There are no such things in core weewx. You have to pick your >> extension(s) of choice and check out the code, or alternately spin up a >> simulator VM and add them to a throwaway instance of weewx perhaps... >> >> >> -- >> 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 >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/92149663-4379-405c-b29f-f62efca19362n%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/92149663-4379-405c-b29f-f62efca19362n%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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/CAHTssjNabT8X%2B304Nv9Dv1mGTbaArgnXRsiz%2B66CdjEZ%3DHMw5A%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAHTssjNabT8X%2B304Nv9Dv1mGTbaArgnXRsiz%2B66CdjEZ%3DHMw5A%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- Peter Quinn (415)794-2264 -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAA1SM228n_8F2Vw3XWdVJmh-j0hO%2BqGe1VXLi%3DBDjXRkkhGqKg%40mail.gmail.com.
