Author Topic: Meteobridge upload to more than one MySQL server  (Read 233 times)

0 Members and 1 Guest are viewing this topic.

Offline lobsterman

  • Contributor
  • ***
  • Posts: 124
    • Cape Small Harbor Weather
Meteobridge upload to more than one MySQL server
« on: April 25, 2019, 09:50:09 PM »
My guess is that the answer to my question is NO, can't be done.

So, is it possible to configure MB to upload to more than one MySQL server?

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7319
    • Eagle Bay Weather
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline lobsterman

  • Contributor
  • ***
  • Posts: 124
    • Cape Small Harbor Weather
Re: Meteobridge upload to more than one MySQL server
« Reply #2 on: April 26, 2019, 10:48:21 AM »
https://dev.mysql.com/doc/refman/8.0/en/replication.html
True, replication is likely the answer but I haven't found a tutorial that's at my very low pay grade!

Offline galfert

  • Forecaster
  • *****
  • Posts: 2895
Re: Meteobridge upload to more than one MySQL server
« Reply #3 on: April 26, 2019, 11:45:46 AM »
Another solution is to run the Meteobridge and also run Weather-Display at the same time. Weather-Display can use the Meteobridge as a data source. Then you can configure both the Meteobridge and Weather-Display to both send to two different SQL databases.
WS-2000 & WS-2902A | Ecowitt GW1000 | WeatherBridge (Meteobridge)
WU: KFLWINTE111  |  PWSweather: KFLWINTE111
CWOP: FW3708  |  AWEKAS: 14814
Windy: pws-f075acbe
Weather Underground Issue Tracking
Tele-Pole

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7319
    • Eagle Bay Weather
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline droiddk

  • Senior Contributor
  • ****
  • Posts: 295
Re: Meteobridge upload to more than one MySQL server
« Reply #5 on: April 26, 2019, 12:00:44 PM »
My guess is that the answer to my question is NO, can't be done.

So, is it possible to configure MB to upload to more than one MySQL server?

A PHP-script can insert into MySQL so use a HTTP Request. Place the PHP-script on your server and make sure a password is included in the query-string. No/missing password = no insert.

Regards
Davis Vantage Pro2 Plus
WeatherFlow Sky & Air
Ventus W830