Mycat2 數(shù)據(jù)源 datasource

數(shù)據(jù)源配置

{
  "dbType": "mysql",
  "idleTimeout": 60000,
  "initSqls": [],
  "initSqlsGetConnection": true,
  "instanceType": "READ_WRITE",
  "maxCon": 1000,
  "maxConnectTimeout": 3000,
  "maxRetryCount": 5,
  "minCon": 1,
  "name": "prototype",
  "password": "123456",
  "type": "JDBC",
  "url": "jdbc:mysql://127.0.0.1:3306?useUnicode=true&serverTimezone=UTC",
  "user": "root",
  "weight": 0,
  "queryTimeout":30//mills
}

prototype.datasource.json

{數(shù)據(jù)源名字}.datasource.json 保存在datasources文件夾

• maxConnectTimeout:單位millis,配置中的定時(shí)器主要作用是定時(shí)檢查閑置連接
• initSqlsGetConnection,true|false,默認(rèn):false,對(duì)于jdbc每次獲取連接是否都執(zhí)行initSqls
• type:數(shù)據(jù)源類型
• NATIVE:只使用NATIVE協(xié)議(即Mycat自研的連接MySQL的協(xié)議)
• JDBC:默認(rèn),只使用JDBC驅(qū)動(dòng)連接
• NATIVE_JDBC:該數(shù)據(jù)源同一個(gè)配置同時(shí)可以使用NATIVE,JDBC
• queryTimeout:jdbc查詢超時(shí)時(shí)間 默認(rèn)30mills
• JDBC禁用SSL屬性有助提高性能
• instanceType:配置實(shí)例只讀還是讀寫，可選值：READ_WRITE,READ,WRITE
• weight:負(fù)載均衡特定用的權(quán)重