Example 2

Product Information > JADE Synchronized Database Service (SDS) Administration Guide > Chapter 1 - Administering a JADE Synchronized Database Service (SDS) Environment > Example 2

Example 2

This example of a fragment of a JADE initialization file uses section qualifier names (described in "Two-Level Section Names" under "Format of the JADE Initialization File", in the JADE Initialization File Reference) so that the JADE initialization file is shared, allowing the parameters for a primary database and two secondary database systems to be specified in a single initialization file. The name command line parameter is used to select the sections relevant to each site.

## Common Synchronized Database Service Parameters ##
[SyncDbService]
ConnectionPollInterval=30
ReconnectInterval=300
TrackingDisabled=false
ReadAccessDisabled=false
MaxSecondaries=32
AuditCauseEvents=true

[SiteA.SyncDbService]
DatabaseRole=PrimaryRole
MyName=SiteA_Payroll

[SiteB.SyncDbService]
# remote database role server
DatabaseRole=SecondaryRole
MaxDeferredTransactions=1000
MyName=SiteB_Payroll
PrimaryServerName=SiteA_Payroll
ReconnectInterval=60

[SiteC.SyncDbService]
# local backup server
DatabaseRole=SecondaryRole
MyName=SiteC_Payroll
PrimaryServerName=SiteA_Payroll
MaxDeferredTransactions=100
ConnectionPollInterval=5

[ConnectionParams.SiteA_Payroll]
# SiteA_Payroll’s connection parameters used
# when it’s the primary database
NetworkSpecification1=TcpIp,Enabled,61001
# connection parameters used by secondary servers
# to connect to SiteA_Payroll when it's the primary
ServerNodeSpecifications=TcpIp,orca.sitea.ja.net,61001
# enable if you want to specify a restricted host list
RestrictedHostAccess=true
AllowedHost1=porpoise.siteb.ja.net
AllowedHost2=beluga.siteb.ja.net
AllowedHost3=dolphin.sitec.ja.net

[ConnectionParams.SiteB_Payroll]
# SiteB_Payroll’s connection parameters used
# when it’s the primary database
NetworkSpecification1=TcpIp,Enabled,62001
# connection parameters used by secondary servers
# to connect to SiteB_Payroll when it's the primary
ServerNodeSpecifications=TcpIp,porpoise.siteb.ja.net,62001
# enable if you want to specify a restricted host list
RestrictedHostAccess=true
AllowedHost1=hector.sitea.ja.net
AllowedHost2=orca.sitea.ja.net
AllowedHost3=dolphin.sitec.ja.net

[ConnectionParams.SiteC_Payroll]
# SiteC_Payroll’s connection parameters used
# when it’s the primary database
NetworkSpecification1=TcpIp,Enabled,63001
# connection parameters used by secondary servers
# to connect to SiteB_Payroll when it's the primary
ServerNodeSpecifications=TcpIp,dolphin.sitec.ja.net,63001
RestrictedHostAccess=true
AllowedHost1=hector.sitea.ja.net
AllowedHost2=orca.sitea.ja.net
AllowedHost3=porpoise.siteb.ja.net
AllowedHost4=beluga.siteb.ja.net

## Client/Server network parameters ##
[SiteA.JadeClient]
ServerNodeSpecifications=TcpIp,orca,60001

[SiteA.JadeServer]
NodeName=SiteA DbServer
NetworkSpecification1=TcpIp,Enabled,60001

[SiteB.JadeClient]
ServerNodeSpecifications=TcpIp,porpoise,60002

[SiteB.JadeServer]
NodeName=SiteB DbServer
NetworkSpecification1=TcpIp,Enabled,60002

[SiteC.JadeClient]
ServerNodeSpecifications=TcpIp,dolphin,60003

[SiteC.JadeServer]
NodeName=SiteC DbServer
NetworkSpecification1=TcpIp,Enabled,60003