<meta content="text/html; charset=windows-1252"
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 14/06/16 06:26, Rob Landry wrote:<br>
type="cite">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
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
I have had to make one amendment in 5+ years. Thats acceptable.<br>
Ads and Promos get updated at the same time. All clients copy all
audio; this provides backup I have had occasion to use.<br>
Clients load News Weather etc at :55 so the local system has
accurate material and durations.<br>
Music for the following 7 days is updated early evening. No updates
happen midnight -5am which is when logs are generated.<br>
I have considered the multiple source option; at the moment all
input [other then weather traffic news] goes to the master server.<br>
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
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
I thought about having a round robin update, which, while possible,
is a bit cumbersome and just adds to the error potential.<br>
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.<br>
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. <br>
<div class="moz-signature">-- <b>Big Valley Radio</b>
64 Warner Park Avenue <br>
06 650 6087<br>