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 <lordrat...@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+unsubscr...@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/CACC0i0xp0UX-MKAoqwsqmrb1EBnTp%2BUx5gri3eXbSeL-8YLz8w%40mail.gmail.com.
