重置配置
/*+ mycat:resetConfig{} */;
用户相关
创建用户
/*+ mycat:createUser{
"username":"user",
"password":"",
"ip":"127.0.0.1",
"transactionType":"xa"}
*/;
删除用户
/*+ mycat:dropUser{ "username":"user"} */;
显示用户
/*+ mycat:showUsers */;
数据源相关
建数据源
/*+ mycat:createDataSource{
"dbType":"mysql",
"idleTimeout":60000,
"initSqls":[],
"initSqlsGetConnection":true,
"instanceType":"READ_WRITE",
"maxCon":1000,
"maxConnectTimeout":3000,
"maxRetryCount":5,
"minCon":1,
"name":"dc1",
"password":"123456",
"type":"JDBC",
"url":"jdbc:mysql://127.0.0.1:3306?useUnicode=true&serverTimezone=UTC&characterEncoding=UTF-8",
"user":"root",
"weight":0}
*/;
删除数据源
/*+ mycat:dropDataSource{
"dbType":"mysql",
"idleTimeout":60000,
"initSqls":[],
"initSqlsGetConnection":true,
"instanceType":"READ_WRITE",
"maxCon":1000,
"maxConnectTimeout":3000,
"maxRetryCount":5,
"minCon":1,
"name":"dc1",
"type":"JDBC",
"weight":0}
*/;
显示数据源
/*+ mycat:showDataSources{} */;
集群相关
创建集群
先创建两个数据源dc1和dc2,然后创建集群,dc1是主节点
/*! mycat:createCluster{
"clusterType":"MASTER_SLAVE",
"heartbeat":{
"heartbeatTimeout":1000,
"maxRetry":3,
"minSwitchTimeInterval":300,
"slaveThreshold":0
},
"masters":[
"dc1" //主节点
],
"maxCon":200,
"name":"c0",
"readBalanceType":"BALANCE_ALL",
"replicas":[
"dc2" //从节点
],
"switchType":"SWITCH"
} */
删除集群
/*! mycat:dropCluster{ "name":"c0"} */;
显示集群
/*+ mycat:showClusters{} */