环境:
Os:Centos 7
版本:5.5.2
说明:
使用二进制分发包启动 Proxy，需要环境具备 Java JRE 8 或更高版本。
[root@localhost shardingsphere-proxy]# java -version
java version "1.8.0_361"
Java(TM) SE Runtime Environment (build 1.8.0_361-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.361-b09, mixed mode)
You have new mail in /var/spool/mail/root
1.下载
下载地址
https://archive.apache.org/dist/shardingsphere/5.5.2/
下载的文件如下:
apache-shardingsphere-5.5.2-shardingsphere-proxy-bin.tar.gz
2.下载jdk
可以在oracle官网下载,我这里下载的文件如下:
mysql-connector-java-8.0.11.tar.gz
3.解压安装
[root@localhost shardingsphere-proxy]#tar -xvf apache-shardingsphere-5.5.2-shardingsphere-proxy-bin.tar.gz
[root@localhost shardingsphere-proxy]#mv apache-shardingsphere-5.5.2-shardingsphere-proxy-bin /opt/shardingsphere-proxy
4.使用默认配置
在使用默认配置之前，最好备份一下
[root@localhost conf]#cd /opt/shardingsphere-proxy/conf
[root@localhost conf]#cp global.yaml global.yaml.bak
[root@localhost conf]#cp database-sharding.yaml database-sharding_db.yaml.bak
5.配置global.yaml
global.yaml主要是进行通用配置,如模式、用户权限等。
我因为是在本地部署,所以使用了 Standalone单机部署。
如果是生产环境,推荐使用Cluster集群部署.
######################################################################################################
#
# If you want to configure governance, authorization and proxy properties, please refer to this file.
#
######################################################################################################
#
mode:type: Standalonerepository:type: JDBC
# props:
# namespace: governance_ds
# server-lists: localhost:2181
# retryIntervalMilliseconds: 500
# timeToLiveSeconds: 60
# maxRetries: 3
# operationTimeoutMilliseconds: 500
#
authority:users:- user: root@%password: hxl3040admin: true
# - user: sharding
# password: shardingprivilege:type: ALL_PERMITTED
#
#transaction:
# defaultType: XA
# providerType: Atomikos
#
#sqlParser:
# sqlStatementCache:
# initialCapacity: 2000
# maximumSize: 65535
# parseTreeCache:
# initialCapacity: 128
# maximumSize: 1024
#
#logging:
# loggers:
# - loggerName: ShardingSphere-SQL
# additivity: true
# level: INFO
# props:
# enable: false
#
#sqlFederation:
# sqlFederationEnabled: false
# executionPlanCache:
# initialCapacity: 2000
# maximumSize: 65535
#
#props:
# system-log-level: INFO
# max-connections-size-per-query: 1
# kernel-executor-size: 16 # Infinite by default.
# proxy-frontend-flush-threshold: 128 # The default value is 128.
# # sql-show is the same as props in logger ShardingSphere-SQL, and its priority is lower than logging rule
# sql-show: false
# check-table-metadata-enabled: false
# # Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.
# # The default value is -1, which means set the minimum value for different JDBC drivers.
# proxy-backend-query-fetch-size: -1
# proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.
# proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.
# proxy-default-port: 3307 # Proxy default port.
# proxy-netty-backlog: 1024 # Proxy netty backlog.
# cdc-server-port: 33071 # CDC server port
# proxy-frontend-ssl-enabled: false
# proxy-frontend-ssl-cipher: ''
# proxy-frontend-ssl-version: TLSv1.2,TLSv1.3
6.配置分片规则
more /opt/shardingsphere-proxy/conf/database-sharding.yaml
######################################################################################################
#
# If you want to connect to MySQL, you should manually copy MySQL driver to lib directory.
#
######################################################################################################databaseName: hxl_sharding_dbdataSources:ds_0:url: jdbc:mysql://192.168.1.113:3306/db_test?useSSL=false
username: rootpassword: hxl3040connectionTimeoutMilliseconds: 30000idleTimeoutMilliseconds: 60000maxLifetimeMilliseconds: 1800000maxPoolSize: 50minPoolSize: 1
# ds_1:
# url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?useSSL=false
# username: root
# password:
# connectionTimeoutMilliseconds: 30000
# idleTimeoutMilliseconds: 60000
# maxLifetimeMilliseconds: 1800000
# maxPoolSize: 50
# minPoolSize: 1
#
rules:
- !SHARDINGtables:t_order:actualDataNodes: ds_0.t_order_${0..9} ##通过proxy会创建0-9共10个表tableStrategy:standard:shardingColumn: order_idshardingAlgorithmName: t_order_inlinekeyGenerateStrategy:column: order_idkeyGeneratorName: snowflakeauditStrategy:auditorNames:- sharding_key_required_auditorallowHintDisable: true
# t_order_item:
# actualDataNodes: ds_${0..1}.t_order_item_${0..1}
# tableStrategy:
# standard:
# shardingColumn: order_id
# shardingAlgorithmName: t_order_item_inline
# keyGenerateStrategy:
# column: order_item_id
# keyGeneratorName: snowflake
# bindingTables:
# - t_order,t_order_item
# defaultDatabaseStrategy:
# standard:
# shardingColumn: user_id
# shardingAlgorithmName: database_inline
# defaultTableStrategy:
# none:defaultAuditStrategy:auditorNames:- sharding_key_required_auditorallowHintDisable: true
#shardingAlgorithms:
# database_inline:
# type: INLINE
# props:
# algorithm-expression: ds_${user_id % 2}t_order_inline:type: INLINEprops:algorithm-expression: t_order_${order_id % 10}
# t_order_item_inline:
# type: INLINE
# props:
# algorithm-expression: t_order_item_${order_id % 2}
#keyGenerators:snowflake:type: SNOWFLAKEauditors:sharding_key_required_auditor:type: DML_SHARDING_CONDITIONS
#
#- !BROADCAST
# tables:
# - t_address
7.引入MySQL依赖
在sharding-proxy 路径下新建 ext-lib 目录，将 mysql-connector-java-8.0.11.jar 驱动包放进来.
[root@localhost shardingsphere-proxy]# cd /opt/shardingsphere-proxy
[root@localhost shardingsphere-proxy]# mkdir ext-lib
[root@localhost mysql-connector-java-8.0.11]# cp mysql-connector-java-8.0.11.jar /opt/shardingsphere-proxy/ext-lib/
8.启动
验证各种场景
8.1 实际的数据库不存在
启动/停止服务
# 启动
/opt/shardingsphere-proxy/bin/start.sh
报错:
[ERROR] 2026-02-06 10:25:40.879 [main] com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Exception during pool initialization.
java.sql.SQLSyntaxErrorException: Unknown database 'db_test11'
8.2 实际表不存在
# 启动
/opt/shardingsphere-proxy/bin/start.sh
实际的表不存在,可以启动成功的
9.通过 shardingproxy 创建表
启动shardingproxy 会启动的3307端口,需要通过3307端口连接shardingproxy
192.168.1.14
[root@hxl-mysql-211 ~]# /data/middle/mysql57/bin/mysql -h 192.168.1.14 -uroot -pyeemiao3040 -P3307
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.7.22-ShardingSphere-Proxy 5.5.2 Source distributionCopyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database |
+--------------------+
| hxl_sharding_db |
| information_schema |
| mysql |
| performance_schema |
| shardingsphere |
| sys |
+--------------------+
6 rows in set (0.02 sec)mysql> use hxl_sharding_db;
Database changed
mysql> show tables;
Empty set (0.00 sec)