[RDD] Synchronizing carts and logs

Robert Jeffares jeffares.robert at gmail.com
Mon Jun 13 20:54:20 EDT 2016



On 14/06/16 06:26, Rob Landry wrote:
> Doing a database backup/restore once a day and rsync'ing /var/snd, as 
> some have suggested, is impractical. 

With a little bit of organization you can extract from mysql everything 
you need to update "on the network" and still leave "local" carts like 
Weather Traffic Community Announcements etc untouched.

I operate three sites which get updated at :45 each hour using a shell 
script which extracts data from mysql which is rsync-ed to each client 
and imported into the local mysql. It's split and staggered.
I have had to make one amendment in 5+ years. Thats acceptable.
Ads and Promos get updated at the same time. All clients copy all audio; 
this provides backup I have had occasion to use.
Clients load News Weather etc at :55 so the local system has accurate 
material and durations.

Music for the following 7 days is updated early evening. No updates 
happen midnight -5am which is when logs are generated.

I have considered the multiple source option; at the moment all input 
[other then weather traffic news] goes to the master server.

If someone remotely produces audio they put it in the local dropbox and 
it gets rsync-ed back to base, imported, and distributed in the next update.

We have a series of long format programmes which are supplied as mp3's 
so they are distributed to each station and carted locally. Since the 
master sets the durations etc the database is accurate. Carting is 
logged and a copy of the log emailed to be checked for errors.

I thought about having a round robin update, which, while possible, is a 
bit cumbersome and just adds to the error potential.

I am in process of testing a VPN setup for voice tracking [I now have 2 
independent Broadbands here]  and have been investigating the mirroring 
of /var/snd and what is involved in keeping everything in sync.  I might 
say if the voice tracking works thats all I need. I think RD will grab 
enough audio for that to work over ADSL maybe not all that fast but fast 
enough.

Rivendell has been designed around one audio library serving multiple 
clients at a single site. Cloning a system is easy enough. Genetic 
Modification is a little trickier.

regards

Robert Jeffares

-- *Big Valley Radio*
64 Warner Park Avenue

Laingholm

Auckland 0604

09 8176358

0221693124

06 650 6087
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20160614/ccdd5798/attachment-0001.html>


More information about the Rivendell-dev mailing list