unshared.yaml能分享一下么
找不到代码啊
翎栋
2020-07-06
2 回答
# server listen addraddr : 0.0.0.0:9696# the web api serverweb_addr : 0.0.0.0:9797#HTTP Basic Authweb_user : adminweb_password : admin# user list with user name and passworduser_list:-user : kingshardpassword : kingshard#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 : /Users/flike/log# log level[debug|info|warn|error],default errorlog_level : debug#if set log_sql(on|off) off,the sql log will not output#log_sql: off #only log the query that take more than slow_log_time ms#slow_log_time : 100# the path of blacklist sql file# all these sqls in the file will been forbidden by kingshard#blacklist_sql_file: /Users/flike/blacklist# only allow this ip list ip to connect kingshard#allow_ips: 127.0.0.1# the default charset of kingshard is utf8.#proxy_charset: utf8mb4# node is an agenda for real remote mysql server.nodes :- name : node1 # default max conns for mysql server max_conns_limit : 8 # all mysql in a node must have the same user and password user : kingshard password : kingshard # master represents a real mysql master server master : 127.0.0.1:3306 # slave represents a real mysql slave server,and the number after '@' is # read load weight of this slave. slave : down_after_noalive : 32- name : node2 # default max conns for mysql server max_conns_limit : 8 # all mysql in a node must have the same user and password user : kingshard password : kingshard # master represents a real mysql master server master : 192.168.59.103:3307 # slave represents a real mysql slave server slave : # down mysql after N seconds noalive # 0 will no down down_after_noalive: 32# schema list include all user's schema# schema defines which db can be used by client and this db's sql will be executed in which nodesschema_list :- user: kingshard nodes: [node1,node2] default: node1 shard: - db : kingshard table: test_shard_hash key: id nodes: [node1, node2] type: hash locations: [4,4] - db : kingshard table: test_shard_range key: id type: range nodes: [node1, node2] locations: [4,4] table_row_limit: 10000
# server listen addraddr : 0.0.0.0:9696# the web api serverweb_addr : 0.0.0.0:9797#HTTP Basic Authweb_user : adminweb_password : admin# user list with user name and passworduser_list:-user : kingshardpassword : kingshard#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 : /Users/flike/log# log level[debug|info|warn|error],default errorlog_level : debug#if set log_sql(on|off) off,the sql log will not output#log_sql: off #only log the query that take more than slow_log_time ms#slow_log_time : 100# the path of blacklist sql file# all these sqls in the file will been forbidden by kingshard#blacklist_sql_file: /Users/flike/blacklist# only allow this ip list ip to connect kingshard#allow_ips: 127.0.0.1# the default charset of kingshard is utf8.#proxy_charset: utf8mb4# node is an agenda for real remote mysql server.nodes :- name : node1 # default max conns for mysql server max_conns_limit : 8 # all mysql in a node must have the same user and password user : kingshard password : kingshard # master represents a real mysql master server master : 127.0.0.1:3306 # slave represents a real mysql slave server,and the number after '@' is # read load weight of this slave. slave : down_after_noalive : 32- name : node2 # default max conns for mysql server max_conns_limit : 8 # all mysql in a node must have the same user and password user : kingshard password : kingshard # master represents a real mysql master server master : 192.168.59.103:3307 # slave represents a real mysql slave server slave : # down mysql after N seconds noalive # 0 will no down down_after_noalive: 32# schema list include all user's schema# schema defines which db can be used by client and this db's sql will be executed in which nodesschema_list :- user: kingshard nodes: [node1,node2] default: node1 shard: - db : kingshard table: test_shard_hash key: id nodes: [node1, node2] type: hash locations: [4,4] - db : kingshard table: test_shard_range key: id type: range nodes: [node1, node2] locations: [4,4] table_row_limit: 10000
举报
0/150
提交
取消
