mycat2.0配置读写分离

最新推荐文章于 2024-08-15 18:37:55 发布

为爱停留

最新推荐文章于 2024-08-15 18:37:55 发布

阅读量2k

点赞数

分类专栏： mysql 文章标签： mycat

本文链接：https://blog.csdn.net/beiduofen2011/article/details/122124833

版权

mysql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

执行mysql -uroot -p123456 -h172.17.0.1 -P8066 进入mycat的交互界面：

1、配置数据源：

/*+ mycat:createDataSource{
"name":"two",
"url":"jdbc:mysql://172.17.0.3:3306",
"user":"root",
"password":"123456"
} */;

mycat/conf/datasources就会多出一个文件：two.datasource.json

{
	"dbType":"mysql",
	"idleTimeout":60000,
	"initSqls":[],
	"initSqlsGetConnection":true,
	"instanceType":"READ_WRITE",
	"maxCon":1000,
	"maxConnectTimeout":30000,
	"maxRetryCount":5,
	"minCon":1,
	"name":"two",
	"password":"123456",
	"queryTimeout":30,
	"type":"JDBC",
	"url":"jdbc:mysql://172.17.0.3:3306?useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=UTF-8&autoReconnect=true",
	"user":"root",
	"weight":0
}

2、配置集群：

/*! mycat:createCluster{"name":"prototype","masters":["prototypeDs"],"replicas":["two"]} */;

/opt/mycat/mycat/conf/clusters 下的prototype.cluster.json中的数据会被修改

{
	"clusterType":"MASTER_SLAVE",
	"heartbeat":{
		"heartbeatTimeout":1000,
		"maxRetryCount":3,
		"minSwitchTimeInterval":300,
		"slaveThreshold":0.0
	},
	"masters":[
		"prototypeDs"
	],
	"maxCon":2000,
	"name":"prototype",
	"readBalanceType":"BALANCE_ALL",
	"replicas":[
		"two"
	],
	"switchType":"SWITCH"
}

3、查看集群状态