Difference between revisions of "Recital Replication Graphical Installation"

From Recital Documentation Wiki
Jump to: navigation, search
(Replication Database)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
{{YLM remove peer to peer}}
 
 
== Replication Type ==
 
== Replication Type ==
  
Line 83: Line 82:
 
== Replication Database ==
 
== Replication Database ==
 
During the installation process a database called ''replication'' will be created. A table called ''queue'' will also be created in the replication database. If this system is the master publisher a table called ''subscribers'' will be created.
 
During the installation process a database called ''replication'' will be created. A table called ''queue'' will also be created in the replication database. If this system is the master publisher a table called ''subscribers'' will be created.
 
{| class="bordered"
 
|+ Replication Tables
 
|-
 
! Table Name
 
! Replication Type
 
! Service
 
|-
 
| queue
 
| All
 
| All
 
 
|-
 
| subscribers
 
| Master Slave
 
| Publisher
 
 
|-
 
| peers
 
| Peer to Peer
 
| Master publisher
 
 
|-
 
| pub_queue
 
| Peer to Peer
 
| Master publisher
 
 
|-
 
| conflict_queue
 
| Peer to Peer
 
| Master publisher
 
 
|}
 
 
<br>
 
  
 
[[Category:RRS Installation]]
 
[[Category:RRS Installation]]

Latest revision as of 14:41, 8 June 2010

Replication Type

RRS Install Replication Type.gif


The first thing you must specify is what type of Replication Service you will be running on each server.

  • Slave - Select this type if this system will be a slave subscriber. There can be many slave subscribers but updates will only be performed from data published by the replication service.
  • Master - Select this type if this system will be the master publisher. There can be only one master publisher and only updates on this system will be published for replication.


Slave

RRS Install Replication Slave Options.jpg

Publisher

Specify the node name or IP Address of the Publisher that this slave will subscribe to. This should be the system that the Master replication service was installed on.

Delay

Specify the delay time in seconds that the service will pause between checking with the publication service.


Master

RRS Install Replication Master Publication ID.jpg

Publication ID

The publication ID is a unique number that is used to differentiate each system in the replication service. For a master publisher it should be set to a value of 1. This ID should not be changed once the replication service has been started on the system.


Modifying installed values

You can modify the values configured during installation by the following ways;


dbinstall rrs

Executing this command at the operating system prompt will allow you to reconfigure the replication service.

Configuration files

You can edit the configuration files and change the values manually. The following table contains all the variables defined during the installation process. The configuration file are stored in the conf directory which is in the root recital installation directory.


Configuration variables
Variable Name Default Value Configuration File
DB_PUBLICATIONID 0 recital.conf
DB_REPDIR replication recital.conf
DB_REPLOG TRUE recital.conf
DB_REPTYPE slave recital.conf
DB_PUBLISHER localhost recital.conf
DB_REPDELAY 60 recital.conf


DB_REPLOG

The variable DB_REPLOG is used to enable or disable logging on the replication services. A value of TRUE will enable logging and a value of FALSE will disable logging. By default log files will be stored in the log and/or debug directory located under to root recital installation directory.

Replication Database

During the installation process a database called replication will be created. A table called queue will also be created in the replication database. If this system is the master publisher a table called subscribers will be created.