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

0 Members and 1 Guest are viewing this topic.

Offline lobsterman

  • Senior Contributor
  • ****
  • Posts: 164
    • 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: 7549
    • 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

  • Senior Contributor
  • ****
  • Posts: 164
    • 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

  • Global Moderator
  • Forecaster
  • *****
  • Posts: 6822
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.
Ecowitt GW1000 | Meteobridge on Raspberry Pi
WU: KFLWINTE111  |  PWSweather: KFLWINTE111
CWOP: FW3708  |  AWEKAS: 14814
Windy: pws-f075acbe
Weather Underground Issue Tracking
Tele-Pole

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • 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

  • Forecaster
  • *****
  • Posts: 334
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

 

anything