Yeah I thought as much. I figure if I check in with the people who
know better once every year or so, some bright spark may have performed
miracles.
I wouldn't actually mind too much if MySQL generated a manual
reconciliation list but from memory it doesn't say much and the first
thing you notice is your syncing stops working. At which point there
are usually dozens of changes to try and figure out.
I may have to accept that cross continent changes will be overwritten
nightly, it is certainly the simpler option.
The only other thing I can think of is to set up a separate Riv group
with enforced cart numbers for imports at each location. I'd still lose
the synchronicity of play counters but I could probably script an rsync
and db update based on number ranges every once in a while. But then
you still get potential for offline updates of files/db that could
overlap and you're right back at square one.
Thanks for the suggestions both of you either way.
On 2015-07-20 18:25, Mike Carroll wrote:
Youll also have the issue of race conditions: if user Alice on Riv #1
updates a log while the network is down, and sometime later Bob on
Riv
#2 also updates the log, what are the final contents of the log when
the networks are reconnected? MySQL does replication, but it doesnt
do reconciliation.
++hobbitt
On Mon, Jul 20, 2015 at 7:11 AM, Stan Fotinos <[email protected]
[3]> wrote:
Hi Wayne
As far as syncing songs added maybe some sort of drop box setup on
both sides might do the trick. Play counters etc might be a bit
tricky to sync instantly over the net with unreliable links...
Thanks
Stan
On 20/07/2015 9:39 pm, Wayne Merricks wrote:
Hi all,
I dont have a good solution for keeping databases and audio
synced between live Rivendell systems.
In an ideal world Im trying to achieve this (but I accept I dont
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
_______________________________________________
Rivendell-dev mailing list
[email protected] [1]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[2]
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
