msp.yaml

# server listen addr
addr : 0.0.0.0:9696

# server user and password
user :  root
password : Initial0

# if set log_path, the sql log will write into log_path/sql.log,the system log
# will write into log_path/sys.log
#log_path : ./log
# log level[debug|info|warn|error],default error
log_level : info

# if set log_sql(1|0) off(0),the sql log will not output
log_sql: 0

# only log the query that take more than slow_log_time ms
slow_log_time : 1000

# node is an agenda for real remote mysql server.
nodes :
-
    name : node1
    # 0:master-slave, slave use RoundRobin loadbalance; 1:cluster no master DB, master slave treate
    # as peer node, and master DB can be null.
    work_mode : 0

    # default max conns for mysql server
    max_conns_limit : 256

    # master user and password
    user :  root
    password : Initial0

    # master represents a real mysql master servermycnpvgvb1ep016.sapanywhere.sap.corp
    master : cnpvgvb1ep016.pvgl.sap.corp:3306

    # slave represents a real mysql salve server,and the number after '@' is
    # read load weight of this slave.
    slave : cnpvgvb1ep015.pvgl.sap.corp:3306@11, cnpvgvb1ep015.pvgl.sap.corp:3306@3
    # down_after_noalive : 32