#?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