Configuration of Server parameter

Describes the configuration of server parameter of ProSync Manager.

1. Server parameter configuration

The parameters used by the ProSync Manager server can be set in the prosyncmanager.properties file.

Each parameter is separated by a newline, and only one equals sign (=) is entered between the parameter name and the value, with no spaces.

# LOG
LOG_LEVEL=INFO
LOG_DIR=${PRSMGR_HOME}/logs
LOG_COMPRESS=Y
LOG_MAX_FILE_SIZE=1GB
LOG_MAX_HISTORY=30
LOG_TOTAL_SIZE_CAP=30GB

# INTEGRITY CHECK
## parallel used in SELECT during check operation
IC_SELECT_THREAD_COUNT=8
## parallel used by DML during calibration operation
IC_APPLY_THREAD_COUNT=8
IC_QUEUE_SIZE=128
IC_DOWNLOAD_PATH=${PRSMGR_HOME}/verify
IC_CONNECTION_TIMEOUT=300
IC_READ_TIMEOUT=1800
## Thread pool size for verification tasks
## Occupy maximum number of equal SRC/TAR DB connections
IC_SERVICE_THREAD_CNT=10
## Thread pool size used for downloading the result after scan
IC_SERVICE_DOWNLOAD_THREAD_CNT=5
## Thread pool size used for calibration work
## Occupy TAR DB connection up to the value * 5
IC_SERVICE_APPLY_THREAD_CNT=5
## Sorting for non-UTF DBs
IC_USE_UNICODE_ORDER=false

# INITIAL LOAD
IL_EXTRACT_PARALLEL=N
IL_INSERT_PARALLEL=N
IL_LOCK_TIMEOUT=10
IL_LOG_PATH=${PRSMGR_HOME}/etl

# REPO DB
REPODB_USERNAME=repo_user
REPODB_PASSWORD=password
REPODB_IP=localhost
REPODB_PORT=13852
REPODB_DBNAME=prosyncmanager

# JWT 90days - 360days
JWT_VALID_TIME_MILLIS=7776000000
JWT_REFRESH_TIME_MILLIS=31104000000

# DB
DB_TIMEOUT_SECONDS=5

# TOMCAT LOG
TOMCAT_LOG_LEVEL=INFO
TOMCAT_LOG_DIR=${PRSMGR_HOME}/tomcat_logs
TOMCAT_LOG_COMPRESS=Y
TOMCAT_LOG_MAX_FILE_SIZE=1GB
TOMCAT_LOG_MAX_HISTORY=30
TOMCAT_LOG_TOTAL_SIZE_CAP=30GB

# HIST RETENTION
RETENTION_JOB_TIME=1
RETENTION_EVENT=30
RETENTION_ERROR=30
RETENTION_LONG_TX=30
RETENTION_RESOURCE=30
RETENTION_STATISTICS=30
RETENTION_TSN_DIFF=30

# TSN TIME MAP RETENTION
RETENTION_SRC_TIME_MAP=30

The following describes each parameter.

