部署sharding-proxy

sharding-proxy 在windows的部署过程：
1. 下载zookeeper-3.4.6，配置conf/zoo.cfg文件，主要修改数据存储路径：

tickTime=2000

initLimit=10

syncLimit=5

dataDir=D:\zookeeper-3.4.6\data 

clientPort=2181

2. 启动zookeeper. 直接点击bin/zkServer.cmd 文件。
3. 解压sharding-proxy-3.0.0.tar.gz文件，配置conf/server.yaml:

orchestration:

  name: orchestration_ds

  overwrite: true

  registry:

    serverLists: 127.0.0.1:2181

    namespace: orchestration

 

authentication:

  username: root

  password: root

4. 配置sharding-proxy的conf/config-sharding.yaml:

schemaName: sharding_db

 

dataSources:

  ds_0:

    url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false

    username: root

    password: 123456

    autoCommit: true

    connectionTimeout: 30000

    idleTimeout: 60000

    maxLifetime: 1800000

    maximumPoolSize: 50

  ds_1:

    url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false

    username: root

    password: 123456

    autoCommit: true

    connectionTimeout: 30000

    idleTimeout: 60000

    maxLifetime: 1800000

    maximumPoolSize: 50

 

shardingRule:

  tables:

    t_order:

      actualDataNodes: ds_$->{0..1}.t_order

      tableStrategy:

        inline:

          shardingColumn: user_id

          algorithmExpression: ds_$->{user_id % 2}

      keyGeneratorColumnName: order_id

    t_order_item:

      actualDataNodes: ds_$->{0..1}.t_order_item

      tableStrategy:

        inline:

          shardingColumn: user_id

          algorithmExpression: ds_$->{user_id % 2}

      keyGeneratorColumnName: order_item_id

  bindingTables:

    - t_order,t_order_item

5. 启动sharding-proxy, 点击bin/start.bat

启动过程中，如果jdk版本高于1.9，去掉bin/start.bat文件中此参数：-XX:+UseFastAccessorMethods 

 6. 启动完成后，用Navicat连接，端点默认为：3307