MyCAT从入门到实战（MyCAT2注释配置）

重置配置

/*+ 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{} */