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.
I was thinking the local db would use SQLite which reduces the load on the Rasperry Pi Zero, and MySQL for the remote db. Perhaps there is a simple way to mirror the two separated databases? 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. Cheers, Seth On Wednesday, September 14, 2022 at 5:16:02 PM UTC-5 do...@dougjenkins.com wrote: > 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 needed a remote db, I would just > restore my backup on a separate instance. > > On Wed, Sep 14, 2022, 5:51 PM Seth Ratner <lordr...@gmail.com> wrote: > >> >> 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 = weewx.manager.DaySummaryManager >> schema = schemas.wview_extended.schema >> [[backup_binding]] >> database = archive_backup >> table_name = archive >> manager = weewx.manager.DaySummaryManager >> schema = schemas.wview_extended.schema >> >> ############################################################################## >> [Databases] >> >> [[archive_sqlite]] >> database_name = weewx.sdb >> database_type = SQLite >> >> # MySQL >> [[archive_mysql]] >> database_name = weewx >> database_type = MySQL >> >> [[archive_backup]] >> database_name = weewx >> database_type = MySQL2 >> >> ############################################################################## >> >> # This section defines defaults for the different types of databases. >> >> [DatabaseTypes] >> >> [[SQLite]] >> driver = weedb.sqlite >> # Directory in which the database files are located >> SQLITE_ROOT = /var/lib/weewx >> >> # Defaults for MySQL databases >> [[MySQL]] >> driver = weedb.mysql >> host = localhost >> user = weewx >> password = gt9drSvlB3ImZGS >> >> [[MySQL2]] >> driver = weedb.mysql >> host = 192.168.30.110 >> user = weewx >> password = test >> >> >> But the [StdArchive] section only accepts one binding as far as I can >> tell: >> >> >> [StdArchive] >> archive_interval = 300 >> record_generation = software >> loop_hilo = True >> data_binding = wx_binding *<-- This is where I think I would >> need to be able to list two bindings... right?* >> log_success = True >> log_failure = True >> On Wednesday, September 14, 2022 at 4:38:38 PM UTC-5 Seth Ratner wrote: >> >>> Simple concept, but I'd like to use one local and one network db. >>> Poosible? >>> >>> Seems easy enough to add the second database to the config, but I don't >>> know if [DataBindings] can accept the second database. >>> >>> Anyone tried this? >>> >>> Seth >>> >>> >>> -- >> 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+...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/34a25b20-3d32-485d-a1e8-e627dcb712a0n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/34a25b20-3d32-485d-a1e8-e627dcb712a0n%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/809553d1-97ce-4e0e-bbfd-bdb875a7bf5cn%40googlegroups.com.
