I am working in Drools-Guvnor-5.5.0.Final version and have configured repository.xml to save all assets + indexes in Oracle 11 database.

 

I am deploying Guvnor in a resilient environment which has two servers. Guvnor deployed in both the servers is pointing to the same database.

 

Step 1

For this I generated the repository.xml from the administration panel of Guvnor and replaced in both primary and secondary Guvnor instance. And when I started the server and imported assets into primary guvnor, I was able to see the following tables in database,

 

1.       FS_FSENTRY;

2.       FS_WS_DEFAULT_FSENTRY;

3.       PM_WS_DEFAULT_FSENTRY;

4.       PM_WS_DEFAULT_BINVAL;

5.       PM_WS_DEFAULT_BUNDLE;

6.       PM_WS_DEFAULT_REFS;

7.       PM_WS_DEFAULT_NAMES;

8.       REPOSITORY_FS_FSENTRY;

9.       VERSIONING_FS_FSENTRY;

10.    VERSIONING_PM_BINVAL;

11.    VERSIONING_PM_BUNDLE;

12.    VERSIONING_PM_NAMES;

13.    VERSIONING_PM_REFS;

 

I also configured workspace.xml files in

1.      jboss-eap-6.0/bin/repository/workspaces/default

2.      jboss-eap-6.0/bin/repository/workspaces/security

 

Step 2

Now started secondary guvnor, configured similar to primary Guvnor. But secondary server did not displayed the packages and assets from DB. Instead asked me to install sample packages.

 

Step 3

I configured DataStore in repository.xml. Restarted primary Guvnor server and found one more table is created in database with the assets init.

Table name : DS_DATASTORE

 

Step 4

Configured secondary Guvnor with DataStore and restarted it. Now I could see the packages of primary Guvnor, But the assets in packages were not available.

 

I am attaching the repository.xml file from both the servers.

 

Thanks and Best Regards,

 

Zahid Ahmed
Senior Software Engineer | Emirates Group IT
P.O. Box 686
| Dubai, United Arab Emirates
T +971 4 245 2551
| M +971   55 124 9171