Parameters	Description	Default value
LOG_LEVEL	The level of logs to be left by ProSyncManager, which can be changed dynamically. (ERROR, WARN, INFO, DEBUG, TRACE)	INFO
LOG_DIR	The directory where ProSyncManager will leave logs.	${PRSMGR_HOME}/logs
LOG_COMPRESS	Determines whether to compress previous logs (Y, N)	Y
LOG_MAX_FILE_SIZE	The maximum size of individual log files. It is in bytes and can be set using GB/MB/KB.	1GB
LOG_MAX_HISTORY	The number of days between log files to keep, with older files deleted.	30
LOG_TOTAL_SIZE_CAP	The upper limit for the sum of the total size of all log files, with older files deleted. It is in bytes and can be set using GB/MB/KB.	30GB
IC_SELECT_THREAD_COUNT	The number of threads used for data comparison during the consistency check operation.	8
IC_APPLY_THREAD_COUNT	The number of threads used for data correction during the consistency check operation.	8
IC_QUEUE_SIZE	The parameter for memory management of the consistency check and means the maximum value of statements to be held in the stream that reads/writes the sql file. If the users allow a value that is too large, it will affect the performance (resources) of the ProSync Manager by increasing the number of statements accumulated in memory when SQL file creation is slow, so set the appropriate value according to the environment. (1 - 2147483647)	128
IC_DOWNLOAD_PATH	The parameter of the verification function, where the sql file of the verification result will be saved.	${PRSMGR_HOME]/verify
IC_CONNECTION_TIMEOUT	The connection timeout for trying to connect to JDBC.(0 - 2147483647 seconds) If set to 0 seconds, the connection wait is performed without timeout.	300
IC_READ_TIMEOUT	Query Timeout to wait for a response when a query is sent to the server. (-1 - 2147483647 seconds) If set to a positive integer, it will wait for timeout (seconds). If it is 0 or a negative value, it will wait indefinitely for the query response.	1800
IC_SERVICE_THREAD_CNT	The number of threads to perform consistency checks simultaneously. All values greater than 0 are allowed, but allowing too many threads affects the performance (speed and resources) of the ProSync Manager, so set the appropriate value according to the users environment.	10
IC_SERVICE_DOWNLOAD_THREAD_CNT	The thread pool size used for downloading SQL files after the consistency result.0All larger values are allowed, but allowing too many threads affects the performance (speed and resources) of the ProSync Manager, so set the appropriate value according to the environment.	5
IC_SERVICE_APPLY_THREAD_CNT	The thread pool size used for the matching correction operation.Maximum {setting value} * 5 occupies the TAR DB Connection. All values greater than 0 are allowed, but allowing too many threads may affect the performance (speed and resources) of the ProSync Manager, so set the appropriate value according to the users environment.	5
IC_USE_UNICODE_ORDER	If the charset is not UTF, the sort order of special characters such as Chinese characters may be different. If this option is true, it changes the sort order to unicode when sorting by columns that are interpreted as Strings, such as char/varchar, in non-UTF environments.(This has an effect if the KEY contains a char/varchar column or if the table contains such a column without a KEY)	false
IL_EXTRACT_PARALLEL	The Parameter of the initial load function, which determines whether to parallelize extraction.(Y|N)	N
IL_INSERT_PARALLEL	The parameter of the initial load function, which determines whether to parallelize insertion.(Y|N)	N
IL_LOCK_TIMEOUT	The parameter of the initialization function, the time to try to lock the table in srcDB during initialization.(1 - 2147483647 seconds)	10
IL_LOG_PATH	The parameter of the initialization function, the location to save the log file of the initialization.(1 - 2147483644 seconds)	${PRSMGR_HOME}/etl
PEPODB_USERNAME	The user name to connect to repoDB	repo_user
REPODB_PASSWORD	The password of PEPODB_USERNAME to connect to repoDB.	password
REPODB_IP	The iP to connect to repoDB.	localhost
REPODB_PORT	The port to connect to repoDB. (0 - 65535)	13852
REPODB_DBNAME	The DB name to connect to repoDB.	prosyncmanager
JWT_VALID_TIME_MILLIS	jwt Token-related parameter, the valid time of the token. (1 - 9223372036854775807 milliseconds)	7776000000
JWT_REFRESH_TIME_MILLIS	jwt Token-specific parameter, the validity time of the refresh token. (1 - 9223372036854775807 milliseconds)	31104000000
DB_TIMEOUT_SECONDS	Timeout setting for query response to the control DB.(0:Infinite wait, 0 - 2147483647 seconds)	5
TOMCAT_LOG_LEVEL	Level of tomcat logs to deploy ProSyncManager.(ERROR, WARN, INFO, DEBUG, TRACE)	INFO
TOMCAT_LOG_DIR	Directory where tomcat logs will be located.	${PRSMGR_HOME}/tomcat_logs
TOMCAT_LOG_COMPRESS	COMPRESSDetermines whether to compress old tomcat logs.(Y, N)	Y
TOMCAT_LOG_MAX_FILE_SIZE	Maximum size of individual tomcat log files in bytes and can be set using GB/MB/KB.	1GB
TOMCAT_LOG_MAX_HISTORY	The number of days between tomcat log files to be retained. Older files will be deleted.	30
TOMCAT_LOG_TOTAL_SIZE_CAP	The upper limit for the total size of all tomcat log files. Older files will be deleted.	30GB
RETENTION_JOB_TIME	Time to execute to remove the partition saving log data. (0 - 23)	1
RETENTION_EVENT	The event information to store for a period of time (-1: never, 0: only store information for the day, max 365)	30
RETENTION_ERROR	The error information to store for a period of time (-1: Never, 0: Save only today's information, max 365)	30
RETENTION_LONG_TX	The long tx Information to save (-1: Never, 0: Save only today's information, max 365)	30
RETENTION_RESOURCE	cpu/mem Usage information to save (-1: Disabled, 0: Saves only the current day's information, max 365)	30
RETENTION_STATISTICS	The number of synchronized dml/ddl information (-1: Disabled, 0: Saves only the current day's information, max 365)	30
RETENTION_TSN_DIFF	Time information to save the tsn Diff information. (-1: Disabled, 0: Saves only the current day's information, max 365)	30
RETENTION_SRC_TIME_MAP	Time information mapped to the tns. (-1: Disabled, 0: Saves only the current day's information, max 365)	30