Mycat2 服務(wù)器 server

服務(wù)器配置

Mycat沒有固定的配置格式,暫時(shí)支持json,yaml格式

{
 "datasourceProvider":";io.mycat.datasource.jdbc.datasourceprovider.DruidDatasourceProvider",
 "loadBalance":{
    "defaultLoadBalance":"BalanceRandom",
    "loadBalances":[]
  },
  "mode":"local",
  "serverVersion" : "5.7.33-mycat-2.0" //1.17提供,用于客戶端適配,調(diào)整到與原型庫(kù)的mysql版本一致
  "properties":{},
  "server":{
    "bufferPool":{
    },
    "idleTimer":{
      "initialDelay":3,
      "period":15,
      "timeUnit":"SECONDS";
    },
    "ip":"127.0.0.1",
    "mycatId":1,
    "port":8066,
    "reactorNumber":8,
    "tempDirectory":null,
    "timeWorkerPool":{
      "corePoolSize":0,
      "keepAliveTime":1,
      "maxPendingLimit":65535,
      "maxPoolSize":2,
      "taskTimeout":1,
      "timeUnit":"MINUTES"
    },
    "workerPool":{
      "corePoolSize":8,
      "keepAliveTime":1,
      "maxPendingLimit":65535,
      "maxPoolSize":1024,
      "taskTimeout":1,
      "timeUnit":"MINUTES"
    },
    "mergeUnionSize": 5,
    "ignoreCast": false ,//生成的sql是否忽略類型轉(zhuǎn)換,1.17支持,
    "joinClustering": true ,//開啟后進(jìn)行join重排序,關(guān)閉后會(huì)加快優(yōu)化速度,1.18支持
  }
}

默認(rèn)配置

如果不配置則使用上述的值進(jìn)行加載

mergeUnionSize為使用一次union all合拼同一個(gè)存儲(chǔ)節(jié)點(diǎn)上多個(gè)dataNode的sql數(shù)量

該參數(shù)在1.15版本以后才存在

mycatId是保證多個(gè)mycat公用存儲(chǔ)節(jié)點(diǎn)的時(shí)候必須配置這個(gè)值,并且唯一,他用于生成序列號(hào),Xid等.

serverVersion用于客戶端與服務(wù)端適配

比如SELECT @@session.transaction_isolation