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]> 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]. > 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.
