WXforum.net

Weather Software => Meteohub/Meteobridge => Topic started by: lobsterman on April 25, 2019, 09:50:09 PM

Title: Meteobridge upload to more than one MySQL server
Post by: lobsterman 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?

Title: Re: Meteobridge upload to more than one MySQL server
Post by: Bushman on April 25, 2019, 10:37:15 PM

https://dev.mysql.com/doc/refman/8.0/en/replication.html

Title: Re: Meteobridge upload to more than one MySQL server
Post by: lobsterman on April 26, 2019, 10:48:21 AM

Quote from: Bushman on April 25, 2019, 10:37:15 PM

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!

Title: Re: Meteobridge upload to more than one MySQL server
Post by: galfert 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.

Title: Re: Meteobridge upload to more than one MySQL server
Post by: Bushman on April 26, 2019, 11:57:50 AM

Quote from: lobsterman on April 26, 2019, 10:48:21 AM

Quote from: Bushman on April 25, 2019, 10:37:15 PM

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!

This is about as simple as it is gonna get:  http://www.clusterdb.com/mysql-cluster/get-mysql-replication-up-and-running-in-5-minutes

Title: Re: Meteobridge upload to more than one MySQL server
Post by: droiddk on April 26, 2019, 12:00:44 PM

Quote from: lobsterman 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?

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