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=30The following describes each parameter.
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
Last updated