本文共 2144 字,大约阅读时间需要 7 分钟。
sharding.jdbc.dataSource.names=db-test0,db-test1,db-test2# 配置主库sharding.jdbc.dataSource.db-test0.type=com.alibaba.druid.pool.DruidDataSourcesharding.jdbc.dataSource.db-test0.driverClassName=com.mysql.jdbc.Driversharding.jdbc.dataSource.db-test0.url=jdbc:mysql://172.18.0.220:3306/cool?useUnicode=true&characterEncoding=utf8&tinyInt1isBit=false&useSSL=false&serverTimezone=GMTsharding.jdbc.dataSource.db-test0.username=rootsharding.jdbc.dataSource.db-test0.password=sharding.jdbc.dataSource.db-test0.maxPoolSize=20# 配置第一个从库sharding.jdbc.dataSource.db-test1.type=com.alibaba.druid.pool.DruidDataSourcesharding.jdbc.dataSource.db-test1.driverClassName=com.mysql.jdbc.Driversharding.jdbc.dataSource.db-test1.url=jdbc:mysql://172.18.250.231:3306/cool?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMTsharding.jdbc.dataSource.db-test1.username=rootsharding.jdbc.dataSource.db-test1.password=sharding.jdbc.dataSource.db-test1.maxPoolSize=20# 配置第二个从库sharding.jdbc.dataSource.db-test2.type=com.alibaba.druid.pool.DruidDataSourcesharding.jdbc.dataSource.db-test2.driverClassName=com.mysql.jdbc.Driversharding.jdbc.dataSource.db-test2.url=jdbc:mysql://172.18.9.166:3306/cool?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMTsharding.jdbc.dataSource.db-test2.username=rootsharding.jdbc.dataSource.db-test2.password=sharding.jdbc.dataSource.db-test2.maxPoolSize=20# 配置从库选择策略,提供轮询与随机,这里选择用轮询//random 随机 //round_robin 轮询sharding.jdbc.config.masterslave.load-balance-algorithm-type=round_robinsharding.jdbc.config.masterslave.name=db1s2sharding.jdbc.config.masterslave.master-data-source-name=db-test0sharding.jdbc.config.masterslave.slave-data-source-names=db-test1,db-test2#开启SQL显示,默认值: false,注意:仅配置读写分离时不会打印日志!!!sharding.jdbc.props.sql.show=trueserver.port=8085mybatis.config-location=classpath:META-INF/mybatis-config.xml
在玩转读写分离时,遇到如下几个需要注意的地方
转载地址:http://vzgai.baihongyu.com/