前言:此文承接上文的mysql 主从服务配置
https://blog.csdn.net/YL3126/article/details/122170589
docker镜像地址:
https://hub.docker.com/r/apache/sharding-proxy
2、docker 安装 sharding proxy
下载镜像【这里重点说明一下,一定要使用我这里试验过的 4.1.0 版本 和 相关的配置项 ,随便从网上去摘抄 配置文件 你会起不来服务的!!!】
docker pull apache/sharding-proxy:4.1.0
安装容器并运行
docker run --name=sharding_proxy_4_1_0 -d -v /mydata/sharding_proxy/conf:/opt/sharding-proxy/conf -v /mydata/sharding_proxy/ext-lib:/opt/sharding-proxy/ext-lib --env PORT=3408 -p13408:3408 apache/sharding-proxy:4.1.0
运行后我们查看一下宿主机的映射目录:嗯,没啥问题
自行下载MYSQ 的驱动包,放到 映射目录中,如我的:
下载地址:https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-5.1.47.tar.gz
下面开始改配置文件(不要随便去从网上摘抄,根本起不来):
(可以直接参考官网手册):https://shardingsphere.apache.org/document/4.1.0/en/manual/sharding-proxy/configuration/
2、配置
配置数据分片+读写分离
config-sharding.yaml
schemaName: sharding_db
dataSources:
ds0:
username: root
password: root
url: jdbc:mysql://192.168.56.10:3307/ds0?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
ds0_slave0:
username: root
password: root
url: jdbc:mysql://192.168.56.10:3317/ds0?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
ds1:
username: root
password: root
url: jdbc