OpenVPN in bridge mode works well for one of my clients; however, ssh
tunnels are my preferred method for managing MySQL connections and other
unencrypted connections between Rivendell systems.
I have a Perl script to synchronize carts, cuts, and audio files between a
Rivendell system on Cape Cod and another in the Boston area, plus a second
script that synchronizes logs between the same two systems.
There's no ideal way to do this because Rivendell doesn't "know" about the
scripts, and if people change the same cart or cut in both locations at
the same time, the results will be unpredictable.
There is no way to synchonize deletions; a cart deleted at one location
cannot be distinguished from a new cart added at the other, so the only
way to get rid of a cart is to delete it in both places between script
runs. A *cut* deleted at one end can be synchronized, but not a cart.
The scripts run every 30 minutes and are staggered such that they don't
run simultaneously in both places. Each script looks at the database at
the far end and compares the last modified date of each record with the
same field in the corresponding record in the local database. If the local
record is fresher, the remote database is updated with the local
information and any corresponding audio file is rsync'ed.
Before there was Rivendell, I had the same problem with old Scott Studios
DOS systems. Synchronizing broadcast automation systems is a very ugly
proposition. I don't know what I'd do if I had to synchronize twenty of
the things.
Rob
--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.
On Mon, 1 Feb 2016, Robert Jeffares wrote:
I plan to set up external remote access in to my central server to enable
voice tracking.
It looks like I can mount the shared /var/snd on the server at the external
remote client and only the necessary parts of files will be accessed and
travel across the network, as will saved voice tracks.
Remote access to mySQL will enable the remote client to access logs.
To enable a secure consistent reliable connection I need to set up a VPN.
Obviously same versions of RD at each location.
There will be a completion time for each save determined by the speed of the
network.
Has anyone such a set-up in operation? What should I be looking out for?
regards
Robert
--
Robert Jeffares
Communication Consultants
The Wireless Station 1530kHz
Big Valley Radio
Radio Spice
Raupo Radio 1170kHz
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
