• Topic
  • Discussion
  • VOS.VirtGraphReplicationStar(1.2) -- Owiki? , 2018-04-13 12:06:44 Edit owiki 2018-04-13 12:06:44

    Replication Example: Star Topology


    The following How-To walks you through setting up Virtuoso RDF Graph Replication in a Star Topology.


    Database INI Parameters

    Suppose there are 3 Virtuoso instances respectively with the following ini parameters values:

    1. virtuoso1.ini:

      ... [Database] DatabaseFile = virtuoso1.db TransactionFile = virtuoso1.trx ErrorLogFile = virtuoso1.log ... [Parameters] ServerPort = 1111 SchedulerInterval = 1 ... [HTTPServer] ServerPort = 8891 ... [URIQA] DefaultHost = localhost:8891 ... [Replication] ServerName = db1 ...

    2. virtuoso2.ini:

      ... [Database] DatabaseFile = virtuoso2.db TransactionFile = virtuoso2.trx ErrorLogFile = virtuoso2.log ... [Parameters] ServerPort = 1112 SchedulerInterval = 1 ... [HTTPServer] ServerPort = 8892 ... [URIQA] DefaultHost = localhost:8892 ... [Replication] ServerName = db2 ...

    3. virtuoso3.ini:

      ... [Database] DatabaseFile = virtuoso3.db TransactionFile = virtuoso3.trx ErrorLogFile = virtuoso3.log ... [Parameters] ServerPort = 1113 SchedulerInterval = 1 ... [HTTPServer] ServerPort = 8893 ... [URIQA] DefaultHost = localhost:8893 ... [Replication] ServerName = db3 ...

    Database DSNs

    Use the ODBC Administrator on your Virtuoso host (e.g., on Windows, Start menu -> Control Panel -> Administrative Tools -> Data Sources (ODBC); on Mac OS X, /Applications/Utilities/OpenLink ODBC Administrator.app) to create a System DSN for each of db1, db2, db3, with names db1, db2 and db3, respectively.

    Install Conductor package

    On each of the 3 Virtuoso instances install the conductor_dav.vad package.

    Create a Publication on the Host Virtuoso Instance -- db1

    1. Go to Conductor -> Replication -> Transactional -> Publications:

    2. Click Enable RDF Publishing.
    3. A publication with the name RDF Publication should be created:

    4. Click the link which is the publication name.
    5. You will be shown the publication items page:

    6. Enter for Graph IRI


    7. Click Add New.
    8. The item will be created and shown in the list of items for the currently viewed publication.

    Insert Data into a Named Graph on the Host Virtuoso Instance

    There are several ways to insert data into a Virtuoso Named Graph. In this Guide, we will use the Virtuoso Conductor's Import RDF feature:

    1. In the Virtuoso Conductor, go to Linked Data -> Quad Store Upload:

    2. In the presented form:
      • Tick the box for Resource URL and enter your resource URL, for e.g.:


      • Enter for Named Graph IRI:


    3. Click Upload
    4. A successful upload will result in this message:

    5. Check the inserted triples by executing a query like the following against the SPARQL endpoint, http://cname:port/sparql --

      SELECT * FROM <http://example.org> WHERE { ?s ?p ?o }

    6. See how many triples have been inserted in your graph:

      SELECT COUNT(*) FROM <http://example.org> WHERE { ?s ?p ?o }

    Subscribe to the Publication on the a Destination Virtuoso Instance -- db2, db3, etc.

    1. Go to Conductor -> Replication -> Transactional -> Subscriptions:

    2. Click New Subscription:

    3. Specify a new Data Source Enter or selected target data source from the available connected Data Sources:

    4. Click Publications list:

    5. Select the RDF Publication and click List Items:

    6. Click Subscribe.
    7. The subscription will be created:

    8. Click Sync.
    9. Check the retrieved triples by executing the following query:

      SELECT * FROM <http://example.org> WHERE {?s ?p ?o}

    10. See how many triples have been inserted into your graph by executing the following query:

      SELECT COUNT(*) FROM <http://example.org> WHERE {?s ?p ?o}

    These steps may be repeated for any number of Subscribers.

    Insert Triples into the Host Virtuoso Instance Graph and check availability at Destination Virtuoso Instance Graph

    1. To check the starting count, on the Destination Virtuoso Instance SPARQL Endpoint, execute:

      SELECT COUNT(*) FROM <http://example.org> WHERE { ?s ?p ?o }

    2. On the Host Virtuoso Instance go to Conductor -> Database -> Interactive SQL and execute the following statement:

      SPARQL INSERT INTO GRAPH <http://example.org> { <http://www.openlinksw.com/dataspace/person/kidehen@openlinksw.com#this> <http://xmlns.com/foaf/0.1/interest> <http://dbpedia.org/resource/Web_Services> } ; SPARQL INSERT INTO GRAPH <http://example.org> { <http://www.openlinksw.com/dataspace/person/kidehen@openlinksw.com#this> <http://xmlns.com/foaf/0.1/interest> <http://dbpedia.org/resource/Web_Clients> } ; SPARQL INSERT INTO GRAPH <http://example.org> { <http://www.openlinksw.com/dataspace/person/kidehen@openlinksw.com#this> <http://xmlns.com/foaf/0.1/interest> <http://dbpedia.org/resource/SPARQL> } ;

    3. To confirm that the triple count has increased by the number of inserted triples, execute the following on the Destination Virtuoso Instance SPARQL Endpoint:

      SELECT COUNT(*) FROM <http://example.org> WHERE { ?s ?p ?o }