JSOC/proj/replication/etc/repserver.dev.cfg - view

Return to repserver.dev.cfg CVS log

Up to [Development] / JSOC / proj / replication / etc

File: [Development] / JSOC / proj / replication / etc / repserver.dev.cfg (download)
Revision: 1.5, Fri May 28 16:55:55 2010 UTC (12 years, 8 months ago) by arta
Branch: MAIN
CVS Tags: Ver_LATEST, Ver_9-5, Ver_9-41, Ver_9-4, Ver_9-3, Ver_9-2, Ver_9-1, Ver_9-0, Ver_8-8, Ver_8-7, Ver_8-6, Ver_8-5, Ver_8-4, Ver_8-3, Ver_8-2, Ver_8-12, Ver_8-11, Ver_8-10, Ver_8-1, Ver_8-0, Ver_7-1, Ver_7-0, Ver_6-4, Ver_6-3, Ver_6-2, Ver_6-1, Ver_6-0, Ver_5-14, Ver_5-13, Ver_5-12, Ver_5-11, Ver_5-10, HEAD
Changes since 1.4: +4 -0 lines

Add database failover code from db consultants

# This template file contains configurable parameters used by replication server code. The server
# code includes subscription_manager, publish_series.sh, unpublish_series, parse_slony_logs
# prep_slony_logs, archivelogs.pl, manage_logs.pl, subscription_cleanup, subscription_manager,
# and subscription_update.
#
# The each NetDRMS site using the replication code should copy this file to a writeable location
# and edit it as appropriate. Each of the server-side replication scripts sources this configuration 
# file to set environment variables needed by that script.

# ******* 
#   There are two server-side environments. This contains the configuration parameters for the
#   Stanford development environment. repserver.cfg contains the configuration parameters for
#   the Stanford release environment.
# *******

#######################################################
# server-side-wide configurable parameters
#######################################################

kServerCfg=/b/devtest/JSOC/proj/replication/etc/repserver.dev.cfg

hmidb0IP="192.168.0.49"
hmidb1IP="192.168.0.50"
hmidb2IP="192.168.0.76"

CLUSTERNAME=jsoc
MASTERDBNAME=jsoc
MASTERHOST=192.168.0.73
MASTERPORT=5432
SLAVEDBNAME=jsoc
SLAVEHOST=192.168.0.76
SLAVEPORT=5432
REPUSER=slony

kPsqlCmd=/usr/local/pgsql/bin/psql
kSlonCmd=/usr/local/pgsql/bin/slon

kServerLockDir=/usr/local/pgsql/replication/dev/locks
kModDir=/b/devtest/JSOC/bin/suse_x86_64
kModOnSlaveHost=hmidb2
kModOnSlaveUser=production

kRepDir=/b/devtest/JSOC/base/drms/replication

#######################################################
# publish_series.sh configurable parameters
#######################################################

REP_PS_TMPDIR=/tmp/
REP_PS_LOGDIR=/usr/local/pgsql/log

# Timeout on attempts to do the merge command. Each attempt is thirty seconds apart
REP_PS_MERGETO=120


#######################################################
# subscription_manager configurable parameters
#######################################################

triggerdir=/solarport/pgsql/slon_logs/dev/triggers/
subscribers_dir=/solarport/pgsql/slon_logs/dev/site_logs/
parser_config=/solarport/pgsql/slon_logs/dev/etc/slon_parser.cfg
tables_dir=/solarport/pgsql/slon_logs/dev/etc/
sl_dump_timeout=240
SMworkDir=/solarport/pgsql/slon_logs/dev/triggers/
kSMlogDir=/solarport/pgsql/slon_logs/dev/log/
cleanup_max_tries=120

#######################################################
# parse_slony_logs configurable parameters
#######################################################

kPSLlogsSourceDir=/usr/local/pgsql/slon_logs
kPSLarchiveDir=/usr/local/pgsql/slon_logs/archive
kPSLprepCfg=/solarport/pgsql/slon_logs/dev/etc/slon_parser.cfg
kPSLprepLog=/solarport/pgsql/slon_logs/dev/log/parse.log
kPSLlogReady=/solarport/pgsql/slon_logs/dev/etc/slonlogready.txt
kPSLparseCounter=/solarport/pgsql/slon_logs/dev/etc/parse_counter.txt
kPSLreproPath=/solarport/pgsql/slon_logs/dev/site_logs/repro
kPSLaccessRepro=/b/devtest/JSOC/bin/suse_x86_64/accessreplogs

#######################################################
# manage_slony configurable parameters
#######################################################

kMSMasterPIDFile=/usr/local/pgsql/log/slon.node1.pidfile
kMSSlavePIDFile=/usr/local/pgsql/log/slon.node2.pidfile
kMSLogDir=/usr/local/pgsql/log
kMSWorkDir=/usr/local/pgsql/log
kMSOnSync="/b/devtest/JSOC/base/drms/replication/manageslony/updatectr.pl /b/devtest/JSOC/proj/replication/etc/repserver.cfg"

# ART
# All the following have not been converted to development-environment parameters
#

#######################################################
# merge_rep_sets configurable parameters
#######################################################

MRSLogDir=/usr/local/pgsql/scripts/log/
MRSTempDir=/usr/local/pgsql/scripts/temp/
MRSPIDFile=/usr/local/pgsql/scripts/log/merge_rep_sets.pid
MRSDieFile=/usr/local/pgsql/scripts/log/merge_rep_sets.die
MRSPSQLBin=/usr/local/pgsql/bin/psql
MRSSlonikBin=/usr/local/pgsql/bin/slonik
MRSMaxTries=30
MRSSleepTimer=1


#######################################################
# slony_log_manager configurable parameters
#######################################################

SLMPSQLBin=/usr/local/pgsql/bin/psql
SLMHost=localhost
SLMPort=5432
SLMUser=slony
SLMDBName=postgres
SLMLogDir=/usr/local/pgsql/scripts/log/
SLMTempDir=/usr/local/pgsql/scripts/temp/
SLMSlonyLog=/usr/local/pgsql/log/slon.node2.log
SLMPIDFile=/usr/local/pgsql/scripts/log/slon_log_monitor.pid
SLMLastLineFile=/usr/local/pgsql/scripts/temp/last_line.txt


#######################################################
# slon_email_alert configurable parameters
#######################################################
SEALogDir=/usr/local/pgsql/scripts/log/
SEATempDir=/usr/local/pgsql/scripts/temp/
SEAEmailList=/b/devtest/JSOC/proj/replication/etc/slon_email_alert_emails.lst
SEASendmailBin=/usr/sbin/sendmail

Karen Tian