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
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
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
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
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.
>
https://stackoverflow.com/questions/16032825/method-to-replicate-sqlite-database-across-multiple-servers
On Wed, Sep 14, 2022 at 4:47 PM Seth Ratner 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
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
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)
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
I am not understanding the use case. If you are running MySQL both locally
and remotely for the archive, why don't you just replicate the local MySQL
instance to the remote on a schedule?
I run multiple weewx databases (aqi, forecast, archive) on mariadb and just
back it up daily to my NAS. If I
Looks like I can just add another binding in [DataBingings], but in
[StdArchive] I'm not sure I can have two archive processes run.
I think these sections are all fine.
[DataBindings]
[[wx_binding]]
database = archive_mysql
table_name = archive
manager =
11 matches
Mail list logo
