Hi Tom, thank you for that detailed list of possibilities! I think #4 or #5 would be the best way as it uses a separate database. I’m not familiar with MQTT and will dive into it. I hope my main computer is able to run two instances of weewx even with an archive interval of one minute. Maintaining two weewx instances seems much easier to handle…even in the test phase!
Yes….I think there could be some interruption of the WLAN and I don’t want to loose data during this time. If a MQTT broker running on the BananaPi outside which stores data local and can be accessed even after an interruption it would be a really good (and my preferred ) solution. Great that MQTT drivers are already available for weewx. It’s really a nice project and I will keep you informed. Final assembling of the distribution box placed later on the pole (VP already installed in 2m height) is nearing completion. Today I add a MightyOhm geiger counter and I think I have to modify the database of weewx to add CPS,CPM and uSv/hr to the database. Another challenge…. but already documented as I read in the docs. @Vince: Your solution sounds good too (nice idea to use a ramdisk for that file!). I first thought of writing the data into a file and access it maybe via NFS or SMB. So you offer it by Ngnix. Another good solution. If the network connection I have would be wired Ethernet I would go your way….but I really think buffering the data outside at the BananaPi in my case would be more reliable; Good point: there really could be no data or bad data from that sensors outside. And cleaning the main database I really will avoid! Regards, Christian Am Freitag, 22. September 2017 14:23:14 UTC+2 schrieb Tom Keffer: > > Hello, Christian > > To enumerate, here are your choices: > > 1. Run weewx locally on your garden BananaPi. Replicate > <https://dev.mysql.com/doc/refman/5.7/en/replication.html> the resultant > database on your "house" mysql database. Use the replicated database to run > reports with both the VP2 and garden data. > > 2. Run weewx locally on your garden BananaPi. Interrogate its database > from the house instance of weewx. > > 3. Run weewx only in the house, with a second thread > <https://github.com/weewx/weewx/wiki/multi-threaded-service> that > interrogates your bespoke program on the Banana Pi (or even directly to the > arduino). Its data is then joined with the VP2 data into a single MySQL > database in the house. > > 4. Same as #3, except put the data in a separate database in the house. > > 5. Run *two* instances <https://github.com/weewx/weewx/wiki/weewx-multi> > of weewx in the house. The second instance would be dedicated to collecting > data from the garden. One of the two instances would then be responsible > for generating reports. > > Any of these can work, although I think you would find #2 to be > frustrating: database protocols do not like to be run over unreliable > networks. Most people in a similar situation have chosen solution #5. It's > the simplest to administer. > > If you choose #3, #4, or #5, I would recommend using an MQTT broker across > the WLAN. They are designed to work across unreliable networks, and can > even offer store messages when the WLAN is offline, replaying them later. > There are a couple of weewx MQTT drivers around. > > Sounds like an interesting project. Keep us informed! > > -tk > > > > On Fri, Sep 22, 2017 at 3:25 AM, 'Christian Peters' via weewx-user < > [email protected] <javascript:>> wrote: > >> >> Hi group members, >> >> I just assembled two additional temp sensors and a rain sensor. All this >> sensors are connected to an Arduino which sill emmit the data on the serial >> port. >> As the sensors and the Arduino is located in the garden I can’t connect >> it to my main computer in the house. >> >> There (in the haouse) is a weewx instance running with a VP2 connected >> already. >> >> The Arduino is connected to a BananaPi (even in a box in the garden) >> which is connected via WLAN to my house. >> >> I think I will collect the data from the Arduino by a program on the >> BananaPi (still to write) which will write the data to an InfluxDB to >> combine the data from the VP2 (which data is emitted by the weewx instance >> in the house and the weewx-influx plugin) in Grafana. >> >> But in the main house I even generate a standard skin with weewx (VP2 >> data) and it would be nice to include the new additional sensors in the >> html page. >> >> So the question is how to achieve this? >> >> Should I install a second weewx on the BananaPi in the garden? But howto >> get the data into weewx (fileparse or a simple serial driver?). I think a >> second database on the BananaPi would be better then reading the data per >> WLAN direct into the weewx mysql database in the house (main computer) >> because in case the WLAN was interrupted all data will be lost during this >> period of this sensors?! >> >> Is it possible to query the remote database of the weewx instance in the >> garden from the main weewx instance and combine the two remote temp sensors >> with the outdoor temp sensor data of the VP in one plot each run the html >> page is build? >> >> Thanks for suggestions! :-) >> >> Regards, >> >> Christian >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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]. For more options, visit https://groups.google.com/d/optout.
