ShardingProxy

 ShardingProxy服务部署

相关文件请参考https://gitee.com/dromara/RuoYi-Cloud-Plus/tree/2.X/script/docker/shardingproxy

需要修改数据库相关配置，涉及文件 config-sharding.yaml【实际数据库】、server.yaml【逻辑数据库】

docker-compose.yml

version: '3'
services:
  shardingproxy:
    image: apache/shardingsphere-proxy:5.4.0
    container_name: shardingProxy
    ports:
      - "3307:3307"
    volumes:
      - /opt/app/shardingProxy/conf:/opt/shardingsphere-proxy/conf
      - /opt/app/shardingProxy/ext-lib:/opt/shardingsphere-proxy/ext-lib
    environment:
      JVM_OPTS: "-Djava.awt.headless=true"

 

应用程序配置

spring:
  datasource:
    dynamic:
      primary: master
      datasource:
        # 主库数据源
        master:
          type: ${spring.datasource.type}
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: ${datasource.test-service.url}
          username: ${datasource.test-service.username}
          password: ${datasource.test-service.password}