. "VirtTipsAndTricksCheckpointClusterEdition" . "2017-06-13T05:47:19Z" . "2017-06-13T05:47:19.375027"^^ . . . "2017-06-13T05:47:19.375027"^^ . . . . . "%META:TOPICPARENT{name=\"VirtTipsAndTricksGuide\"}%\n\n---+Managing Checkpoints in a Clustered Virtuoso Server\n\n---++What? \n\nManagment of checkpoints across nodes in a Virtuoso clustered server environment.\n\n---++Why? \n\nThe default checkpoint mode of a Virtuoso cluster server instance might not align with the expectations of specific usage scenarios. \n\n---++How? \n\nThe checkpoint on cluster by default is the usual checkpoint setting in the virtuoso INI file, therefore each cluster node can do automatic checkpoints for itself.\n\nBy default checkpointing of a Virtuoso clustered server is performed manually by each node of the cluster, as specified in the Virtuoso configuration file of each node, and thus may not always be in sync.\n\nThe master node of the cluster can be configured to configured with a scheduled event to run the cl_exec('checkpoint') function to force all nodes of the cluster to perform a checkpoint simultaneously, there by ensuring the data across all nodes is kept in sync.\nIf this behaviour is not desirable, then the operator can disable auto checkpoint, and make a scheduled task on one of the cluster nodes to execute:\n\n\nSQL> cl_exec('checkpoint');\n\nDone. -- 13901 msec.\nSQL>\n\n\nThe automatic checkpoints on each individual nodes of the cluster set in there Virtuoso configuration files can then be disabled as they are no longer required. \n\nNote, it is recommended a checkpoint be run after the loading of RDF or other datasets into a Virtuoso cluster, or after any large job has been run against a Virtuoso cluster, to ensure all transactions are fully committed, and prevent any data loss when the cluster is restarted.\n\n---++Related\n\n * Cluster [[http://docs.openlinksw.com/virtuoso/clusteroperation.html#clusteroperationadmclexec][cl_exec()]] function\n * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]\n * [[VirtBulkRDFLoader][Bulk Loading of RDF Source Files into one or more Graph IRIs Guide]]\n * [[http://docs.openlinksw.com/virtuoso/rdfandsparql.html][RDF Data Access and Data Management]]" . "VirtTipsAndTricksCheckpointClusterEdition" . . . . "VirtTipsAndTricksCheckpointClusterEdition" . . . . . "2017-06-13T05:47:19Z" . . . . "f21972ceda193e91c5f8b3d99b4ab2ea" .