Thanks, Hugh. I figured out how I could make it work, anyway. Such "replication on a schedule" is not usually the way that database replication works, and I'm not sure I should try to make it work this way. I may work with OpenLink to decide on that if we decide to purchase a license for Virtuoso Cluster - this email was a product of research towards that decision.
-----Original Message----- From: Hugh Williams [mailto:hwilli...@openlinksw.com] Sent: Friday, June 10, 2016 5:36 PM To: Davis, Daniel (NIH/NLM) [C] <daniel.da...@nih.gov> Cc: virtuoso-users <virtuoso-users@lists.sourceforge.net> Subject: Re: [Virtuoso-users] Replication on a schedule Hi Daniel, This is an open source mailing list for which cluster is not available as it is a commercial only feature, thus not likely to get much response on it … Note sure what you mean by "replicate on a schedule rather than as deltas are flushed” ? You seem to be seeking to use Virtuoso scale out Elastic Cluster [1][2] which is for horizontal scaling across multiple machine to pool resources (storage, memory, cores) for hosting large datasets that could not otherwise be hosting on a single machine. Virtuoso also has normal Database replication although this is a commercial feature only also and is also used for providing Virtuoso RDF Graph Replication clustering[3] of of single or scale out cluster farms. Based on the email you sent to support is would appear the Virtuoso RDF Graph Replication Clustering is most suitable for you use case. See also the different cluster configuration architectures at [4] … [1] http://docs.openlinksw.com/virtuoso/clusteroperation.html [2] http://docs.openlinksw.com/virtuoso/clusterstcnf.html [3] http://docs.openlinksw.com/virtuoso/rdfgraphreplication.html [4] http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtClusteringDiagrams Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 10 Jun 2016, at 17:17, Davis, Daniel (NIH/NLM) [C] <daniel.da...@nih.gov> > wrote: > > 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
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ 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