I am using two Perl scripts, rdsyncaudio.pl and rdsynclogs.pl, to
propagate addidions/changes/deletions of audio files and logs from a
master Rivendell system to one or more subordinate systems.
In one case, the client has a system in Framingham, MA that serves two
stations and another system at a transmitter site on Cape Cod. Changes to
the Framingham system have to propagate to Cape Cod.
Another client had a system at his studio in Exeter,
RI; another at a transmitter site in Hope Valley, RI; and a third system
at another transmitter site on Block Island. He sold the Hope Valley
station, so now there are only two sites to keep in synch.
In both cases, one system serves as the master. Its changes are propagated
to the other sites. Any changes made at the other sites would be undone,
as the master site is assumed to have the most recent changes.
If we ever needed to synchronize changes made at a transmitter site back
to the studio, that would be a problem, as all the database records would
have to carry timestamps so the script could tell which was the newest.
Presently it can only see that site A differs from site B, and assume that
since site A is the master it needs to make site B conform to site A.
Rob
On Mon, 20 Jul 2015, Wayne Merricks wrote:
Hi all,
I don't have a good solution for keeping databases and audio sync'ed between
live Rivendell systems.
In an ideal world I'm trying to achieve this (but I accept I don't think its
possible):
* Unreliable link between offices (Questionable Internet and wiring on
different continents)
* Person locally adds song to Riv and it propagates to the remote somehow
and vice versa (two way replication).
The simplest way I guess would be nightly updates (rsync, mysqldump etc) but
then I would lose audio imported at the remote station and play counters
etc.
Just wondering if anyone has any bright ideas?
Cheers,
--
Wayne Merricks
The Voice Asia
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev