So, I'm not sure whether these are available in the Conductor interface, but
the cluster control utility (clctl) seems to support what I want to do if I
have scheduled jobs which turn on a cluster member for replication and then
stop the replication at some point:
At 2 am, clctl rebuild 2
...
At 4 am, check that node 2 is up-to-date, and then disable it -
clctl disable 2
This is probably an anti-pattern however. Running with row-level autocommit
has been good because I don't have clustering, and am manually replicating via
scripts. I should probably rewack my stored procedures and systems
architecture so that my update jobs run efficiently with transaction isolation.
From: Davis, Daniel (NIH/NLM) [C]
Sent: Friday, June 10, 2016 10:55 AM
To: virtuoso-users <virtuoso-users@lists.sourceforge.net>
Subject: [Virtuoso-users] Replication on a schedule
Hi, does anyone out there with the Cluster edition of Virtuoso replicate on a
schedule rather than as deltas are flushed? Is this desirable?
The issue is that in a star topology, replication represents an increased risk
of the replicant failing. It may therefore be better to replicate only during
certain time frames so that the cluster remains redundant. I know I could do
this scripts subscribing and subscribing to deltas, but it would be more
hands-off if Virtuoso has a simple concept of when to apply deltas.
Dan Davis, Systems/Applications Architect (Contractor),
Office of Computer and Communications Systems,
National Library of Medicine, NIH
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
