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