Sending the archive database to 2 servers

[Phil D]

Hello everyone, 

I would like my data to be sent to a Mysql Archive database both on my local server (rasp) and on a remote server

I plan in weewx.conf to transform

[[MySQL]] driver = weedb.mysql host = localhost user = weewx password = weewx

by

[[MySQL]] driver = weedb.mysql host = localhost user = weewx password = weewx 

[[MySQL2] driver = weedb.mysql host = remote host address user = weewx 

password = weewx 

Has anyone tried this yet, does this work?

Thanks 

Phil 

[jszit...@gmail.com]

Phil,

I tried this along time ago with previous versions and did not have success.  Are you just wishing to do this as a backup?  If so, you can write a script to use mysqldump and upload that backup to another server.

-Jonathan

[Michael]

Hi Phil,

you don't write anything about your exact application...

Maybe the "MySQL Replication" is something for you: https://www.digitalocean.com/community/tutorials/how-to-set-up-replication-in-mysql

Michael